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