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();
}
