private void DataBindGrid() { //int count = 0; //StringBuilder SqlWhere = new StringBuilder(); //IList<SqlParam> IList_param = new List<SqlParam>(); ////DataTable dt = DataFactory.SqlDataBase().GetDataTable("Base_ATS_OriDataIn"); //string sql = "select * from Base_PerLeaveApply where empid='" + EmpID + "' "; //StringBuilder sb_sql = new StringBuilder(sql); //// DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sb_sql); //DataTable dt = DataFactory.SqlDataBase().GetPageList(sql, null, "CreateDate", "asc", PageControl1.PageIndex, PageControl1.PageSize, ref count); //ControlBindHelper.BindRepeaterList(dt, rp_Item); //this.PageControl1.RecordCount = Convert.ToInt32(count); EmpID.Text = txt_EmpName; CreateDate.Text = DateTime.Now.ToShortDateString(); string sql = "select * from Base_ATS_LeaveSetting"; StringBuilder sb_sql = new StringBuilder(sql); DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sb_sql); LeaveID.DataSource = dt; LeaveID.DataTextField = "LeaveName"; LeaveID.DataValueField = "id"; LeaveID.DataBind(); njDays.Text = flo_njDays.ToString(); txDays.Text = flo_txDays.ToString(); }
private void InitData() { string sql = "select * from Base_ATS_LeaveSetting"; StringBuilder sb_sql = new StringBuilder(sql); DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sb_sql); LeaveID.DataSource = dt; LeaveID.DataTextField = "LeaveName"; LeaveID.DataValueField = "id"; LeaveID.DataBind(); Hashtable ht = DataFactory.SqlDataBase().GetHashtableById("Base_PerLeaveApply", "id", _key); if (ht.Count > 0 && ht != null) { if (ht["LEAVEID"].ToString() == "3") { CJform.Visible = true; } else { CJform.Visible = false; } ControlBindHelper.SetWebControls(this.Page, ht); EmpID.Text = GetNameFromID(EmpID.Text); //lab_CreateDate.Text = ""; BeginDate.Text = Convert.ToDateTime(BeginDate.Text).ToString("yyyy-MM-dd"); EndDate.Text = Convert.ToDateTime(EndDate.Text).ToString("yyyy-MM-dd"); if (ht["NCJ"].ToString() == "1") { cbNC.Checked = true; } else { cbNC.Checked = false; } if (ht["DBT"].ToString() == "1") { cbDBT.Checked = true; DBT.Text = ht["DBTNUM"].ToString(); } else { cbDBT.Checked = false; DBT.Text = "0"; } } njDays.Text = flo_njDays.ToString(); txDays.Text = flo_txDays.ToString(); }
private void InitData() { string sql = "select * from Base_ATS_LeaveSetting"; StringBuilder sb_sql = new StringBuilder(sql); DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sb_sql); LeaveID.DataSource = dt; LeaveID.DataTextField = "LeaveName"; LeaveID.DataValueField = "id"; LeaveID.DataBind(); Hashtable ht = DataFactory.SqlDataBase().GetHashtableById("Base_PerLeaveApply", "id", _key); if (ht.Count > 0 && ht != null) { ControlBindHelper.SetWebControls(this.Page, ht); strUserID = EmpID.Text; EmpID.Text = GetNameFromID(EmpID.Text); //lab_CreateDate.Text = ""; BeginDate.Text = Convert.ToDateTime(BeginDate.Text).ToString("yyyy-MM-dd"); EndDate.Text = Convert.ToDateTime(EndDate.Text).ToString("yyyy-MM-dd"); } }