public static object SExecuteScalar(string sql, params object[] parameter)
 {
     using (DB db = new DB())
     {
         return db.ExecuteScalar(sql, parameter);
     }
 }

    //在数据表Resources插入一条记录操作
    protected bool InsertDataBase()
    {
        bool result = false;

        using (SqlConnection conn = new DB().GetConnection())
        {
            //向resources插入一条记录操作
            StringBuilder sb = new StringBuilder("Insert into Resources (ResourceName,FileName,FilePath,FileSizeInKB,FileType,Extentsion,FolderID,FolderName,UserID,CDT,Status,UserName)");
            sb.Append(" values(@ResourceName,@FileName,@FilePath,@FileSize,@FileType,@Extentsion,@FolderID,@FolderName,@UserID,@CDT,@Status,@UserName)");
            SqlCommand cmd = new SqlCommand(sb.ToString(), conn);
            //cmd.Parameters.AddWithValue("@ResourceName", TextBox1.Text);
            cmd.Parameters.AddWithValue("@ResourceName", TextBox1.Text.Trim());
            cmd.Parameters.AddWithValue("@FileName", FN.Text);
            cmd.Parameters.AddWithValue("@FilePath", FP.Text);
            cmd.Parameters.AddWithValue("@FileSize", FS.Text);
            cmd.Parameters.AddWithValue("@FileType", ResourceTypeLabel.Text);
            cmd.Parameters.AddWithValue("@Extentsion", FET.Text);
            cmd.Parameters.AddWithValue("@FolderID", 0);
            cmd.Parameters.AddWithValue("@FolderName", "");
            cmd.Parameters.AddWithValue("@UserID", Session["UserID"].ToString());
            cmd.Parameters.AddWithValue("@UserName", Session["UserName"].ToString());
            cmd.Parameters.AddWithValue("@CDT", DateTime.Now);
            cmd.Parameters.AddWithValue("@Status", 0);
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
            //插入成功
            result = true;
        }
        return result;
    }

        public bool Save(DB.Stru.事务科.专项救助_低保边缘户 stru)
        {
            string strID =  Orm.Save(stru);
            stru.ID = strID;

            return ! String.IsNullOrEmpty(strID);
        }

        public bool Save(DB.Stru.福利中心.老人费用退费管理 stru)
        {
            string strID =  Orm.Save(stru);
            stru.ID = strID;

            return ! String.IsNullOrEmpty(strID);
        }

		/**
		 * Fetches info needed from the database.
		 */
		private RevisionWorkInfo getWorkInfo(DB db, int revisionWorkID, int workID) {
			using (var cmd = db.CreateCommand ()) {
				cmd.CommandText = @"
					SELECT revision.revision, lane.id, lane.repository, lane.lane
					FROM revisionwork
					INNER JOIN revision ON revision.id = revisionwork.revision_id
					INNER JOIN lane ON lane.id = revision.lane_id
					WHERE revisionwork.id = @rwID;

					SELECT command.command
					FROM work
					INNER JOIN command ON command.id = work.command_id
					WHERE work.id = @wID
				";
				DB.CreateParameter (cmd, "rwID", revisionWorkID);
				DB.CreateParameter (cmd, "wID", workID);
				using (var reader = cmd.ExecuteReader ()) {
					RevisionWorkInfo info;

					reader.Read ();

					info.hash = reader.GetString (0);
					info.laneID = reader.GetInt32 (1);
					info.repoURL = reader.GetString (2);
					info.laneName = reader.GetString (3);

					reader.NextResult ();
					reader.Read ();

					info.command = reader.GetString (0);

					return info;
				}
			}
		}

 protected void confirm_Click(object sender, EventArgs e)///首先判断该人员是否已经安排过值班
 {
     DB db = new DB();
     string str = "SELECT jobskyerID FROM dutyTimeTable";
     string jobskyerID = chooseName.SelectedValue;
     SqlConnection con = new SqlConnection();
     con = db.GetCon();
     SqlCommand com = new SqlCommand(str, con);
     SqlDataAdapter da = new SqlDataAdapter(com);
     DataSet ds = new DataSet();
     da.Fill(ds);
     ///SqlDataReader dr = com.ExecuteReader();
     int k = ds.Tables[0].Rows.Count;
     for (int i = 0; i < k; ++i)
     {
         if (jobskyerID == ds.Tables[0].Rows[i]["jobskyerID"].ToString())
         {
             Update_DutyTime();
         }
         if (i == k)
         {
             Insert_DutyTime();
         }
     }
 }

 public bool Update_DutyTime()///如果选择了安排过值班的人，就更新值班安排数据
 {
     DB db = new DB();
     string dutyInTime = chooseWeekday.SelectedValue + chooseSignInTime.SelectedValue;
     string dutyOutTime = chooseWeekday.SelectedValue + chooseSignOutTime.SelectedValue;
     string str = "UPDATE dutyTimeTable SET [email protected],[email protected] WHERE [email protected]";
     SqlConnection con = new SqlConnection();
     con = db.GetCon();
     SqlCommand com = new SqlCommand(str, con);
     com.Parameters.Add("@dutyInTime", SqlDbType.DateTime, 0).Value = dutyInTime;
     com.Parameters.Add("@dutyOutTime", SqlDbType.DateTime, 0).Value = dutyOutTime;
     com.Parameters.Add("@jobskyerID", SqlDbType.DateTime, 0).Value = chooseName.SelectedValue;
     try
     {
         com.ExecuteNonQuery();
         Sign_Result.Text = "更新值班成功！";
     }
     catch (Exception ex)
     {
         Sign_Result.Text = "更新值班失败！";
         return false;
     }
     finally
     {
         com.Dispose();
         con.Close();
     }
     return true;
 }

 public string GetJobName(object jobskyerID)             //把jobskyerID转化为jobName输出
 {
     DB db = new DB();
     SqlDataReader dr = db.reDr("SELECT jobName FROM jobskyer WHERE jobskyerID='" + jobskyerID + "'");
     dr.Read();
     return dr.GetValue(0).ToString();
 }

        public void SetData( DB.Stru.优抚科.优抚对象.伤残人员.基本信息 stru )
        {
            txt行政区划.Text = stru.行政区划;
            txt身份证号码.Text = stru.身份证号码 ;
            dat出生日期.strDate = stru.出生日期 ;
            cmb伤残等级.Text = stru.伤残等级 ;
            cmb伤残属别.Text = stru.伤残属别 ;
            dat参加工作时间.Text = stru.入伍时间 ;
            cmb劳动能力.Text = stru.劳动能力 ;
            cmb就业情况.Text = stru.就业情况 ;
            cmb户口簿住址类别.Text = stru.户口簿住址类别 ;

            txt姓名.Text = stru.姓名;
            cmb民族.Text = stru.民族;
            cmb性别.Text = stru.性别 ;
            cmb伤残性质.Text = stru.伤残性质;
            cmb婚姻状况.Text = stru.婚姻状况;
            dat退伍时间.strDate = stru.退伍时间 ;
            cmb生活能力.Text = stru.生活能力 ;
            cmb户口类别.Text = stru.户口类别 ;
            txt联系电话.Text = stru.联系电话 ;

            txt工作单位.Text = stru.工作单位 ;
            txt户口簿地址.Text = stru.户口簿住址 ;
            txt实际居住地地址.Text = stru.实际居住地址 ;
            txt备注.Text = stru.备注 ;
        }

    protected void Button1_Click(object sender, EventArgs e)
    {
        int i = 0;
        using (SqlConnection conn = new DB().GetConnection())
        {
            SqlCommand cmd = conn.CreateCommand();
            cmd.CommandText = "Delete from SubMenu where ID in (" + IDSLabel.Text + ") ";
            conn.Open();
            i = cmd.ExecuteNonQuery();
            cmd.Dispose();

            cmd.CommandText = "select * from SubMenu where ID in (" + IDSLabel.Text + ") order by ID desc";
            SqlDataReader rd = cmd.ExecuteReader();
            GridView1.DataSource = rd;
            GridView1.DataBind();
            rd.Close();
            conn.Close();

        }
        if (i > 0)
        {
            ResultLabel.Text = "成功删除！";
            ResultLabel.ForeColor = System.Drawing.Color.Green;

        }
        else
        {
            ResultLabel.Text = "操作失败，请重试！";
            ResultLabel.ForeColor = System.Drawing.Color.Red;
        }
    }

        private bool Add_Update()
        {
            try
            {

                DB DataBase = new DB("Categories");

                DataBase.AddColumn("cat_name", Category_TB.Text.Trim());

                if(Category_Id == null)
                {
                    if(DataBase.IsNotExist("cat_id", "cat_name"))
                    {
                        return Confirm.Check(DataBase.Insert());
                    }
                    else
                    {
                        Message.Show("لقد تم تسجيل هذه الفئة من قبل", MessageBoxButton.OK, 5);
                        return false;
                    }


                }
                else
                {
                    DataBase.AddCondition("cat_id", this.Category_Id);
                    return Confirm.Check(DataBase.Update());
                }
            }
            catch
            {
                //MessageBox.Show("kiki_method");
                return false;
            }
        }

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            int RoleID = Convert.ToInt16(Session["RoleID"].ToString());

            if (Session["RoleID"] == null || Session["UserID"] == null)
            {
                Util.ShowMessage("用户登录超时，请重新登录！", "Login2.aspx");
            }
            else if (RoleID > 1)
            {
                Util.ShowMessage("您没有访问该页面的权限！", "Login2.aspx");
            }
          else
          {
          UserName.Focus();
          using (SqlConnection conn = new DB().GetConnection())
          {
            string sql1 = "select * from Roles order by ID asc";
            SqlCommand cmd1 = new SqlCommand(sql1, conn);
            conn.Open();
            SqlDataReader rd1 = cmd1.ExecuteReader();
            Role.DataSource = rd1;
            Role.DataTextField = "RoleName";
            Role.DataValueField = "ID";
            Role.DataBind();
            rd1.Close();
          }
            }

        }
    }

        protected string clearLine()
        {
            bool result = false;
            string line = Request.Form["line"];

            if (!string.IsNullOrEmpty(line) && line != "all")
            {
                using (DB db = new DB())
                {
                    List<DowntimeData> list = (from o in db.DowntimeDataSet
                                               where o.Client == "admin"
                                               && o.Line == line
                                               select o).ToList();

                    if (list.Count() > 0)
                    {
                        foreach (DowntimeData dt in list)
                        {
                            db.DeleteObject(dt);
                        }
                    }

                    result = db.SaveChanges() > 0;
                }
            }

            return result.ToString();
        }

 public static int SInsert(string sql, params object[] parameter)
 {
     using (DB db = new DB())
     {
         return db.Insert(sql, parameter);
     }
 }

    public bool ScoreRankList_Bind()///下拉列表绑定数据
    {
        DB db = new DB();
        string sql_game = "SELECT * FROM GAME ";
        SqlConnection con = new SqlConnection();
        con = db.GetCon();
        con.Open();
        SqlCommand cmd = new SqlCommand(sql_game, con);
        SqlDataReader sqlRead_Game = cmd.ExecuteReader();
        try
        {
            ScoreRankList.DataSource = sqlRead_Game;
            ScoreRankList.DataTextField = "gamName";
            ScoreRankList.DataValueField = "gameID";
            ScoreRankList.DataBind();
            ScoreRankList.Items.Add(new ListItem("请选择","-1"));
            ScoreRankList.SelectedValue = "-1";

        }
        catch (Exception ex)
        {
            return false;
        }
        finally
        {
            cmd.Dispose();
            con.Close();
        }
        return true;
    }

        public bool GetData( ref DB.Stru.优抚科.优抚对象.伤残人员.基本信息 stru )
        {
            if ( !CheckBeforeSave() )
                return false;

            stru.行政区划 = txt行政区划.Text.Trim();
            stru.身份证号码 = txt身份证号码.Text.Trim();
            stru.出生日期 = dat出生日期.strDate;
            stru.伤残等级 = cmb伤残等级.Text.Trim();
            stru.伤残属别 = cmb伤残属别.Text.Trim();
            stru.入伍时间 = dat参加工作时间.Text.Trim();
            stru.劳动能力 = cmb劳动能力.Text.Trim();
            stru.就业情况 = cmb就业情况.Text.Trim();
            stru.户口簿住址类别 = cmb户口簿住址类别.Text.Trim();

            stru.姓名 = txt姓名.Text.Trim();
            stru.民族 = cmb民族.Text.Trim();
            stru.性别 = cmb性别.Text.Trim();
            stru.伤残性质 = cmb伤残性质.Text.Trim();
            stru.婚姻状况 = cmb婚姻状况.Text.Trim();
            stru.退伍时间 = dat退伍时间.strDate;
            stru.生活能力 = cmb生活能力.Text.Trim();
            stru.户口类别 = cmb户口类别.Text.Trim();
            stru.联系电话 = txt联系电话.Text.Trim();

            stru.工作单位 = txt工作单位.Text.Trim();
            stru.户口簿住址 = txt户口簿地址.Text.Trim();
            stru.实际居住地址 = txt实际居住地地址.Text.Trim();
            stru.备注 = txt备注.Text.Trim();

            return true;
        }

 public bool ScoreRank_Bind()///分数排行绑定数据
 {
     DB db = new DB();
     string scoreRankstr = "SELECT GAME_RECORD.jobskyerID,gamScore,jobName FROM GAME_RECORD,JOBSKYER WHERE GAME_RECORD.jobskyerID=JOBSKYER.jobskyerID ORDER BY gamScore desc";
     SqlConnection con = new SqlConnection();
     con = db.GetCon();
     con.Open();
     SqlCommand com = new SqlCommand(scoreRankstr, con);
     SqlDataReader dr = com.ExecuteReader();
     try
     {
         ScoreRank.DataSource = dr;
         ScoreRank.DataBind();
     }  
     catch(Exception ex)
     {
         return false;
     }  
     finally
     {
         com.Dispose();
         con.Close();
     }
     return true;
 }

    protected void Page_Load(object sender, EventArgs e)
    {
        Hashtable State = (Hashtable)HttpRuntime.Cache[Session.SessionID];
        if (State == null || State.Count <= 2) { Page.ClientScript.RegisterStartupScript(this.GetType(), Guid.NewGuid().ToString(), "timeOut('../Default.aspx');", true); return; }

        DB db = new DB();
        string sql = "SELECT * FROM stock_images WHERE ";
        if (State["SelectedAppType"].ToString() == Constants.WEB_APP_TYPE || State["SelectedAppType"].ToString() == Constants.HYBRID_APP_TYPE)
            sql += "type='jquery_buttons' or type='blank_buttons'";
        else
            sql += "type='blank_buttons'";
        DataRow[] rows = db.ViziAppsExecuteSql(State, sql);
        DataSet paramsDS = new DataSet("ParameterDataSet");
        DataTable paramTable = paramsDS.Tables.Add("ParamTable");
        DataColumn paramCol = paramTable.Columns.Add("image_url", typeof(String));

        foreach (DataRow row in rows)
        {
            string type = row["type"].ToString();
            string url = row["image_url"].ToString();

            DataRow paramRow = paramTable.NewRow();
            string[] row_array = new string[1];
            row_array[0] = url;
            paramRow.ItemArray = row_array;
            paramTable.Rows.Add(paramRow);
        }

        ParamRepeater.DataSource = paramsDS;
        ParamRepeater.DataBind();
        db.CloseViziAppsDatabase((Hashtable)HttpRuntime.Cache[Session.SessionID]);
    }

 public bool Insert_DutyTime()///如果选择了没有安排过值班的人，就插入值班安排数据
 {
     string dutyInTime = chooseWeekday.SelectedValue + chooseSignInTime.SelectedValue;
     string dutyOutTime = chooseWeekday.SelectedValue + chooseSignOutTime.SelectedValue;
     string InsertStr = "INSERT INTO dutyTimeTable(dutyInTime,dutyOutTime,jobskyerID)VALUES(@dutyInTime,@dutyOutTime,@jobskyerID)";
     DB db = new DB();
     SqlConnection con = new SqlConnection();
     con = db.GetCon();
     con.Open();
     SqlCommand com = new SqlCommand(InsertStr, con);
     com.Parameters.Add("@dutyInTime", SqlDbType.DateTime, 0).Value = Convert.ToDateTime(dutyInTime);
     com.Parameters.Add("@dutyOutTime", SqlDbType.DateTime, 0).Value = Convert.ToDateTime(dutyOutTime);
     com.Parameters.Add("@jobskyerID", SqlDbType.NChar, 0).Value = chooseName.SelectedValue;
     try
     {
         com.ExecuteNonQuery();
         Sign_Result.Text = "安排值班成功！";
     }
     catch (Exception ex)
     {
         Sign_Result.Text = "安排值班失败！";
         return false;
     }
     finally
     {
         com.Dispose();
         con.Close();
     }
     return true;
 }

    void ProcessResponse(string response)
    {
        if (response != "[]") {
            response = response.Trim (new Char[] { '{', '}' });
            string[] response_exploded = response.Split (',');

            DB db = new DB ();
            db.Connect ();

            foreach (string pair in response_exploded) {
                string[] key_value = pair.Split (':');
                string ext_id = key_value [1].Trim (new Char[]{'"'});
                string id = key_value [0].Trim (new Char[]{'"'});
                string query = "UPDATE participantes SET external_id = " + ext_id + " WHERE id = " + id;
                db.dbcmd.CommandText = query;
                if (db.dbcmd.ExecuteNonQuery () == 1) {
                    Debug.Log ("Exportado participante id local " + id + " a la id externa " + ext_id);
                }
            }

            db.Disconnect ();
        } else {
            Debug.Log ("No se exportó ningun participante nuevo");
        }

        GameObject.Find ("Button Export").GetComponent<Button> ().interactable = true;
    }