/// <summary> /// 财务录入ERP更新 /// </summary> /// <param name="finerp"></param> /// <param name="SQLCommand"></param> /// <returns></returns> public bool updatePurchaseReceiptFinancialEntryBll(FinancialInputERPModel finerp, string SQLCommand) { if (prd1.updatePurchaseReceiptFinancialEntryDal(finerp, SQLCommand) > 0) { return(true); } else { return(false); } }
FinancialInputERPModel GetFinancialInputERPModel() { FinancialInputERPModel finerp = new FinancialInputERPModel() { PurchaseReceiptID = TxtBox_PurchaseReceiptID.Text.Trim(), FinancialEntry = comb_FinancialEntry.Text.Trim(), FinancialEntryTime = DateTime.Now, FinancialEntryName = UsersHelp.Userslist[0].UserName }; return(finerp); }
/// <summary> /// 给输入框控件赋值 /// </summary> /// <param name="IIM"></param> void SetTxtBox(FinancialInputERPModel IIM) { TxtBox_PurchaseReceiptID.Text = IIM.PurchaseReceiptID; TxtBox_PurchaseNo.Text = IIM.PurchaseNo; TxtBox_SupplierName.Text = IIM.SupplierName; TxtBox_BatchNo.Text = IIM.BatchNo; TxtBox_MaterialCode.Text = IIM.MaterialCode; TxtBox_MaterialName.Text = IIM.MaterialName; TxtBox_MaterialSpecifications.Text = IIM.MaterialSpecifications; ip_ProductQuantity.Text = IIM.ProductQuantity.ToString(); ip_ProductQuantity1.Text = IIM.ProductQuantity1.ToString(); comb_state.SelectedIndex = IIM.OrderState; comb_FinancialEntry.SelectedIndex = IIM.FinancialEntry == "" ? 0 : 1; }
/// <summary> /// 财务录入ERP更新 /// </summary> /// <param name="finerp"></param> /// <param name="SQLCommand"></param> /// <returns></returns> public int updatePurchaseReceiptFinancialEntryDal(FinancialInputERPModel finerp, string SQLCommand) { string sql = SQLhelp.GetSQLCommand(SQLCommand); SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@PurchaseReceiptID", SqlDbType.VarChar, 100) { Value = finerp.PurchaseReceiptID }, new SqlParameter("@FinancialEntry", SqlDbType.VarChar, 50) { Value = finerp.FinancialEntry }, new SqlParameter("@FinancialEntryName", SqlDbType.VarChar, 50) { Value = finerp.FinancialEntryName } }; return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms)); }
public InputERP_Message(FinancialInputERPModel finERP) { InitializeComponent(); this.FinERP = finERP; }