private void Binddata() { DataTable dt = new SqlServerHelper().GetDataTable("waterUserType", "", "waterUserTypeId"); ControlBindHelper.BindComboBoxData(this.waterUserTypeId, dt, "waterUserTypeName", "waterUserTypeId"); DataTable dt2 = new SqlServerHelper().GetDataTable("waterUserHouseType", "", "waterUserHouseTypeID"); ControlBindHelper.BindComboBoxData(this.waterUserHouseType, dt2, "waterUserHouseType", "waterUserHouseTypeID"); if (string.IsNullOrEmpty(key)) { userName.Text = strRealName; toolEdit.Enabled = false; } else { Hashtable ht = new SqlServerHelper().GetHashtableById("Meter_Install_Single", "SingleID", key); new SqlServerHelper().BindHashTableToForm(ht, this.groupBox6.Controls); Btn_Submit.Enabled = FlowFunction.IsAllowEdit(taskid); waterUserNO.Enabled = false; waterUserNO.ReadOnly = true; toolEdit.Enabled = true; } }
public void InitData() { DataTable dt = new SqlServerHelper().GetDataTable("waterMeterSize", "", "waterMeterSizeId"); ControlBindHelper.BindComboBoxData(this.waterMeterSizeId, dt, "waterMeterSizeValue", "waterMeterSizeId"); dt = new SqlServerHelper().GetDataTable("Meter_Summary", "", "ID"); ControlBindHelper.BindComboBoxData(this.isSummaryMeter, dt, "Value", "ID"); dt = new SqlServerHelper().GetDataTable("waterMeterType", "", "waterMeterTypeId"); ControlBindHelper.BindComboBoxData(this.waterMeterTypeId, dt, "waterMeterTypeValue", "waterMeterTypeId"); dt = new SqlServerHelper().GetDataTable("waterMeterType", "", "waterMeterTypeId"); ControlBindHelper.BindComboBoxData(this.waterMeterTypeIdChange, dt, "waterMeterTypeValue", "waterMeterTypeId"); dt = new SqlServerHelper().GetDataTable("Meter_waterMeterState", "", "waterMeterStateID"); ControlBindHelper.BindComboBoxData(this.waterMeterState, dt, "waterMeterState", "waterMeterStateID"); dt = new SqlServerHelper().GetDataTable("V_WATERUSER_CONNECTWATERMETER", " isSummaryMeter='2'", "waterUserName"); ControlBindHelper.BindComboBoxData(this.waterMeterParentId, dt, "waterUserName", "waterMeterId", true); Hashtable ht = new SqlServerHelper().GetHashtableById("Meter", "MeterID", _MeterID); new SqlServerHelper().BindHashTableToForm(ht, this.Controls); }
private void BindCombox() { DataTable dt = new SqlServerHelper().GetDataTable("waterUserType", "", "waterUserTypeId"); ControlBindHelper.BindComboBoxData(this.waterUserTypeId, dt, "waterUserTypeName", "waterUserTypeId"); DataTable dt2 = new SqlServerHelper().GetDataTable("waterMeterType", "", "waterMeterTypeId"); ControlBindHelper.BindComboBoxData(this.waterMeterTypeId, dt2, "waterMeterTypeValue", "waterMeterTypeId"); DataTable dt3 = new SqlServerHelper().GetDataTable("waterUserHouseType", "", "waterUserHouseTypeID"); ControlBindHelper.BindComboBoxData(this.waterUserHouseTypeID, dt3, "waterUserHouseType", "waterUserHouseTypeID"); if (GM.waterUserTypeId != null) { Hashtable ht = new Hashtable(); ht["GROUPPEOPLEID"] = GM.GroupPeopleID; ht["WATERMETERTYPEID"] = GM.waterMeterTypeId; ht["WATERUSERTYPEID"] = GM.waterUserTypeId; ht["WATERUSERHOUSETYPEID"] = GM.waterUserHouseTypeID; ht["USERCOUNT_APPLY"] = GM.UserCount_Apply; ht["ISBOOT"] = GM.IsBoot; new SqlServerHelper().BindHashTableToForm(ht, this.panel1.Controls); } }
private void FrmApprove_Group_MeterSize_Load(object sender, EventArgs e) { string _SelectedSize = "'"; DataTable dt = new DataTable(); if (SelectedMeter.GroupMeterSize_Items != null) { if (SelectedMeter.GroupMeterSize_Items.Count > 0) { foreach (GroupMeterSize ms in SelectedMeter.GroupMeterSize_Items) { _SelectedSize += ms.waterMeterSizeId + "','"; } } _SelectedSize = _SelectedSize.TrimEnd('\''); _SelectedSize = _SelectedSize.TrimEnd(','); if (string.IsNullOrEmpty(_SelectedSize)) { dt = new SqlServerHelper().GetDataTable("waterMeterSize", "", "waterMeterSizeId"); } else { dt = new SqlServerHelper().GetDataTable("waterMeterSize", " waterMeterSizeId NOT IN (" + _SelectedSize + ")", "waterMeterSizeId"); } } else { dt = new SqlServerHelper().GetDataTable("waterMeterSize", "", "waterMeterSizeId"); } ControlBindHelper.BindComboBoxData(this.waterMeterSizeId, dt, "waterMeterSizeValue", "waterMeterSizeId"); }
private void InitView() { Hashtable ht = new SqlServerHelper().GetHashtableById("Meter_WorkResolve", "ResolveID", ResolveID); if (ht != null) { UserOpinion.Text = ht["USEROPINION"].ToString().Trim(); if (ht["MAKESKIP"] != null && ht["MAKEPOINTID"] != null)//是否显示跳转 { skip = (bool)ht["MAKESKIP"]; if (skip) { IsSkip.Visible = true; LB_GoPointID.Visible = true; CB_GoPointID.Visible = true; string sqlstr = string.Format("SELECT PointName,PointSort FROM Meter_WorkPoint WHERE WorkFlowID='{0}' AND PointSort IN ({1}) ORDER BY PointSort", ht["WORKFLOWID"].ToString(), ht["GOPOINTID"].ToString()); DataTable dt = new SqlServerHelper().GetDateTableBySql(sqlstr); ControlBindHelper.BindComboBoxData(this.CB_GoPointID, dt, "PointName", "PointSort"); } } if (!string.IsNullOrEmpty(ht["ISVOIDED"].ToString()))//是否显示报废 { bool isvisable = false; if (bool.TryParse(ht["ISVOIDED"].ToString(), out isvisable)) { Btn_Voided.Visible = isvisable; } } } }
private void BindUser() { string sqlstr_Task = "SELECT DISTINCT userName,loginId FROM ApproveLog"; DataTable dt2 = new SqlServerHelper().GetDateTableBySql(sqlstr_Task); ControlBindHelper.BindComboBoxData(this.CB_loginId, dt2, "userName", "loginId", true); }
private void BindTask() { string sqlstr_Task = "SELECT DISTINCT Table_Name_CH,TableID FROM View_TABLEUNION ORDER BY TableID"; DataTable dt2 = new SqlServerHelper().GetDateTableBySql(sqlstr_Task); ControlBindHelper.BindComboBoxData(this.CB_TaskCode, dt2, "Table_Name_CH", "TableID", true); }
private void BindState() { string sqlstr_Task = "SELECT DISTINCT State,CASE STATE WHEN 1 THEN '审批中' WHEN 2 THEN '挂起' WHEN 3 THEN '跳转' WHEN 4 THEN '作废' WHEN 5 THEN '结束' ELSE '未知' END AS STATES FROM ApproveLog"; DataTable dt2 = new SqlServerHelper().GetDateTableBySql(sqlstr_Task); ControlBindHelper.BindComboBoxData(this.CB_State, dt2, "STATES", "State", true); }
private void BindCombox() { DataTable dt = new SqlServerHelper().GetDataTable("waterMeterType", "", "waterMeterTypeId"); ControlBindHelper.BindComboBoxData(this.waterMeterTypeId, dt, "waterMeterTypeValue", "waterMeterTypeId"); dt = new SqlServerHelper().GetDataTable("waterMeterType", "", "waterMeterTypeId"); ControlBindHelper.BindComboBoxData(this.waterMeterType_New, dt, "waterMeterTypeValue", "waterMeterTypeId"); }
private void BindCombox() { DataTable dt2 = new SqlServerHelper().GetDataTable("Meter_WorkFlowState", "", "ID"); ControlBindHelper.BindComboBoxData(this.State, dt2, "Value", "ID"); AddTreeNode("0", null); }
private void BindCombox() { //DataTable dt = new SqlServerHelper().GetDataTable("V_METERREADING", "", "meterReadingID"); //ControlBindHelper.BindComboBoxData(this.meterReadingID, dt, "meterReadingNO", "meterReadingID");//抄表本:meterReadingNO;区域:areaName DataTable dt = new SqlServerHelper().GetDataTable("BASE_BANK", "", "bankId"); ControlBindHelper.BindComboBoxData(this.bankId, dt, "bankName", "bankId", true); dt = new SqlServerHelper().GetDataTable("User_Agentsign", "", "Agentsign"); ControlBindHelper.BindComboBoxData(this.agentsign, dt, "Agent", "Agentsign"); this.agentsign.SelectedIndex = 1; dt = new SqlServerHelper().GetDataTable("User_ChargeType", "", "ChargeType"); ControlBindHelper.BindComboBoxData(this.chargeType, dt, "Charge", "ChargeType"); this.chargeType.SelectedIndex = 1; dt = new SqlServerHelper().GetDataTable("BASE_PIAN", "PARENTID<>'0'", "PIANID"); ControlBindHelper.BindComboBoxData(this.PIANID, dt, "PIANNAME", "PIANID"); dt = new SqlServerHelper().GetDataTable("BASE_AREA", "areaId<>'0'", "areaName"); ControlBindHelper.BindComboBoxData(this.areaId, dt, "areaName", "areaId"); dt = new SqlServerHelper().GetDataTable("BASE_DUAN", "PARENTID<>'0'", "DUANNAME"); ControlBindHelper.BindComboBoxData(this.DUANID, dt, "DUANNAME", "DUANID"); dt = new SqlServerHelper().GetDataTable("Base_Archives", "", "CreateTypeID"); ControlBindHelper.BindComboBoxData(this.CreateTypeID, dt, "CreateType", "CreateTypeID"); dt = new SqlServerHelper().GetDataTable("BASE_COMMUNITY", "PARENTID<>'0'", "COMMUNITYNAME"); ControlBindHelper.BindComboBoxData(this.COMMUNITYID, dt, "COMMUNITYNAME", "COMMUNITYID"); dt = new SqlServerHelper().GetDataTable("base_login", "isMeterReader=1", "userName"); ControlBindHelper.BindComboBoxData(this.meterReaderID, dt, "userName", "loginId"); dt = new SqlServerHelper().GetDataTable("base_login", "isCharger=1", "userName"); ControlBindHelper.BindComboBoxData(this.chargerID, dt, "userName", "loginId"); Hashtable hp = new SqlServerHelper().GetHashtableById("Meter_Install_Single", "TaskID", TaskID); new SqlServerHelper().BindHashTableToForm(hp, this.PL.Controls); _waterUserId = hp["WATERUSERID"].ToString(); dt = sysidal.GetUserMaterByTaskID(TaskID); if (DataTableHelper.IsExistRows(dt)) { foreach (DataRow dr in dt.Rows) { _MeterList.Add(dr["MeterID"].ToString()); } LB_MeterInfo.Text = "水表数量:" + dt.Rows.Count; } Hashtable Hps = new SqlServerHelper().GetHashtableById("Meter_WorkResolve", "ResolveID", ResolveID); Btn_Submit.Enabled = string.IsNullOrEmpty(Hps["ISPASS"].ToString()) ? true : bool.Parse(Hps["ISPASS"].ToString()) ? false : true; }
private void InitView() { Hashtable hu = new SqlServerHelper().GetHashtableById("Meter_Install_Group", "TaskID", TaskID); if (hu.Contains("METERCOUNT")) { _GroupID = hu["GROUPID"].ToString(); if (!string.IsNullOrEmpty(hu["METERCOUNT"].ToString())) { _MeterCount = int.Parse(hu["METERCOUNT"].ToString()); MeterCount.Text = hu["METERCOUNT"].ToString(); BindMeterSize(); } } Hashtable ht = new SqlServerHelper().GetHashtableById("Meter_WorkResolve", "ResolveID", ResolveID); if (ht != null) { UserOpinion.Text = ht["USEROPINION"].ToString().Trim(); if (ht["MAKESKIP"] != null && ht["MAKEPOINTID"] != null)//是否显示跳转 { skip = (bool)ht["MAKESKIP"]; if (skip) { IsSkip.Visible = true; LB_GoPointID.Visible = true; CB_GoPointID.Visible = true; string sqlstr = string.Format("SELECT PointName,PointSort FROM Meter_WorkPoint WHERE WorkFlowID='{0}' AND PointSort IN ({1}) ORDER BY PointSort", ht["WORKFLOWID"].ToString(), ht["GOPOINTID"].ToString()); DataTable dt = new SqlServerHelper().GetDateTableBySql(sqlstr); ControlBindHelper.BindComboBoxData(this.CB_GoPointID, dt, "PointName", "PointSort"); } } if (!string.IsNullOrEmpty(ht["ISVOIDED"].ToString()))//是否显示报废 { bool isvisable = false; if (bool.TryParse(ht["ISVOIDED"].ToString(), out isvisable)) { Btn_Voided.Visible = isvisable; } } if (!string.IsNullOrEmpty(ht["ISCHARGE"].ToString())) { if (bool.TryParse(ht["ISCHARGE"].ToString(), out IsCharge)) { FP_Fee.Visible = IsCharge; //添加收费项目 if (IsCharge) { FP_Fee.Controls.Clear(); ApproveDispose.BindFeeItemTextBox(this.FP_Fee, ResolveID); } } } } }
public void Init() { DataTable dt = new SqlServerHelper().GetDateTableBySql("SELECT * FROM CHARGETYPE "); ControlBindHelper.BindComboBoxData(this.CB_CHARGETYPEID, dt, "CHARGETYPENAME", "CHARGETYPEID", true); dt = new SqlServerHelper().GetDateTableBySql("SELECT USERNAME,LOGINID FROM V_LOGIN WHERE isCharger='1'"); ControlBindHelper.BindComboBoxData(this.CB_CHARGEWORKERID, dt, "USERNAME", "LOGINID", true); }
private void BindData() { ControlBindHelper.BindComboBoxData(this.CB_ID, fdal.GetTableList(), "Table_Name_CH", "TableID", true); ControlBindHelper.BindComboBoxData(this.CB_Month, fdal.GetChargeMonth(), "CreateMonthVALUE", "CreateMonth", true); ControlBindHelper.BindComboBoxData(this.CB_Day, fdal.GetChargeDay(), "CreateDayVALUE", "CreateDay", true); ShowData(); }
public void Init() { DataTable dt = new SqlServerHelper().GetDateTableBySql("SELECT DISTINCT loginId, userName FROM Meter_WorkDo WHERE (loginId IS NOT NULL) AND (loginId <> '') AND (userName <> '')"); ControlBindHelper.BindComboBoxData(this.CB_loginId, dt, "userName", "loginId", true); DataTable dt2 = new SqlServerHelper().GetDataTable("Meter_WorkTaskState", "[ID] <>0", "ID"); ControlBindHelper.BindComboBoxData(this.CB_State, dt2, "Value", "ID", true); }
private void BindCombox() { DataTable dt1 = new SqlServerHelper().GetDataTable("base_department", "", "departmentID"); ControlBindHelper.BindComboBoxData(this.DepartementID, dt1, "departmentName", "departmentID"); DataTable dt2 = new SqlServerHelper().GetDataTable("Meter_WorkFlowState", "", "ID"); ControlBindHelper.BindComboBoxData(this.State, dt2, "Value", "ID"); }
private void BindData() { DataTable dt = new SqlServerHelper().GetDateTableBySql(@"SELECT DISTINCT Meter_Table.TableID,Meter_Table.Table_Name_CH FROM View_WorkBase,Meter_Table WHERE View_WorkBase.TableID=Meter_Table.TableID AND View_WorkBase.[State]=5 AND TaskID IN (SELECT TaskID FROM View_TaskFee WHERE StateS=1 AND IsFinal=0 AND [State]=5)"); ControlBindHelper.BindComboBoxData(this.CB_ID, dt, "Table_Name_CH", "TableID", true); dt = new SqlServerHelper().GetDateTableBySql("SELECT DISTINCT CreateMonth,CreateMonth AS CreateMonthVALUE FROM View_TaskFee WHERE StateS=1 AND IsFinal=0 AND [State]=5"); ControlBindHelper.BindComboBoxData(this.CB_Month, dt, "CreateMonthVALUE", "CreateMonth", true); ShowData(); }
private void Binddata() { DataTable dt = new SqlServerHelper().GetDataTable("waterMeterSize", "", "waterMeterSizeId"); ControlBindHelper.BindComboBoxData(this.waterMeterSizeId, dt, "waterMeterSizeValue", "waterMeterSizeId"); DataTable dt2 = new SqlServerHelper().GetDataTable("MeterState", "", "ID"); ControlBindHelper.BindComboBoxData(this.MeterState, dt2, "StateDescribe", "ID"); initData(); }
private void BindInvoiceBatch() { DataTable dt = new SqlServerHelper().GetDateTableBySql("SELECT DISTINCT INVOICEBATCHNAME,INVOICEFETCHBATCHID FROM V_INVOICE_FETCH WHERE ISENABLE='1' ORDER BY INVOICEFETCHBATCHID DESC"); ControlBindHelper.BindComboBoxData(this.cmbBatch, dt, "INVOICEBATCHNAME", "INVOICEFETCHBATCHID"); if (dt.Rows.Count == 0) { MessageBox.Show("从发票领用记录表内未检测到可用的发票,发票将无法打印!"); chkReceipt_CheckedChanged(null, null); } }
private void BindCombox() { DataTable dt2 = new SqlServerHelper().GetDataTable("Meter_WorkFlowState", "", "ID"); ControlBindHelper.BindComboBoxData(this.State, dt2, "Value", "ID"); AddTreeNode("0", null); FlowLib FL = new FlowLib(); FL.GetFlowTree("0"); ControlBindHelper.BindComboBoxData(this.ParentID, FL.DtFlowTree, "WorkName", "WorkFlowID", true); }
private void TV_Point_AfterSelect(object sender, TreeViewEventArgs e) { if (e.Node == null) { return; } sPointID = e.Node.Tag.ToString(); TV_Do.Nodes.Clear(); AddDoTreeNode(sPointID); DataTable dt3 = new SqlServerHelper().GetDataTable("Meter_WorkPoint", " WorkFlowID='" + sWorkFlowID + "'", "PointSort"); ControlBindHelper.BindComboBoxData(this.GoPointID, dt3, "PointName", "PointID"); }
private void BindData() { DataTable dt = new DataTable(); string sqlstr = @"SELECT DISTINCT ChargeMonth,ChargeMonth AS ChargeMonthVALUE FROM View_ChargeOver ORDER BY ChargeMonth DESC"; dt = new SqlServerHelper().GetDateTableBySql(sqlstr, new SqlParameter[] { new SqlParameter("@LoginID", strLogID) }); ControlBindHelper.BindComboBoxData(this.CB_Month, dt, "ChargeMonthVALUE", "ChargeMonth"); sqlstr = @"SELECT DISTINCT CHARGEWORKERID,CHARGEWORKERNAME FROM View_ChargeOver ORDER BY CHARGEWORKERID DESC"; dt = new SqlServerHelper().GetDateTableBySql(sqlstr, new SqlParameter[] { new SqlParameter("@LoginID", strLogID) }); ControlBindHelper.BindComboBoxData(this.CB_LogID, dt, "CHARGEWORKERNAME", "CHARGEWORKERID"); ShowData(); }
public void Init(string _loginId) { string sqlstr_LoginID = ""; string sqlstr_Task = ""; sqlstr_LoginID = AppDomain.CurrentDomain.GetData("GROUPID").ToString().Equals("0001")? "SELECT DISTINCT loginId, userName FROM Meter_WorkDo WHERE (loginId IS NOT NULL) AND (loginId <> '') AND (userName <> '')" : "SELECT DISTINCT loginId, userName FROM Meter_WorkDo WHERE loginId ='" + _loginId + "'"; DataTable dt = new SqlServerHelper().GetDateTableBySql(sqlstr_LoginID); ControlBindHelper.BindComboBoxData(this.CB_loginId, dt, "userName", "loginId", true); if (!AppDomain.CurrentDomain.GetData("GROUPID").ToString().Equals("0001")) { this.CB_loginId.SelectedValue = _loginId; this.CB_loginId.Enabled = false; } switch (_WrokType) { case 1: sqlstr_Task = "SELECT MW.TaskCode,MWR.WorkName FROM Meter_WorkTask MW,Meter_WorkResolve MWR WHERE MW.TaskID=MWR.TaskID AND MW.PointSort=MWR.PointSort"; break; case 2: sqlstr_Task = "SELECT MW.TaskCode,MWR.WorkName FROM Meter_WorkTask MW,Meter_WorkResolve MWR WHERE MW.TaskID=MWR.TaskID AND MW.PointSort=MWR.PointSort AND MW.[State]=" + _state + ""; break; case 3: sqlstr_Task = AppDomain.CurrentDomain.GetData("GROUPID").ToString().Equals("0001") ? "SELECT MW.TaskCode,MWR.WorkName FROM Meter_WorkTask MW,Meter_WorkResolve MWR WHERE MW.TaskID=MWR.TaskID AND MW.PointSort=MWR.PointSort" : "SELECT MW.TaskCode,MWR.WorkName FROM Meter_WorkTask MW,Meter_WorkResolve MWR WHERE MW.TaskID=MWR.TaskID AND MW.PointSort=MWR.PointSort AND ','+loginId+',' like '%,'+'" + _loginId + "'+',%'"; break; case 4: sqlstr_Task = AppDomain.CurrentDomain.GetData("GROUPID").ToString().Equals("0001") ? "SELECT MW.TaskCode,MWR.WorkName FROM Meter_WorkTask MW,Meter_WorkResolve MWR WHERE MW.TaskID=MWR.TaskID AND MW.PointSort=MWR.PointSort AND MW.[State]=" + _state + "" : "SELECT MW.TaskCode,MWR.WorkName FROM Meter_WorkTask MW,Meter_WorkResolve MWR WHERE MW.TaskID=MWR.TaskID AND MW.PointSort=MWR.PointSort AND ','+loginId+',' like '%,'+'" + _loginId + "'+',%' AND MW.[State]=" + _state + ""; break; case 5: sqlstr_Task = AppDomain.CurrentDomain.GetData("GROUPID").ToString().Equals("0001") ? "SELECT MW.TaskCode,MWR.WorkName FROM Meter_WorkTask MW,Meter_WorkResolve MWR WHERE MW.TaskID=MWR.TaskID AND MW.PointSort>MWR.PointSort AND MWR.IsPass IS NOT NULL" : "SELECT MW.TaskCode,MWR.WorkName FROM Meter_WorkTask MW,Meter_WorkResolve MWR WHERE MW.TaskID=MWR.TaskID AND MW.PointSort>MWR.PointSort AND ','+loginId+',' like '%,'+'" + _loginId + "'+',%' AND MWR.IsPass IS NOT NULL"; break; case 6: sqlstr_Task = AppDomain.CurrentDomain.GetData("GROUPID").ToString().Equals("0001") ? "SELECT MW.TaskCode,MWR.WorkName FROM Meter_WorkTask MW,Meter_WorkResolve MWR WHERE MW.TaskID=MWR.TaskID AND MWR.MakeVoided=1 AND MW.[State]=4" : "SELECT MW.TaskCode,MWR.WorkName FROM Meter_WorkTask MW,Meter_WorkResolve MWR WHERE MW.TaskID=MWR.TaskID AND MWR.MakeVoided=1 AND ','+loginId+',' like '%,'+'" + _loginId + "'+',%' AND MW.[State]=4"; break; default: break; } DataTable dt2 = new SqlServerHelper().GetDateTableBySql(sqlstr_Task); ControlBindHelper.BindComboBoxData(this.CB_TaskCode, dt2, "WorkName", "TaskCode", true); }
private void Binddata() { DataTable dt = new SqlServerHelper().GetDataTable("MeterState", "", "ID"); ControlBindHelper.BindComboBoxData(this.CB_MeterState, dt, "StateDescribe", "ID", true); DataTable dt2 = new SqlServerHelper().GetDataTable("waterMeterSize", "", "waterMeterSizeId"); ControlBindHelper.BindComboBoxData(this.CB_waterMeterSize, dt2, "waterMeterSizeValue", "waterMeterSizeId", true); DataTable dt3 = new SqlServerHelper().GetDataTable("View_MeterProduct", "", "waterMeterProduct"); ControlBindHelper.BindComboBoxData(this.CB_waterMeterProduct, dt3, "waterMeterProduct", "MeterID", true); }
private void InitData() { string sqlstr = "SELECT DISTINCT TableID,Table_Name_CH FROM View_TABLEUNION ORDER BY TableID"; DataTable dt = new SqlServerHelper().GetDateTableBySql(sqlstr); ControlBindHelper.BindComboBoxData(this.TableID, dt, "Table_Name_CH", "TableID"); sqlstr = "SELECT WATERMETERTYPECLASSID,WATERMETERTYPECLASSNAME FROM WATERMETERTYPECLASS"; dt = new SqlServerHelper().GetDateTableBySql(sqlstr); ControlBindHelper.BindComboBoxData(this.WaterMeterTypeClassID, dt, "WATERMETERTYPECLASSNAME", "WATERMETERTYPECLASSID"); sqlstr = " SELECT WorkCode,WorkName FROM Meter_WorkFlow WHERE ParentID <>'0' AND State=1"; dt = new SqlServerHelper().GetDateTableBySql(sqlstr); ControlBindHelper.BindComboBoxData(this.WorkCode, dt, "WorkName", "WorkCode"); }
public void InitData(string TaskID) { DataTable dt = new SqlServerHelper().GetDataTable("waterUserType", "", "waterUserTypeId"); ControlBindHelper.BindComboBoxData(this.waterUserTypeId, dt, "waterUserTypeName", "waterUserTypeId"); DataTable dt2 = new SqlServerHelper().GetDataTable("waterUserHouseType", "", "waterUserHouseTypeID"); ControlBindHelper.BindComboBoxData(this.waterUserHouseType, dt2, "waterUserHouseType", "waterUserHouseTypeID"); if (!string.IsNullOrEmpty(TaskID)) { Hashtable ht = sysidal.GetMeter_Install_PeccantInfos(TaskID); new SqlServerHelper().BindHashTableToForm(ht, this.gpMes.Controls); } }
public void Init() { DataTable dt = new SqlServerHelper().GetDateTableBySql("SELECT DISTINCT VT.loginId,B.userName FROM View_TABLEUNION VT,base_login B WHERE VT.loginId=B.loginId AND VT.State<>4 ORDER BY VT.loginId"); ControlBindHelper.BindComboBoxData(this.CB_loginId, dt, "userName", "loginId", true); DataTable dt2 = new SqlServerHelper().GetDataTable("Meter_WorkTaskState", "[ID] <>0", "ID"); ControlBindHelper.BindComboBoxData(this.CB_State, dt2, "Value", "ID", true); string sqlstr = "SELECT DISTINCT TableName,Table_Name_CH FROM View_TABLEUNION"; DataTable dt3 = new SqlServerHelper().GetDateTableBySql(sqlstr); ControlBindHelper.BindComboBoxData(this.CB_TableName, dt3, "Table_Name_CH", "TableName", true); }
private void FrmApprove_Group_MeterSelect_Load(object sender, EventArgs e) { DataTable dt = new SqlServerHelper().GetDataTable("waterMeterSize", "", "waterMeterSizeId"); ControlBindHelper.BindComboBoxData(this.waterMeterSizeId, dt, "waterMeterSizeValue", "waterMeterSizeId"); //if (!string.IsNullOrEmpty(MeterSizeId)) //{ // this.waterMeterSizeId.Text = MeterSize; // this.waterMeterSizeId.Enabled = false; //} if (!string.IsNullOrEmpty(GroupID)) { BindMeterSize(); } }
private void BindData() { DataTable dt = new DataTable(); string sqlstr = "SELECT DISTINCT Table_Name_CH,TableID FROM View_TABLEUNION"; dt = new SqlServerHelper().GetDateTableBySql(sqlstr); ControlBindHelper.BindComboBoxData(this.CB_ID, dt, "Table_Name_CH", "TableID", true); sqlstr = "SELECT DISTINCT CreateMonth,CreateMonth AS CreateMonthVALUE FROM View_TABLEUNION"; dt = new SqlServerHelper().GetDateTableBySql(sqlstr); ControlBindHelper.BindComboBoxData(this.CB_Month, dt, "CreateMonthVALUE", "CreateMonth", true); sqlstr = "SELECT DISTINCT CreateDay,CreateDay AS CreateDayVALUE FROM View_TABLEUNION"; dt = new SqlServerHelper().GetDateTableBySql(sqlstr); ControlBindHelper.BindComboBoxData(this.CB_Day, fdal.GetChargeDay(), "CreateDayVALUE", "CreateDay", true); ShowData(); }
private void BindUserInfo() { DataTable dt = new SqlServerHelper().GetDataTable("waterUserType", "", "waterUserTypeId"); ControlBindHelper.BindComboBoxData(this.waterUserTypeId, dt, "waterUserTypeName", "waterUserTypeId"); DataTable dt2 = new SqlServerHelper().GetDataTable("waterUserHouseType", "", "waterUserHouseTypeID"); ControlBindHelper.BindComboBoxData(this.waterUserHouseType, dt2, "waterUserHouseType", "waterUserHouseTypeID"); if (!string.IsNullOrEmpty(TaskID)) { Hashtable ht = sysidal.GetMeter_Install_SingleInfos(TaskID); new SqlServerHelper().BindHashTableToForm(ht, this.PL.Controls); } BindUserMeter(); }