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