/// <summary>
/// 提交编辑
/// </summary>
private bool SubmintEdit()
{
if (StockOut != null)
{
ModifiedGrid();
/////////////////////////////////////////////////////////////////////////////
StockOut.FCode = txtFCode.Text;
StockOut.FName = tbxFCustomer.Text;
//------------------------------------------------------
StockOut.FCompanyId = CurrentUser.AccountComId;
StockOut.FMemo = txtFMemo.Text.Trim();
var parms = new Dictionary <string, object>();
parms.Clear();
parms.Add("@keyID", StockOut.KeyId);
parms.Add("@companyId", CurrentUser.AccountComId);
var amt =
Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_MonthInitQty", parms).Tables[0].Rows[0][0]);
StockOut.FAmount = amt;
StockOut.FDate = txtFDate.SelectedDate;
return(InitMonthServie.SaveChanges() >= 0);
}
return(false);
}
/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
var stock = InitMonthServie.Where(p => p.KeyId == txtKeyId.Text.Trim()).FirstOrDefault();
if (stock != null)
{
ModifiedGrid();
/////////////////////////////////////////////////////////////////////////////
stock.FCode = txtFCode.Text;
stock.FName = tbxFCustomer.Text;
//--------------------------------------------------
stock.FCompanyId = CurrentUser.AccountComId;
stock.FFlag = 1;
stock.FDeleteFlag = 0;
stock.FMemo = txtFMemo.Text.Trim();
var parms = new Dictionary <string, object>();
parms.Clear();
parms.Add("@keyID", stock.KeyId);
parms.Add("@companyId", CurrentUser.AccountComId);
var amt =
Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_MonthInitQty", parms).Tables[0].Rows[0][0]);
stock.FAmount = amt;
stock.FDate = txtFDate.SelectedDate;
stock.FAmt = 0;
stock.FCate = hfdUnit.Text;
stock.FDate = txtFDate.SelectedDate;
InitMonthServie.SaveChanges();
if (txtKeyId.Text.Contains("TM"))
{
//单据号问题
string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "TB", CurrentUser.AccountComId);
var orderParms = new Dictionary <string, object>();
orderParms.Clear();
orderParms.Add("@oldKeyId", txtKeyId.Text);
orderParms.Add("@newKeyId", newKeyId);
orderParms.Add("@Bill", "23");
orderParms.Add("@companyId", CurrentUser.AccountComId);
SqlService.ExecuteProcedureCommand("proc_num", orderParms);
txtKeyId.Text = newKeyId;
//新增日志
var billStatus = new LHBillStatus
{
KeyId = newKeyId,
FCompanyId = CurrentUser.AccountComId,
FActionName = "新增",
FDate = DateTime.Now,
FDeptId = CurrentUser.AccountOrgId,
FOperator = CurrentUser.AccountName,
FMemo = String.Format("单据号{0},{1}新增调整客户代码期初占用钢瓶单据。", newKeyId, CurrentUser.AccountName)
};
GasHelper.AddBillStatus(billStatus);
}
return(true);
}
return(false);
}