void UD_Button_Open_Click(object sender, EventArgs e)
{
UC_DepartmentFee UD = (UC_DepartmentFee)sender;
FP_Items.Controls.Clear();
_SelectResolveID = UD.ResolveID;
strFeeDepartMent = UD.DepartmentName;
dtFeeItems = sysidal.GetDepartMentFeeItems(_SelectResolveID);
if (DataTableHelper.IsExistRows(dtFeeItems))
{
_FeeItems = "";
foreach (DataRow dr in dtFeeItems.Rows)
{
UC_ChargeItem UC = new UC_ChargeItem();
UC.FeeItem = string.Format("{0}:{1}元;", dr["FeeItem"].ToString().Trim(), dr["Fee"].ToString());
_FeeItems += string.Format("{0}:{1};", dr["FeeItem"].ToString().Trim(), dr["Fee"].ToString());
FP_Items.Controls.Add(UC);
}
_BCSS = string.IsNullOrEmpty(dtFeeItems.Rows[0]["FinalTotalFee"].ToString()) ? 0m : Convert.ToDecimal(dtFeeItems.Rows[0]["FinalTotalFee"].ToString());
TOTALCHARGE.Text = _BCSS.ToString();
CHARGEBCSS.Text = TOTALCHARGE.Text;
}
}
public static void BindLastFeeItems(Control FP_Items, string TaskID, string PointSort, out decimal TotalFee, out bool IsFinal, out int LastPointSort, out int state, out string items)
{
TotalFee = 0m;
IsFinal = false;
LastPointSort = 0;
state = 0;
items = "";
DataTable dt = sysidal.GetLastFeeItems(TaskID, PointSort);
if (DataTableHelper.IsExistRows(dt))
{
IsFinal = !Convert.ToBoolean(dt.Rows[0]["IsFinal"].ToString());
LastPointSort = int.Parse(dt.Rows[0]["PointSort"].ToString());
state = int.Parse(dt.Rows[0]["State"].ToString());
FP_Items.Height = ((dt.Rows.Count + 2) / 3) * 33;
foreach (DataRow dr in dt.Rows)
{
decimal _fee = 0m;
if (decimal.TryParse(dr["Fee"].ToString(), out _fee))
{
TotalFee += _fee;
}
UC_ChargeItem UC = new UC_ChargeItem();
UC.FeeItem = string.Format("{0}:{1}元;", dr["FeeItem"].ToString().Trim(), dr["Fee"].ToString());
items += string.Format("{0}:{1};", dr["FeeItem"].ToString().Trim(), dr["Fee"].ToString());
FP_Items.Controls.Add(UC);
}
items.TrimEnd(';');
}
}
public static void BindFeeItemLabel(Control FP_Items, string TaskID, string PointSort)
{
DataTable dt = sysidal.GetDataTableLastApproveFee(TaskID, PointSort);
if (DataTableHelper.IsExistRows(dt))
{
FP_Items.Height = ((dt.Rows.Count + 2) / 3) * 33;
foreach (DataRow dr in dt.Rows)
{
UC_ChargeItem UC = new UC_ChargeItem();
UC.FeeItem = string.Format("{0}:{1}元;", dr["FeeItem"].ToString().Trim(), dr["Fee"].ToString());
FP_Items.Controls.Add(UC);
}
}
}
void UD_Button_Open_Click(object sender, EventArgs e)
{
UC_DepartmentFee UD = (UC_DepartmentFee)sender;
_State = UD.STATE;
FP_Items.Controls.Clear();
_SelectResolveID = UD.ResolveID;
DataTable dt = sysidal.GetDepartMentFinalFeeItems(_SelectResolveID);
if (DataTableHelper.IsExistRows(dt))
{
_PrintFeeItems = new string[dt.Rows.Count];
_FeeItems = "";
int _index = 0;
foreach (DataRow dr in dt.Rows)
{
UC_ChargeItem UC = new UC_ChargeItem();
UC.FeeItem = string.Format("{0}:{1}元;", dr["FeeItem"].ToString().Trim(), dr["Fee"].ToString());
_FeeItems += string.Format("{0}:{1};", dr["FeeItem"].ToString().Trim(), dr["Fee"].ToString());
_YuCun = dr["IsPrestore"].ToString().Equals("1") ? decimal.Parse(dr["Fee"].ToString()) : 0m;
string _FeeItemDetail = GetPrintFee(dr["FeeID"].ToString(), dr["Fee"].ToString());
if (!string.IsNullOrEmpty(_FeeItemDetail))
{
_PrintFeeItems[_index] = _FeeItemDetail;
_index++;
}
FP_Items.Controls.Add(UC);
}
_DepTotalFee = UD.STATE != 0 ? 0 : UD.TotalFee;
TOTALCHARGE.Text = _DepTotalFee.ToString();
_DepPrestore = sysidal.GetDepartmentPrestoreFinal(TaskID, int.Parse(_LastPointSort), UD.DepartementID);
prestore.Text = _DepPrestore.ToString();
_BCYS = UD.STATE != 0 ? 0m : _DepTotalFee - _DepPrestore;
CHARGEBCYS.Text = _BCYS.ToString();
CHARGEBCSS.Text = _BCYS.ToString();
//if (_DepTotalFee > 0m)
//{
// // Btn_Settle.Enabled = true;
// Btn_Settle.Visible = true;
// Btn_Print.Visible = true;
// // Btn_Print.Enabled = true;
//}
//else
//{
// Btn_Settle.Visible = false;
// Btn_Print.Visible = false;
//}
if (_State == 0)
{
if (_BCYS == 0m)
{
Btn_Settle.Visible = true;
Btn_Print.Visible = false;
}
else
{
Btn_Settle.Visible = false;
Btn_Print.Visible = true;
}
}
else
{
Btn_Settle.Visible = false;
Btn_Print.Visible = false;
}
//else
//{
// CHARGEBCSS.Text = "0";
//}
}
}
private void ShowData()
{
string sqlstr = "SELECT MC.*,CT.CHARGETYPENAME,CC.CHARGEClASSNAME,CASE WHEN MC.MONTHCHECKSTATE=0 THEN '-' ELSE '已审核' END AS MONTHCHECKSTATENAME FROM Meter_Charge MC,CHARGETYPE CT,CHARGEClASS CC WHERE MC.CHARGETYPEID=CT.CHARGETYPEID AND MC.CHARGEClASS=CC.CHARGEClASS AND MC.CHARGEID=@CHARGEID";
DataTable dt = new SqlServerHelper().GetDateTableBySql(sqlstr, new SqlParameter[] { new SqlParameter("@CHARGEID", _ChargeID) });
Hashtable ht = DataTableHelper.DataTableToHashtable(dt);
new SqlServerHelper().BindHashTableToForm(ht, this.panel1.Controls);
ht = new SqlServerHelper().GetHashtableById("View_WorkBase", "TaskID", TaskID);
new SqlServerHelper().BindHashTableToForm(ht, this.panel2.Controls);
dt = new SqlServerHelper().GetDataTable("Meter_WorkResolveFee", "ChargeID='" + _ChargeID + "'", "ChargeDate");
FP.Controls.Clear();
if (DataTableHelper.IsExistRows(dt))
{
//显示结算类型
object objIsFinal = dt.Rows[0]["IsFinal"];
if (objIsFinal != null && objIsFinal != DBNull.Value)
{
labIsFinal.Text = (Convert.ToBoolean(objIsFinal) == true ? "预算收费" : "决算收费");
if (Convert.ToBoolean(objIsFinal))
{
//获取预算收据打印表
string strSQL = string.Format(@"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='{0}' AND IsFinal='1'
) T GROUP BY InvoiceType", TaskID);
dtFeeList = new SqlServerHelper().GetDateTableBySql(strSQL);
object objSum = dtFeeList.Compute("SUM(FEE)", "");
if (Information.IsNumeric(objSum))
{
DataRow dr = dtFeeList.NewRow();
dr["FEENAME"] = "合计";
decSum_IsFinal0 = Convert.ToDecimal(objSum);
dr["FEE"] = decSum_IsFinal0.ToString("F2");
dtFeeList.Rows.Add(dr);
}
}
}
else
{
labIsFinal.Text = "";
}
foreach (DataRow dr in dt.Rows)
{
UC_ChargeItem UC = new UC_ChargeItem();
UC.FeeItem = string.Format("{0}:{1}", dr["FeeItem"].ToString(), dr["Fee"].ToString());
FP.Controls.Add(UC);
}
}
string _Loginid = AppDomain.CurrentDomain.GetData("LOGINID").ToString();
bool _IsAllow = true;
if (_Loginid.Equals(ChargerID))
{
_IsAllow = false;
Btn_Print.Enabled = true;
}
else
{
Btn_Print.Enabled = false;
}
sqlstr = string.Format(@"SELECT COUNT(*) FROM Meter_WorkTask MW,Meter_WorkResolve MWR WHERE MW.TaskID=MWR.TaskID
AND MW.[State]=1 AND MW.PointSort=MWR.PointSort AND MW.TaskID=@TaskID AND MWR.loginId LIKE '%{0}%'", _Loginid);
dt = new SqlServerHelper().GetDateTableBySql(sqlstr, new SqlParameter[] { new SqlParameter("@TaskID", TaskID) });
if (dt.Rows[0][0].ToString().Equals("0"))
{
_IsAllow = false;
}
sqlstr = @"SELECT COUNT(0) FROM Meter_Charge WHERE CHARGEWORKERID='0092' AND ISNULL(MONTHCHECKSTATE,'')<>'1' AND ISNULL(CHARGECANCEL,'')<>'1' AND TaskID=@TaskID
AND CHARGEID=@CHARGEID";
dt = new SqlServerHelper().GetDateTableBySql(sqlstr, new SqlParameter[] { new SqlParameter("@TaskID", TaskID), new SqlParameter("@CHARGEID", _ChargeID) });
if (dt.Rows[0][0].ToString().Equals("0"))
{
_IsAllow = false;
}
Btn_Cancel.Visible = _IsAllow;
}
