private void FrmDisuse_Approve_Y_Shown(object sender, EventArgs e)
{
uC_ApproveList1.InitData(TaskID);
Hashtable htt = new SqlServerHelper().GetHashtableById("Meter_Disuse", "TaskID", TaskID);
if (htt.Contains("WATERUSERNO"))
{
_waterUserNO = htt["WATERUSERNO"].ToString();
uC_UserInfos1.InitData(_waterUserNO);
new SqlServerHelper().BindHashTableToForm(htt, this.panel1.Controls);
DataTable dt = sysiWb.GetWaterUserFee(_waterUserNO);
if (DataTableHelper.IsExistRows(dt))
{
Fee.Text = dt.Rows[0][0].ToString();
}
}
string FrmAssemblyName = string.Empty;
string FormName = string.Empty;
if (sysidal.GetAssemblyNameDetail(ht["ResolveID"].ToString(), ref FrmAssemblyName, ref FormName))
{
CreateForm.ShowPannel(FormName, FrmAssemblyName, PL_Proc, ht);
}
}
private void InitView()
{
Hashtable htt = new SqlServerHelper().GetHashtableById("Meter_WorkResolve", "ResolveID", ResolveID);
if (htt != null)
{
UserOpinion.Text = htt["USEROPINION"].ToString().Trim();
}
htt = new SqlServerHelper().GetHashtableById("Meter_Install_Group", "TaskID", TaskID);
if (htt.Contains("TASKID"))
{
_GroupID = htt["GROUPID"].ToString();
MeterCount1 = int.Parse(htt["METERCOUNT"].ToString());
DataTable dt = new SqlServerHelper().GetDataTable("Meter_GroupMeter", "GroupID='" + _GroupID + "'", "waterMeterSerialNumber");
if (DataTableHelper.IsExistRows(dt))
{
foreach (DataRow dr in dt.Rows)
{
SMeters.Add(dr["waterMeterSerialNumber"].ToString());
}
}
BindGroupMeter();
}
}
private void Btn_Search_Click(object sender, EventArgs e)
{
string _DisuseNO = DisuseNO.Text.Trim();
if (!string.IsNullOrEmpty(_DisuseNO))
{
Hashtable ht = new Hashtable();
ht = new SqlServerHelper().GetHashtableById("Meter_Disuse", "SD", _DisuseNO, "DisuserType=0 AND [STATE]=5");
ht["DISUSEDATE"] = ht["ACCEPTDATE"];
new SqlServerHelper().BindHashTableToForm(ht, this.panel1.Controls);
if (ht.Contains("WATERUSERNO"))
{
DataTable dt = sysidal.GetWaterUserFee(ht["WATERUSERNO"].ToString());
if (DataTableHelper.IsExistRows(dt))
{
LB_Fee.Text = dt.Rows[0][0].ToString();
LB_Num.Text = dt.Rows[0][1].ToString();
}
}
else
{
MessageBox.Show("没有相关用户的报停记录！");
}
}
}
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);
}
}
}
}
}
private void uC_DataGridView_Page1_CellDoubleClickEvents(object sender, DataGridViewCellEventArgs e)
{
DataGridView dgList = (DataGridView)sender;
if (dgList.CurrentRow != null)
{
object obj = dgList.CurrentRow.Cells["TaskID"].Value;
if (obj == null || obj == DBNull.Value)
{
return;
}
TaskID = dgList.CurrentRow.Cells["TaskID"].Value.ToString();
_IsFinal = bool.Parse(dgList.CurrentRow.Cells["IsFinal"].Value.ToString());
Hashtable ht = new SqlServerHelper().GetHashtableById("Meter_WorkTask", "TaskID", TaskID);
PointSort = ht["POINTSORT"].ToString();
Hashtable htt = new SqlServerHelper().GetHashtableById("View_WorkBase", "TaskID", TaskID);
if (htt.Contains("TABLENAME"))
{
TableName = htt["TABLENAME"].ToString();
}
string sqlstr = string.Format("SELECT * FROM Meter_WorkResolve MWR WHERE MWR.TaskID='{0}' AND PointSort={1} AND IsCashier=1 AND loginId LIKE '%{2}%'", TaskID, PointSort, AppDomain.CurrentDomain.GetData("LOGINID").ToString());
DataTable dt = new SqlServerHelper().GetDateTableBySql(sqlstr);
if (DataTableHelper.IsExistRows(dt))
{
ResolveID = dt.Rows[0]["ResolveID"].ToString();
if (_IsFinal)
{
FrmFinance_Receivable_OP frm = new FrmFinance_Receivable_OP();
frm.TaskID = TaskID;
frm.PointSort = PointSort;
frm.ResolveID = ResolveID;
frm.TableName = TableName;
if (frm.ShowDialog() == DialogResult.OK)
{
ShowData();
}
}
else
{
FrmFinance_Receivable_JS frm = new FrmFinance_Receivable_JS();
frm.TaskID = TaskID;
frm.PointSort = PointSort;
frm.ResolveID = ResolveID;
frm.TableName = TableName;
if (frm.ShowDialog() == DialogResult.OK)
{
ShowData();
}
}
}
}
}
private void InitData()
{
if (!string.IsNullOrEmpty(BlackID))
{
Hashtable ht = new SqlServerHelper().GetHashtableById("User_BlackList", "BlackID", BlackID);
new SqlServerHelper().BindHashTableToForm(ht, this.panel2.Controls);
if (ht.Contains("LOGINID"))
{
strLogID = AppDomain.CurrentDomain.GetData("LOGINID").ToString();
this.panel1.Visible = strLogID.Equals(ht["LOGINID"].ToString());
}
}
}
public void InitData(string waterUserNO)
{
if (!string.IsNullOrEmpty(waterUserNO))
{
Hashtable ht = sysidal.GetWaterUserInfoByWaterUserNO(waterUserNO);
new SqlServerHelper().BindHashTableToForm(ht, this.panel2.Controls);
Hashtable hts = new SqlServerHelper().GetHashtableById("V_WATERMETER", "waterUserId", waterUserNO);
if (hts.Contains("WATERMETERSIZEVALUE"))
{
TB_WATERMETERSIZEVALUE.Text = hts["WATERMETERSIZEVALUE"].ToString();
}
}
}
private void FrmUnsubscribe_Approve_Shown(object sender, EventArgs e)
{
uC_ApproveList1.InitData(TaskID);
Hashtable htt = new SqlServerHelper().GetHashtableById("User_Unsubscribe", "TaskID", TaskID);
if (htt.Contains("WATERUSERNO"))
{
_waterUserNO = htt["WATERUSERNO"].ToString();
uC_UserInfos1.InitData(_waterUserNO);
new SqlServerHelper().BindHashTableToForm(htt, this.panel1.Controls);
}
string FrmAssemblyName = string.Empty;
string FormName = string.Empty;
if (sysidal.GetAssemblyNameDetail(ht["ResolveID"].ToString(), ref FrmAssemblyName, ref FormName))
{
CreateForm.ShowPannel(FormName, FrmAssemblyName, PL_Proc, ht);
}
}
private void Btn_Submit_Click(object sender, EventArgs e)
{
Btn_Submit.Enabled = false;
Hashtable Htask = new Hashtable();
Htask = new SqlServerHelper().GetHashtableById("Meter_Disuse", "TaskID", TaskID);
if (Htask.Contains("DISUSERTYPE"))
{
_DisuserType = int.Parse(Htask["DISUSERTYPE"].ToString());
}
Hashtable Hm = new Hashtable();
Hm["WATERMETERSTATE"] = _DisuserType == 0 ? 5 : 6;; //5--欠费停水；6-违章停水
if (new SqlServerHelper().Submit_AddOrEdit("waterMeter", "waterUserId", _waterUserId, Hm))
{
//_DisuserType //0-欠费；1-违章
Hashtable HL = new Hashtable();
HL["LOGTYPE"] = 2; //2-水表日志
HL["LOGCONTENT"] = string.Format("{2}报停-水表入库-用户号：{0};水表编号：{1}", _waterUserId, _waterMeterId, _DisuserType == 0 ? "欠费" : _DisuserType == 1 ? "违章" : "其它");
HL["LOGDATETIME"] = DateTime.Now.ToString();
HL["OPERATORID"] = AppDomain.CurrentDomain.GetData("LOGINID").ToString();
HL["OPERATORNAME"] = AppDomain.CurrentDomain.GetData("USERNAME").ToString();
HL["MEMO"] = TaskID;
new SqlServerHelper().Submit_AddOrEdit("OPERATORLOG", "LOGID", "", HL);
int count = sysidal.UpdateApprove_defalut("Meter_Disuse", ResolveID, true, UserOpinion.Text.Trim(), PointSort, TaskID, "【水表报停】-水表编号：" + _waterMeterId + "");
if (count > 0)
{
MessageBox.Show("审批成功！");
}
else
{
MessageBox.Show("审批失败！");
Btn_Submit.Enabled = true;
}
}
}
private void InitView()
{
Hashtable htt = new SqlServerHelper().GetHashtableById("Meter_WorkResolve", "ResolveID", ResolveID);
if (htt != null)
{
UserOpinion.Text = htt["USEROPINION"].ToString().Trim();
}
htt = new SqlServerHelper().GetHashtableById("Meter_Install_Group", "TaskID", TaskID);
if (htt.Contains("TASKID"))
{
_GroupID = htt["GROUPID"].ToString();
WaterUserPeopleCount = int.Parse(htt["WATERUSERPEOPLECOUNT"].ToString());
_GroupAddress = htt["WATERUSERADDRESS"].ToString();
FP.Controls.Clear();
DataTable dt = sysidal.GetMeter_Group_People(_GroupID, 2);
if (!DataTableHelper.IsExistRows(dt))
{
dt = sysidal.GetMeter_Group_People(_GroupID, 0);
}
BindGroupUser(dt);
}
}
/// <summary>
/// 打印收条
/// </summary>
/// <param name="TaskID"></param>
/// <param name="_LastPointSort"></param>
private void PrintReceipt(string TaskID, string _LastPointSort)
{
//获取用户基本信息
Hashtable ht = new SqlServerHelper().GetHashtableById("View_WorkBase", "TaskID", TaskID);
if (ht.Contains("SD"))
{
string _waterUserId = ht["WATERUSERID"].ToString();
string _waterUserName = ht["WATERUSERNAME"].ToString();
string _SD = ht["SD"].ToString();
string _waterUserAddress = ht["WATERUSERADDRESS"].ToString();
string _TotalFee_CH = "";//合计大写
//获取费用合计
string sqlstr = @"SELECT * FROM
(SELECT SUM(FEE) AS FEE,InvoiceType AS FEENAME,'0' AS SORT FROM
(SELECT FEE,(SELECT InvoiceTitle FROM Meter_FeeItmes WHERE FeeID=MWF.FeeID) AS InvoiceType FROM Meter_WorkResolveFee MWF,Meter_WorkResolve MWR
WHERE MWF.ResolveID=MWR.ResolveID AND MWF.[STATE]=1
AND MWR.TaskID=@TaskID AND PointSort=@LastPoingSort
) T GROUP BY InvoiceType
UNION ALL
SELECT SUM(CONVERT(decimal,Fee)),'合计','1' FROM Meter_WorkResolveFee MWF,Meter_WorkResolve MWR
WHERE MWF.ResolveID=MWR.ResolveID AND MWF.[STATE]=1
AND MWR.TaskID=@TaskID AND PointSort=@LastPoingSort) M WHERE FEE<>0";
//FEE--收费金额
//FEENAME--收费名称
DataTable dt = new SqlServerHelper().GetDateTableBySql(sqlstr, new SqlParameter[] { new SqlParameter("@TaskID", TaskID), new SqlParameter("@LastPoingSort", _LastPointSort) });
if (DataTableHelper.IsExistRows(dt))
{
DataRow[] DR = dt.Select("SORT=1");
if (DR.Length.Equals(1))
{
_TotalFee_CH = RMBHelper.CmycurD(decimal.Parse(DR[0]["FEE"].ToString()));
}
//====================================打印
DataSet ds = new DataSet();
DataTable dtTemp = dt.Copy();
dtTemp.TableName = "收据模板";
ds.Tables.Add(dtTemp);
FastReport.Report report1 = new FastReport.Report();
try
{
// load the existing report
report1.Load(Application.StartupPath + @"\PRINTModel\业扩模板\业扩预算收据模板.frx");
(report1.FindObject("txtReceiptNO") as FastReport.TextObject).Text = "NO." + RECEIPTNO.Text;
(report1.FindObject("txtWaterUserNO") as FastReport.TextObject).Text = "用 户 号:" + _waterUserId;
(report1.FindObject("txtSD") as FastReport.TextObject).Text = "受理编号:" + _SD;
(report1.FindObject("txtWaterUserName") as FastReport.TextObject).Text = "用户名称:" + _waterUserName;
(report1.FindObject("txtWaterUserAddress") as FastReport.TextObject).Text = "地 址:" + _waterUserAddress;
(report1.FindObject("txtCapMoney") as FastReport.TextObject).Text = "金额大写:" + _TotalFee_CH;
(report1.FindObject("txtCasher") as FastReport.TextObject).Text = "收 款 员:" + strRealName;
(report1.FindObject("txtReceiptNO1") as FastReport.TextObject).Text = "NO." + RECEIPTNO.Text;
(report1.FindObject("txtWaterUserNO1") as FastReport.TextObject).Text = "用 户 号:" + _waterUserId;
(report1.FindObject("txtSD1") as FastReport.TextObject).Text = "受理编号:" + _SD;
(report1.FindObject("txtWaterUserName1") as FastReport.TextObject).Text = "用户名称:" + _waterUserName;
(report1.FindObject("txtWaterUserAddress1") as FastReport.TextObject).Text = "地 址:" + _waterUserAddress;
(report1.FindObject("txtCapMoney1") as FastReport.TextObject).Text = "金额大写:" + _TotalFee_CH;
(report1.FindObject("txtCasher1") as FastReport.TextObject).Text = "收 款 员:" + strRealName;
// register the dataset
report1.RegisterData(ds);
report1.GetDataSource("收据模板").Enabled = true;
//report1.Show();
report1.PrintSettings.ShowDialog = false;
report1.Prepare();
report1.Print();
}
catch (Exception ex)
{
mes.Show("收据打印失败:" + ex.Message);
}
}
}
}