/// <summary>
/// 提交编辑
/// </summary>
private bool SubmintEdit()
{
if (StockOut != null)
{
ModifiedGrid();
/////////////////////////////////////////////////////////////////////////////
StockOut.FCode = txtFCode.Text;
StockOut.FName = tbxFCustomer.Text;
//------------------------------------------------------
StockOut.FAddress = txtFAddress.Text.Trim();
//StockOut.FCompanyId = CurrentUser.AccountComId;
StockOut.FDate = txtFDate.SelectedDate;
StockOut.FShipper = !ddlFShipper.SelectedValue.Equals("-1") ? ddlFShipper.SelectedText : "";
StockOut.FVehicleNum = !ddlFVehicleNum.SelectedValue.Equals("-1") ? ddlFVehicleNum.SelectedText : "";
StockOut.FFreight = Convert.ToDecimal(txtFFreight.Text.Trim());
StockOut.FLinkman = txtFLinkman.Text.Trim();
StockOut.FMemo = txtFMemo.Text.Trim();
StockOut.FPhone = txtFPhone.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_SalesAmt", parms).Tables[0].Rows[0][0]);
StockOut.FAmount = amt;
StockOut.FSalesman = ddlFSalesman.SelectedValue;
StockOut.FArea = ddlFArea.SelectedValue;
StockOut.FAmt = string.IsNullOrEmpty(txtFAmt.Text.Trim()) ? 0 : Convert.ToDecimal(txtFAmt.Text.Trim());//
StockOut.FDiscountAmount = string.IsNullOrEmpty(txtFDiscountAmount.Text.Trim()) ? 0 : Convert.ToDecimal(txtFDiscountAmount.Text.Trim());
StockOut.FReconciliation = txtFReconciliation.Text;
StockOut.FDeliveryMethod = ddlDeliveryMethod.SelectedValue;
StockOut.FLogisticsNumber = txtFLogisticsNumber.Text;
StockOut.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray);
StockOut.FDriver = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray);
StockOut.FSubjectCode = ddlSubject.SelectedValue;
StockOut.FSubjectName = ddlSubject.SelectedText;
BottleDetectionService.SaveChanges();
var bottles = new Dictionary <string, object>();
bottles.Clear();
bottles.Add("@SalesKeyId", StockOut.KeyId);
bottles.Add("@companyid", CurrentUser.AccountComId);
bottles.Add("@date", Convert.ToDateTime(StockOut.FDate).ToString("yyyy-MM-dd"));
SqlService.ExecuteProcedureCommand("proc_SalesReturnBottle", bottles);
//收款部分
var parmsAuto = new Dictionary <string, object>();
parmsAuto.Clear();
parmsAuto.Add("@KeyId", StockOut.KeyId);
parmsAuto.Add("@companyId", CurrentUser.AccountComId);
parmsAuto.Add("@FCate", "客户");
parmsAuto.Add("@date", Convert.ToDateTime(StockOut.FDate).ToShortDateString());
parmsAuto.Add("@FSKNum", string.IsNullOrEmpty(StockOut.FSKNum) ? "" : StockOut.FSKNum);
SqlService.ExecuteProcedureCommand("proc_SKOrderAuto", parmsAuto);
return(true);
}
return(false);
}
/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
var stock = BottleDetectionService.Where(p => p.KeyId == txtKeyId.Text.Trim() && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();
if (stock != null)
{
ModifiedGrid();
/////////////////////////////////////////////////////////////////////////////
stock.FCode = txtFCode.Text;
stock.FName = tbxFCustomer.Text;
//--------------------------------------------------
stock.FAddress = txtFAddress.Text.Trim();
stock.FFlag = 1;
stock.FDeleteFlag = 0;
stock.FFreight = Convert.ToDecimal(txtFFreight.Text.Trim());
stock.FLinkman = txtFLinkman.Text.Trim();
stock.FMemo = txtFMemo.Text.Trim();
stock.FPhone = txtFPhone.Text.Trim();
stock.FShipper = !ddlFShipper.SelectedValue.Equals("-1") ? ddlFShipper.SelectedText : "";
stock.FVehicleNum = !ddlFVehicleNum.SelectedValue.Equals("-1") ? ddlFVehicleNum.SelectedText : "";
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_SalesAmt", parms).Tables[0].Rows[0][0]);
stock.FAmount = amt;
stock.FDate = txtFDate.SelectedDate;
stock.FSalesman = ddlFSalesman.SelectedValue;
stock.FArea = ddlFArea.SelectedValue;
stock.FAmt = string.IsNullOrEmpty(txtFAmt.Text.Trim()) ? 0 : Convert.ToDecimal(txtFAmt.Text.Trim());
stock.FDiscountAmount = string.IsNullOrEmpty(txtFDiscountAmount.Text.Trim()) ? 0 : Convert.ToDecimal(txtFDiscountAmount.Text.Trim());
stock.FReconciliation = txtFReconciliation.Text;
stock.FDeliveryMethod = ddlDeliveryMethod.SelectedValue;
stock.FLogisticsNumber = txtFLogisticsNumber.Text;
stock.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray);
stock.FDriver = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray);
stock.FSubjectCode = ddlSubject.SelectedValue;
stock.FSubjectName = ddlSubject.SelectedText;
stock.FSKNum = "";
BottleDetectionService.SaveChanges();
if (txtKeyId.Text.Contains("TM"))
{
//单据号问题
string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "XS", CurrentUser.AccountComId);
var orderParms = new Dictionary <string, object>();
orderParms.Clear();
orderParms.Add("@oldKeyId", txtKeyId.Text);
orderParms.Add("@newKeyId", newKeyId);
orderParms.Add("@Bill", "1");
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);
var bottles = new Dictionary <string, object>();
bottles.Clear();
bottles.Add("@SalesKeyId", newKeyId);
bottles.Add("@companyid", CurrentUser.AccountComId);
bottles.Add("@date", Convert.ToDateTime(stock.FDate).ToString("yyyy-MM-dd"));
SqlService.ExecuteProcedureCommand("proc_SalesReturnBottle", bottles);
//收款部分
var parmsAuto = new Dictionary <string, object>();
parmsAuto.Clear();
parmsAuto.Add("@KeyId", newKeyId);
parmsAuto.Add("@companyId", CurrentUser.AccountComId);
parmsAuto.Add("@FCate", "客户");
parmsAuto.Add("@date", Convert.ToDateTime(stock.FDate).ToString("yyyy-MM-dd"));
parmsAuto.Add("@FSKNum", stock.FSKNum);
SqlService.ExecuteProcedureCommand("proc_SKOrderAuto", parmsAuto);
}
if (!string.IsNullOrEmpty(hfdImage.Text))
{
var attachment = new LHAttachment();
attachment.FCompanyId = CurrentUser.AccountComId;
attachment.FPath = hfdImage.Text;
attachment.KeyId = txtKeyId.Text;
AttachmentService.Add(attachment);
}
return(true);
}
return(false);
}
/// <summary>
/// 加载页面数据
/// </summary>
private void LoadData()
{
switch (Actions)
{
case WebAction.Add:
txtKeyId.Text = SequenceService.CreateSequence("TM", CurrentUser.AccountComId);
Region3.Title = "添加钢瓶检测";
var temp = new LHBottleDetection
{
KeyId = txtKeyId.Text,
FFlag = 1,
FDeleteFlag = 1,
//钢瓶检测
FType = Convert.ToInt32(GasEnumBill.BottleDetection),
CreateBy = CurrentUser.AccountName,
FDate = txtFDate.SelectedDate,
FCompanyId = CurrentUser.AccountComId,
FStatus = Convert.ToInt32(GasEnumBillStauts.Add),
FProgress = Convert.ToInt32(GasEnumBillStauts.Add),
FCate = "客户"
};
//临时写入单据
BottleDetectionService.Add(temp);
//合计
var summary = new JObject
{
{ "FItemCode", "合计" },
{ "FQty", 0 },
{ "FAmount", 0 }
};
Grid1.SummaryData = summary;
break;
case WebAction.Edit:
txtKeyId.Text = KeyId;
Region3.Title = "编辑钢瓶检测";
if (StockOut != null)
{
WebControlHandler.BindObjectToControls(StockOut, SimpleForm1);
txtFDate.SelectedDate = StockOut.FDate;
tbxFCustomer.Text = StockOut.FName;
if (!string.IsNullOrEmpty(StockOut.FDriver))
{
ddlFDriver.SelectedValueArray = StockOut.FDriver.Split(',');
}
if (!string.IsNullOrEmpty(StockOut.FShipper))
{
ddlFShipper.SelectedValueArray = StockOut.FShipper.Split(',');
}
if (!string.IsNullOrEmpty(StockOut.FSupercargo))
{
ddlFSupercargo.SelectedValueArray = StockOut.FSupercargo.Split(',');
}
if (!string.IsNullOrEmpty(StockOut.FSalesman))
{
ddlFSalesman.SelectedValueArray = StockOut.FSalesman.Split(',');
}
ddlSubject.SelectedValue = StockOut.FSubjectCode;
ddlFVehicleNum.SelectedValue = StockOut.FVehicleNum;
ddlFArea.SelectedValue = StockOut.FArea;
ddlDeliveryMethod.SelectedValue = StockOut.FDeliveryMethod;
if (Attachment != null)
{
lblfile.Text = string.Format(@"<a href='../../{0}' target='_blank'>附件</a>", //
Attachment.FPath.Replace("~/", ""));
}
else
{
lblfile.Text = string.Empty;
}
BindDataGrid();
}
break;
}
}
