public static bool UpdateFeeItem(Control FP_Fee, string ResolveID)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine(@"SET XACT_ABORT ON
BEGIN TRAN");
foreach (Control c in FP_Fee.Controls)
{
if (c is UC_ChargeInput)
{
UC_ChargeInput UC = (UC_ChargeInput)c;
int feeid = 0;
if (int.TryParse(UC.FeeID, out feeid))
{
sb.AppendLine(string.Format("UPDATE Meter_WorkResolveFee SET Price='{5}',Quantity='{6}', FEE='{0}',AcceptID='{1}',AcceptUser='******',AcceptDate='{3}' WHERE ResolveID=@ResolveID AND FeeID='{4}'", UC.Fee, AppDomain.CurrentDomain.GetData("LOGINID"), AppDomain.CurrentDomain.GetData("USERNAME"), DateTime.Now.ToString(), feeid, UC.Price, UC.Quantity));
}
}
}
sb.AppendLine(" COMMIT TRAN");
int count = DbHelperSQL.ExecuteSql(sb.ToString(), new SqlParameter[] { new SqlParameter("@ResolveID", ResolveID) });
return(count > 0 ? true : false);
}
public static string GetFeeItem(Control FP_Fee)
{
StringBuilder sb = new StringBuilder();
foreach (Control c in FP_Fee.Controls)
{
if (c is UC_ChargeInput)
{
UC_ChargeInput UC = (UC_ChargeInput)c;
int feeid = 0;
if (int.TryParse(UC.FeeID, out feeid))
{
sb.AppendLine(string.Format("{0}：{1}*{2}={3}；", UC.FeeItem, UC.Price, UC.Quantity, UC.Fee));
}
}
}
// int count = DbHelperSQL.ExecuteSql(sb.ToString(), new SqlParameter[] { new SqlParameter("@ResolveID", ResolveID) });
return(sb.ToString());
}
public static void BindFeeItemTextBox(Control FP_Fee, string ResolveID)
{
//string sqlstr = "SELECT FeeID,FeeItem,Fee,DefaultValue,IsFinal FROM Meter_WorkResolveFee WHERE ResolveID=@ResolveID ORDER BY Sort";
//DataTable dt = new SqlServerHelper().GetDateTableBySql(sqlstr, new SqlParameter[] { new SqlParameter("@ResolveID", ResolveID) });
DataTable dt = sysidal.GetFeeItems(ResolveID);
if (DataTableHelper.IsExistRows(dt))
{
// GB_Fee.Text = dt.Rows[0]["IsFinal"].ToString().ToLower().Equals("true") ? "预算" : "决算";
FP_Fee.Height = dt.Rows.Count * 33;
foreach (DataRow dr in dt.Rows)
{
UC_ChargeInput UC = new UC_ChargeInput();
UC.FeeID = dr["FeeID"].ToString();
UC.FeeItem = dr["FeeItem"].ToString().Trim();
UC.Quantity = int.Parse(dr["QUANTITY"].ToString());
UC.Price = float.Parse(dr["PRICE"].ToString());
UC.Fee = float.Parse(dr["Fee"].ToString());
if (float.Parse(dr["PRICE"].ToString()) == 0f)
{
DataTable dd = sysidal.GetLastFeeItemsByDep(ResolveID, (int)dr["FeeID"]);//FEE,Price,Quantity
if (DataTableHelper.IsExistRows(dd))
{
UC.Quantity = int.Parse(dd.Rows[0]["QUANTITY"].ToString());
UC.Price = float.Parse(dd.Rows[0]["PRICE"].ToString());
UC.Fee = float.Parse(dd.Rows[0]["FEE"].ToString());;
}
}
FP_Fee.Controls.Add(UC);
}
}
}
