/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void filePhoto_FileSelected(object sender, EventArgs e)
{
if (filePhoto.HasFile)
{
var fileSuffix = filePhoto.ShortFileName.Substring(filePhoto.ShortFileName.LastIndexOf('.'));
var sequence = SequenceService.CreateSequence("LH", CurrentUser.AccountComId);
var fileName = sequence + fileSuffix;
var uploadpath = Config.GetUploadpath();
var tempPath = (string.Format(@"{0}/temp/{1}/", uploadpath, DateTime.Now.ToString("yyyy-MM-dd"))); //
if (!DirFile.XFileExists(Server.MapPath(tempPath)))
{
DirFile.XCreateDir(Server.MapPath(tempPath));
}
filePhoto.SaveAs(Server.MapPath(tempPath + fileName));
hfdImage.Text = tempPath + fileName;
// 清空文件上传组件
filePhoto.Reset();
}
}
/// <summary>
/// 加载页面数据
/// </summary>
private void LoadData()
{
switch (Actions)
{
case WebAction.Add:
Region1.Title = "添加盘盈单";
txtKeyId.Text = SequenceService.CreateSequence("TM", CurrentUser.AccountComId);
var temp = new LHStockIn
{
KeyId = txtKeyId.Text,
FFlag = 1,
FDeleteFlag = 1,
//盘盈单
FType = Convert.ToInt32(GasEnumBill.Profit),
CreateBy = CurrentUser.AccountName,
FDate = txtFDate.SelectedDate,
FCompanyId = CurrentUser.AccountComId,
FStatus = Convert.ToInt32(GasEnumBillStauts.Add),
FProgress = Convert.ToInt32(GasEnumBillStauts.Add),
};
//临时写入单据
StockInService.Add(temp);
var summary = new JObject
{
{ "FItemCode", "合计" },
{ "FQty", 0 },
{ "FAmount", 0 }
};
Grid1.SummaryData = summary;
break;
case WebAction.Edit:
Region1.Title = "编辑盘盈单";
txtKeyId.Text = KeyId;
if (StockIn != null)
{
txtFMemo.Text = StockIn.FMemo;
ddlFCate.SelectedValue = StockIn.FCate;
BindDataGrid();
}
break;
}
}
/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
var order = FKOrderService.Where(p => p.keyId == txtKeyId.Text.Trim() && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();
if (order != null)
{
order.FCode = txtFCode.Text;
order.FName = tbxFCustomer.Text;
//--------------------------------------------------
order.FDeleteFlag = 0;
order.FMemo = txtFMemo.Text.Trim();
order.CreateBy = CurrentUser.AccountName;
order.FDate = txtFDate.SelectedDate;
var parms = new Dictionary <string, object>();
parms.Clear();
parms.Add("@KeyId", order.keyId);
parms.Add("@companyId", CurrentUser.AccountComId);
var amt =
Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_FKOrderAmt", parms).Tables[0].Rows[0][0]);
order.FAmount = amt;
FKOrderService.SaveChanges();
if (txtKeyId.Text.Contains("TM"))
{
//单据号问题
string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "NF", CurrentUser.AccountComId);
var orderParms = new Dictionary <string, object>();
orderParms.Clear();
orderParms.Add("@oldKeyId", txtKeyId.Text);
orderParms.Add("@newKeyId", newKeyId);
orderParms.Add("@Bill", "19");
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);
}
/// <summary>
/// 加载页面数据
/// </summary>
private void LoadData()
{
switch (Actions)
{
case WebAction.Add:
txtKeyId.Text = SequenceService.CreateSequence("TM", CurrentUser.AccountComId);
Region3.Title = "调整客户代码期初占用钢瓶单";
var temp = new LHInitMonth
{
KeyId = txtKeyId.Text,
FFlag = 1,
FDeleteFlag = 1,
//调整客户代码期初占用钢瓶单
FType = Convert.ToInt32(GasEnumBill.ChangeAccount),
CreateBy = CurrentUser.AccountName,
FDate = txtFDate.SelectedDate,
FCompanyId = CurrentUser.AccountComId,
FStatus = Convert.ToInt32(GasEnumBillStauts.Add),
};
//临时写入单据
InitMonthServie.Add(temp);
//合计
//var summary = new JObject
//{
// {"FItemCode", "合计"},
// {"FQty", 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;
txtFAmount.Text = StockOut.FAmount.ToString();
BindDataGrid();
}
break;
}
}
/// <summary>
/// 加载页面数据
/// </summary>
private void LoadData()
{
switch (Actions)
{
case WebAction.Add:
txtKeyId.Text = SequenceService.CreateSequence("TM", CurrentUser.AccountComId);
Region3.Title = "添加送货提成单";
var temp = new LHDispatchCommission
{
KeyId = txtKeyId.Text,
FFlag = 1,
FDeleteFlag = 1,
//送货提成单
FType = Convert.ToInt32(GasEnumBill.DispatchCommission),
CreateBy = CurrentUser.AccountName,
FDate = txtFDate.SelectedDate,
FCompanyId = CurrentUser.AccountComId,
FStatus = Convert.ToInt32(GasEnumBillStauts.Add),
};
//临时写入单据
DispatchCommissionService.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;
BindDataGrid();
}
break;
}
}
/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
var stock = StockInService.Where(p => p.KeyId == txtKeyId.Text.Trim()).FirstOrDefault();
if (stock != null)
{
ModifiedGrid();
stock.FCompanyId = CurrentUser.AccountComId;
stock.FDeleteFlag = 0;
stock.FMemo = txtFMemo.Text.Trim();
stock.FDate = txtFDate.SelectedDate;
stock.FDistributionPoint = ddlFDistributionPoint.SelectedValue;
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_PurchaseAmt", parms).Tables[0].Rows[0][0]);
stock.FAmount = amt;
StockInService.SaveChanges();
if (txtKeyId.Text.Contains("TM"))
{
//单据号问题
string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "PY", CurrentUser.AccountComId);
var orderParms = new Dictionary <string, object>();
orderParms.Clear();
orderParms.Add("@oldKeyId", txtKeyId.Text);
orderParms.Add("@newKeyId", newKeyId);
orderParms.Add("@Bill", "10");
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);
}
/// <summary>
/// 加载页面数据
/// </summary>
private void LoadData()
{
switch (Actions)
{
case WebAction.Add:
txtKeyId.Text = SequenceService.CreateSequence("TM", CurrentUser.AccountComId);
Region1.Title = "添加一般费用单";
var temp = new LHFKOrder
{
keyId = txtKeyId.Text,
FFlag = 1,
FDeleteFlag = 1,
//一般费用单
FType = Convert.ToInt32(GasEnumBill.GeneralExpense),
CreateBy = CurrentUser.AccountName,
FDate = txtFDate.SelectedDate,
FAmount = 0,
FCate = "内",
FCompanyId = CurrentUser.AccountComId
};
//临时写入单据
FKOrderService.Add(temp);
var summary = new JObject
{
{ "FCode", "合计" },
{ "FAmt", 0 },
};
Grid1.SummaryData = summary;
break;
case WebAction.Edit:
txtKeyId.Text = KeyId;
Region1.Title = "编辑一般费用单";
if (SkOrder != null)
{
txtFCode.Text = SkOrder.FCode;
tbxFCustomer.Text = SkOrder.FName;
txtFMemo.Text = SkOrder.FMemo;
BindDataGrid();
}
break;
}
}
/// <summary>
/// 加载页面数据
/// </summary>
private void LoadData()
{
switch (Actions)
{
case WebAction.Add:
txtKeyId.Text = SequenceService.CreateSequence("TM", CurrentUser.AccountComId);
Region1.Title = "添加核销收单";
var temp = new LHSKOrderChecked
{
KeyId = txtKeyId.Text,
FFlag = 1,
FDeleteFlag = 1,
CreateBy = CurrentUser.AccountName,
FDate = txtFDate.SelectedDate,
FAmount = 0,
FCate = "客户",
FCompanyId = CurrentUser.AccountComId,
};
//临时写入单据
CheckedOrderService.Add(temp);
// var summary = new JObject
//{
// {"FCode", "合计"},
// {"FAmt", 0},
//};
// Grid1.SummaryData = summary;
break;
case WebAction.Edit:
Region1.Title = "编辑核销收单";
txtKeyId.Text = KeyId;
if (CheckedOrder != null)
{
txtFCode.Text = CheckedOrder.FCode;
tbxFCustomer.Text = CheckedOrder.FName;
txtFMemo.Text = CheckedOrder.FMemo;
BindDataGrid();
}
break;
}
}
/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
var dispatch = DispatchService.Where(p => p.KeyId == txtKeyId.Text.Trim() && //
p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();
if (dispatch != null)
{
//dispatch.KeyId = txtKeyId.Text.Trim();
//dispatch.FCompanyId = CurrentUser.AccountComId;
dispatch.CreateBy = CurrentUser.AccountName;
dispatch.FAccidentQty = Convert.ToInt32(txtFAccidentQty.Text.Trim());
dispatch.FDate = txtFDate.SelectedDate;
dispatch.FDispatcher = ddlDispatcher.SelectedValue;
dispatch.FHeavyTruckQty = Convert.ToDecimal(txtFHeavyTruckQty.Text.Trim());
dispatch.FIDepartureTime = Convert.ToInt32(txtFIDepartureTime.Text.Trim());
dispatch.FIQty = Convert.ToDecimal(txtFIQty.Text.Trim());
dispatch.FIRange = Convert.ToDecimal(txtFIRange.Text.Trim());
dispatch.FLogistics = ddlLogistics.SelectedValue;
dispatch.FLogisticsName = ddlLogistics.SelectedText;
dispatch.FMemo = txtFMemo.Text.Trim();
dispatch.FODepartureTime = Convert.ToInt32(txtFODepartureTime.Text.Trim());
dispatch.FOQty = Convert.ToDecimal(txtFOQty.Text.Trim());
dispatch.FORange = Convert.ToDecimal(txtFORange.Text.Trim());
dispatch.FOtherQty = Convert.ToInt32(txtFOtherQty.Text.Trim());
dispatch.FRepairQty = Convert.ToInt32(txtFRepairQty.Text.Trim());
dispatch.FTransport = Convert.ToDecimal(txtFTransport.Text.Trim());
dispatch.FTurnover = Convert.ToDecimal(txtFTurnover.Text.Trim());
dispatch.FWorkQty = Convert.ToInt32(txtFWorkQty.Text.Trim());
dispatch.FDeleteFlag = 0;
dispatch.FType = 52;
DispatchService.SaveChanges();
if (txtKeyId.Text.Contains("TM"))
{
//单据号问题
string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate),//
"DL", CurrentUser.AccountComId);
var orderParms = new Dictionary <string, object>();
orderParms.Clear();
orderParms.Add("@oldKeyId", txtKeyId.Text);
orderParms.Add("@newKeyId", newKeyId);
orderParms.Add("@Bill", "52");//Convert.ToInt32(GasEnumBill.Dispatch)
orderParms.Add("@companyId", CurrentUser.AccountComId);
SqlService.ExecuteProcedureCommand("proc_num", orderParms);
txtKeyId.Text = newKeyId;
return(true);
}
}
return(false);
}
protected void fileUpload1_FileSelected(object sender, EventArgs e)
{
if (fileUpload1.HasFile)
{
var fileSuffix = fileUpload1.ShortFileName.Substring(fileUpload1.ShortFileName.LastIndexOf('.'));
var sequence = SequenceService.CreateSequence("LH", CurrentUser.AccountComId);
var fileName = sequence + fileSuffix;
var uploadpath = Config.GetUploadpath();
//该目录设定死，最好不要修改
var fileTemp = (string.Format(@"{0}/temp/{1}/", uploadpath, DateTime.Now.ToString("yyyy-MM-dd"))); //
if (!DirFile.XFileExists(Server.MapPath(fileTemp)))
{
DirFile.XCreateDir(Server.MapPath(fileTemp));
}
var address = fileTemp + fileName;
fileUpload1.SaveAs(Server.MapPath(address));
//导入
var connStr = string.Empty;//数据连接字符串
if (fileSuffix == ".xls")
{
connStr = "Provider=Microsoft.Jet.OleDb.4.0;" + "data source=" + Server.MapPath(address) + ";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'";
}
else if (fileSuffix == ".xlsx")
{
connStr = "Provider=Microsoft.ACE.OleDb.12.0;" + "data source=" + Server.MapPath(address) + ";Extended Properties='Excel 12.0; HDR=YES; IMEX=1'";
}
var conn = new OleDbConnection(connStr);
conn.Open();
var data = new DataTable();
const string cmdSql = "select * from [Sheet1$]";
var da = new OleDbDataAdapter(cmdSql, conn);
da.Fill(data);
ViewState["dtData"] = data;
Grid1.DataSource = data;
Grid1.DataBind();
Grid1.Visible = true;
fileUpload1.Reset();
}
}
/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
var stock = DispatchCommissionService.Where(p => p.KeyId == txtKeyId.Text.Trim() && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();
if (stock != null)
{
AddListGrid();
ModifiedGrid();
/////////////////////////////////////////////////////////////////////////////
stock.FDate = txtFDate.SelectedDate;
stock.FMemo = txtFMemo.Text.Trim();
DispatchCommissionService.SaveChanges();
if (txtKeyId.Text.Contains("TM"))
{
//单据号问题
string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "TC", CurrentUser.AccountComId);
var orderParms = new Dictionary <string, object>();
orderParms.Clear();
orderParms.Add("@oldKeyId", txtKeyId.Text);
orderParms.Add("@newKeyId", newKeyId);
orderParms.Add("@Bill", "14");
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);
}
/// <summary>
/// 加载页面数据
/// </summary>
private void LoadData()
{
switch (Actions)
{
case WebAction.Add:
hiddevalue.Text = SequenceService.CreateSequence(DateTime.Now, "CC", CurrentUser.AccountComId);
BindData();
break;
case WebAction.Edit:
if (Contract != null)
{
Customer = CustomerService.FirstOrDefault(p => p.FCode == Contract.FCustomer && p.FCompanyId == CurrentUser.AccountComId);
if (CurrentUser != null)
{
tbxFCustomer.Text = Customer.FName;
}
hiddevalue.Text = Contract.FOrderCode;
txtFContractCode.Text = Contract.FContractCode;
dpFContractDate.SelectedDate = Contract.FContractDate;
txtFContractName.Text = Contract.FContractName;
ddlFCtroler.SelectedValue = Contract.FCtroler;
//txtFContractName.Text = Contract.FContractName;
if (!string.IsNullOrEmpty(ddlFAccType.SelectedValue))
{
ddlFAccType.SelectedValue = Contract.FAccType;
}
if (!string.IsNullOrEmpty(ddlFBillType.SelectedValue))
{
ddlFBillType.SelectedValue = Contract.FBillType;
}
dpFBeginDate.SelectedDate = Contract.FBeginDate;
dpFEndDate.SelectedDate = Contract.FEndDate;
this.txtFCustomer.Text = Contract.FCustomer;
txtFContext.Text = Contract.FContext;
txtFConacter.Text = Contract.FConacter;
txtFTel.Text = Contract.FTel;
BindData();
}
break;
}
}
/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
var liquidPlan = new LHLiquidPlan();
string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), //
"LP", CurrentUser.AccountComId);
liquidPlan.FCompanyId = CurrentUser.AccountComId;
liquidPlan.KeyId = newKeyId;
liquidPlan.CreateBy = CurrentUser.AccountName;
liquidPlan.FDate = txtFDate.SelectedDate;
liquidPlan.FItemCode = tbxFItemName.SelectedValue;
liquidPlan.FItemName = tbxFItemName.SelectedText;
liquidPlan.FBill = tbxFBill.SelectedValue;
liquidPlan.FVehicleNum = tbxFVehicleNum.SelectedValue;
liquidPlan.FDriver = GasHelper.GetDropDownListArrayString(tbxFDriver.SelectedItemArray);
liquidPlan.FSupercargo = tbxFSupercargo.SelectedValue;
liquidPlan.FMargin = Convert.ToDecimal(tbxFMargin.Text);
liquidPlan.FMemo = txtFMemo.Text;
LiquidPlanService.Add(liquidPlan);
var parms = new Dictionary <string, object>();
parms.Clear();
parms.Add("@keyId", newKeyId);
parms.Add("@companyId", CurrentUser.AccountComId);
parms.Add("@keyId1", Grid1SelectIds());
parms.Add("@keyId2", Grid2SelectIds().ToList()[0]);
parms.Add("@keyId3", Grid2SelectIds().ToList()[1]);
parms.Add("@keyId4", Grid2SelectIds().ToList()[2]);
SqlService.ExecuteProcedureCommand("proc_LiquidPlanMergeProc", parms);
return(true);
}
/// <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;
}
}
protected void fileUpload1_FileSelected(object sender, EventArgs e)
{
if (fileUpload1.HasFile)
{
string fileSuffix = fileUpload1.ShortFileName.Substring(fileUpload1.ShortFileName.LastIndexOf('.'));
string sequence = SequenceService.CreateSequence("LH", CurrentUser.AccountComId);
string fileName = sequence + fileSuffix;
string uploadpath = Config.GetUploadpath();
//该目录设定死，最好不要修改
string fileTemp = (string.Format(@"{0}/temp/{1}/", uploadpath, DateTime.Now.ToString("yyyy-MM-dd"))); //
if (!DirFile.XFileExists(Server.MapPath(fileTemp)))
{
DirFile.XCreateDir(Server.MapPath(fileTemp));
}
string address = fileTemp + fileName;
fileUpload1.SaveAs(Server.MapPath(address));
//导入
string connStr = string.Empty;//数据连接字符串
if (fileSuffix == ".xls")
{
connStr = "Provider=Microsoft.Jet.OleDb.4.0;" + "data source=" + Server.MapPath(address) + ";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'";
}
else if (fileSuffix == ".xlsx")
{
connStr = "Provider=Microsoft.ACE.OleDb.12.0;" + "data source=" + Server.MapPath(address) + ";Extended Properties='Excel 12.0; HDR=YES; IMEX=1'";
}
OleDbConnection conn = new OleDbConnection(connStr);
conn.Open();
DataTable data = new DataTable();
const string cmdSql = "select * from [Sheet1$]";
OleDbDataAdapter da = new OleDbDataAdapter(cmdSql, conn);
da.Fill(data);
conn.Close();
DataTable table = new DataTable();
table.Columns.Add("压力");
table.Columns.Add("温度");
table.Columns.Add("因子系数");
for (int i = 1; i < data.Columns.Count; i++)
{
for (int j = 0; j < data.Rows.Count; j++)
{
DataRow row = table.NewRow();
row[0] = data.Columns[i].ColumnName;
row[1] = data.Rows[j][0];
row[2] = data.Rows[j][i];
table.Rows.Add(row);
}
}
ViewState["dtData"] = table;
Grid1.DataSource = table;
Grid1.DataBind();
Grid1.Visible = true;
fileUpload1.Reset();
}
}
/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
var order = FkOrderCheckedService.Where(p => p.KeyId == txtKeyId.Text.Trim() && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();
if (order != null)
{
//核销主单据
//--------------------------------------------------
order.FCode = txtFCode.Text;
order.FName = tbxFCustomer.Text;
//--------------------------------------------------
order.FDeleteFlag = 0;
order.FMemo = txtFMemo.Text.Trim();
order.CreateBy = CurrentUser.AccountName;
order.FDate = txtFDate.SelectedDate;
//本次实际核销的金额
decimal checkedAmt = 0.00M;
//收款单
decimal sksum = 0.00M;
int[] sks = Grid1.SelectedRowIndexArray;
for (int i = 0; i < sks.Length; i++)
{
sksum += Convert.ToDecimal(Grid1.DataKeys[Grid1.SelectedRowIndexArray[i]][2].ToString());
}
if (sksum <= 0)
{
Alert.Show("要核销的收款单已核销完，暂无需核销单据。", MessageBoxIcon.Information);
return(false);
}
//销售金额
decimal salesum = 0.00M;
int[] sales = Grid2.SelectedRowIndexArray;
for (int i = 0; i < sales.Length; i++)
{
salesum += Convert.ToDecimal(Grid2.DataKeys[Grid2.SelectedRowIndexArray[i]][1].ToString());
}
if (sksum <= 0)
{
Alert.Show("要核销的发货单已核销完，暂无需核销单据。", MessageBoxIcon.Information);
return(false);
}
if (sksum == salesum)
{
//实际核销款
checkedAmt = sksum;
for (int i = 0; i < sks.Length; i++)
{
int id = Convert.ToInt32(Grid1.DataKeys[sks[i]][1].ToString());
string keyid = Grid1.DataKeys[Grid1.SelectedRowIndexArray[i]][0].ToString();
var banks = new LHFKOrderCheckedBanks();
banks.KeyId = txtKeyId.Text;
banks.CBankId = id;
banks.FAmt = Convert.ToDecimal(Grid1.DataKeys[sks[i]][2]);
banks.FCompanyId = CurrentUser.AccountComId;
var bank = FkOrderCheckedBanksService.Where(p => p.KeyId == txtKeyId.Text && p.CBankId == id && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();
if (bank != null)
{
FkOrderCheckedBanksService.SaveChanges();
}
else
{
FkOrderCheckedBanksService.Add(banks);
}
}
for (int i = 0; i < sales.Length; i++)
{
string keyid = Grid2.DataKeys[Grid2.SelectedRowIndexArray[i]][0].ToString();
var details = new LHFKOrderCheckedDetails();
details.KeyId = txtKeyId.Text;
details.FSaleKeyId = keyid;
details.FAmount = Convert.ToDecimal(Grid2.DataKeys[sks[i]][1]);
details.FCompanyId = CurrentUser.AccountComId;
var detail =
FkOrderCheckedDetailsService.Where(p => p.KeyId == txtKeyId.Text && p.FSaleKeyId == keyid && p.FCompanyId == CurrentUser.AccountComId)
.FirstOrDefault();
if (detail != null)
{
FkOrderCheckedDetailsService.SaveChanges();
}
else
{
FkOrderCheckedDetailsService.Add(details);
}
}
}
else if (sksum > salesum)
{
//实际核销款
checkedAmt = salesum;
//分析
decimal kfpje = salesum;
for (int i = 0; i < sks.Length; i++)
{
int id = Convert.ToInt32(Grid1.DataKeys[Grid1.SelectedRowIndexArray[i]][1].ToString());
//string keyid = Grid1.DataKeys[sks[i]][0].ToString();
/////////////////////////////////////////////////
var sk = Convert.ToDecimal(Grid1.DataKeys[Grid1.SelectedRowIndexArray[i]][2]);
decimal hxje = 0.00M;
decimal yszj = sk;
if (kfpje == 0)
{
hxje = 0;
}
else
{
decimal kyje = kfpje - yszj;
if (kyje > 0)
{
hxje = yszj;
kfpje = kyje;
}
else if (kyje == 0)
{
hxje = kfpje;
kfpje = kyje;
//continue;
}
else
{
hxje = kfpje;
kfpje = 0;
//continue;
}
}
/////////////////////////////////////////////////
var banks = new LHFKOrderCheckedBanks();
banks.KeyId = txtKeyId.Text;
banks.CBankId = id;
banks.FCompanyId = CurrentUser.AccountComId;
//本次核销款
banks.FAmt = hxje;
var bank =
FkOrderCheckedBanksService.Where(p => p.KeyId == txtKeyId.Text && p.CBankId == id && p.FCompanyId == CurrentUser.AccountComId)
.FirstOrDefault();
if (bank != null)
{
FkOrderCheckedBanksService.SaveChanges();
}
else
{
FkOrderCheckedBanksService.Add(banks);
}
}
/////////////////////////////////////////////////
decimal kfpje2 = salesum;
for (int i = 0; i < sales.Length; i++)
{
string keyid = Grid2.DataKeys[Grid2.SelectedRowIndexArray[i]][0].ToString();
//////////////////////////////////////////////////////////
var sale = Convert.ToDecimal(Grid2.DataKeys[Grid2.SelectedRowIndexArray[i]][1]);
decimal hxje = 0.00M;
decimal yszj = sale;
if (kfpje2 == 0)
{
hxje = 0;
}
else
{
decimal kyje = kfpje2 - yszj;
if (kyje > 0)
{
hxje = yszj;
kfpje2 = kyje;
}
else if (kyje == 0)
{
hxje = kfpje2;
kfpje2 = kyje;
//continue;
}
else
{
hxje = kfpje2;
kfpje = 0;
//continue;
}
}
/////////////////////////////////////////////////////////
var details = new LHFKOrderCheckedDetails();
details.KeyId = txtKeyId.Text;
details.FSaleKeyId = keyid;
details.FAmount = hxje;
details.FCompanyId = CurrentUser.AccountComId;
var detail =
FkOrderCheckedDetailsService.Where(p => p.KeyId == txtKeyId.Text && p.FSaleKeyId == keyid && p.FCompanyId == CurrentUser.AccountComId)
.FirstOrDefault();
if (detail != null)
{
FkOrderCheckedDetailsService.SaveChanges();
}
else
{
FkOrderCheckedDetailsService.Add(details);
}
}
}
else
{
//实际核销款
checkedAmt = sksum;
//分析
decimal kfpje = sksum;
for (int i = 0; i < sks.Length; i++)
{
int id = Convert.ToInt32(Grid1.DataKeys[Grid1.SelectedRowIndexArray[i]][1].ToString());
//string keyid = Grid1.DataKeys[sks[i]][0].ToString();
/////////////////////////////////////////////////
var sk = Convert.ToDecimal(Grid1.DataKeys[Grid1.SelectedRowIndexArray[i]][2]);
decimal hxje = 0.00M;
decimal yszj = sk;
if (kfpje == 0)
{
hxje = 0;
}
else
{
decimal kyje = kfpje - yszj;
if (kyje > 0)
{
hxje = yszj;
kfpje = kyje;
}
else if (kyje == 0)
{
hxje = kfpje;
kfpje = kyje;
//continue;
}
else
{
hxje = kfpje;
kfpje = 0;
//continue;
}
}
/////////////////////////////////////////////////
var banks = new LHFKOrderCheckedBanks();
banks.KeyId = txtKeyId.Text;
banks.CBankId = id;
banks.FCompanyId = CurrentUser.AccountComId;
//本次核销款
banks.FAmt = hxje;
var bank = FkOrderCheckedBanksService.Where(p => p.KeyId == txtKeyId.Text && p.CBankId == id && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();
if (bank != null)
{
FkOrderCheckedBanksService.SaveChanges();
}
else
{
FkOrderCheckedBanksService.Add(banks);
}
}
decimal kfpje2 = sksum;
for (int i = 0; i < sales.Length; i++)
{
string keyid = Grid2.DataKeys[Grid2.SelectedRowIndexArray[i]][0].ToString();
//////////////////////////////////////////////////////////
var sale = Convert.ToDecimal(Grid2.DataKeys[Grid2.SelectedRowIndexArray[i]][1]);
decimal hxje = 0.00M;
decimal yszj = sale;
if (kfpje2 == 0)
{
hxje = 0;
}
else
{
decimal kyje = kfpje2 - yszj;
if (kyje > 0)
{
hxje = yszj;
kfpje2 = kyje;
}
else if (kyje == 0)
{
hxje = kfpje2;
kfpje2 = kyje;
//continue;
}
else
{
hxje = kfpje2;
kfpje = 0;
//continue;
}
}
var details = new LHFKOrderCheckedDetails();
details.KeyId = txtKeyId.Text;
details.FSaleKeyId = keyid;
details.FAmount = hxje;
details.FCompanyId = CurrentUser.AccountComId;
var detail =
FkOrderCheckedDetailsService.Where(p => p.KeyId == txtKeyId.Text && p.FSaleKeyId == keyid && p.FCompanyId == CurrentUser.AccountComId)
.FirstOrDefault();
if (detail != null)
{
FkOrderCheckedDetailsService.SaveChanges();
}
else
{
FkOrderCheckedDetailsService.Add(details);
}
}
}
//-----------------------------------------------------
//实际核销款
order.FAmount = checkedAmt;
FkOrderCheckedService.SaveChanges();
//-----------------------------------------------------
if (txtKeyId.Text.Contains("TM"))
{
//单据号问题
string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "HF", CurrentUser.AccountComId);
var orderParms = new Dictionary <string, object>();
orderParms.Clear();
orderParms.Add("@oldKeyId", txtKeyId.Text);
orderParms.Add("@newKeyId", newKeyId);
orderParms.Add("@Bill", "18");
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);
}
/// <summary>
/// 加载页面数据
/// </summary>
private void LoadData()
{
switch (Actions)
{
case WebAction.Add:
txtKeyId.Text = SequenceService.CreateSequence("TM", CurrentUser.AccountComId);
Region1.Title = "添加付款单";
var temp = new LHFKOrder
{
keyId = txtKeyId.Text,
FFlag = 1,
FDeleteFlag = 1,
FType = Convert.ToInt32(GasEnumBill.Payment),
CreateBy = CurrentUser.AccountName,
FDate = txtFDate.SelectedDate,
FAmount = 0,
FCate = "供应商",
FCompanyId = CurrentUser.AccountComId
};
//临时写入单据
FKOrderService.Add(temp);
var summary = new JObject
{
{ "FCode", "合计" },
{ "FAmt", 0 },
};
Grid1.SummaryData = summary;
break;
case WebAction.Edit:
txtKeyId.Text = KeyId;
Region1.Title = "编辑付款单";
if (SkOrder != null)
{
txtFCode.Text = SkOrder.FCode;
tbxFCustomer.Text = SkOrder.FName;
//txtFAddress.Text = StockOut.FAddress;
//txtFFreight.Text = StockOut.FFreight.ToString();
//txtFLinkman.Text = StockOut.FLinkman;
txtFMemo.Text = SkOrder.FMemo;
//txtFPhone.Text = StockOut.FPhone;
//ddlFDriver.Text = StockOut.FDriver;
//ddlFShipper.SelectedValue = StockOut.FShipper;
//ddlFSupercargo.Text = StockOut.FSupercargo;
//ddlFVehicleNum.SelectedValue = StockOut.FVehicleNum;
BindDataGrid();
}
break;
}
}
/// <summary>
/// 加载页面数据
/// </summary>
private void LoadData()
{
switch (Actions)
{
case WebAction.Add:
Region1.Title = "添加空瓶回收单";
txtKeyId.Text = SequenceService.CreateSequence("TM", CurrentUser.AccountComId);
var temp = new LHStockIn
{
KeyId = txtKeyId.Text,
FFlag = 1,
FDeleteFlag = 1,
//空瓶回收单
FType = Convert.ToInt32(GasEnumBill.BottleReturn),
CreateBy = CurrentUser.AccountName,
FDate = txtFDate.SelectedDate,
FCompanyId = CurrentUser.AccountComId,
FStatus = Convert.ToInt32(GasEnumBillStauts.Add),
FProgress = Convert.ToInt32(GasEnumBillStauts.Add),
};
//临时写入单据
StockInService.Add(temp);
break;
case WebAction.Edit:
Region1.Title = "编辑空瓶回收单";
txtKeyId.Text = KeyId;
if (StockIn != null)
{
WebControlHandler.BindObjectToControls(StockIn, SimpleForm1);
txtFDate.SelectedDate = StockIn.FDate;
tbxFCustomer.Text = StockIn.FName;
if (!string.IsNullOrEmpty(StockIn.FDriver))
{
ddlFDriver.SelectedValueArray = StockIn.FDriver.Split(',');
}
if (!string.IsNullOrEmpty(StockIn.FShipper))
{
ddlFShipper.SelectedValueArray = StockIn.FShipper.Split(',');
}
if (!string.IsNullOrEmpty(StockIn.FSupercargo))
{
ddlFSupercargo.SelectedValueArray = StockIn.FSupercargo.Split(',');
}
if (!string.IsNullOrEmpty(StockIn.FSalesman))
{
ddlFSalesman.SelectedValueArray = StockIn.FSalesman.Split(',');
}
ddlFVehicleNum.SelectedValue = StockIn.FVehicleNum;
ddlFArea.SelectedValue = StockIn.FArea;
ddlDeliveryMethod.SelectedValue = StockIn.FDeliveryMethod;
ddlReturn.SelectedValue = StockIn.FClass;
ddlDeliveryMethod.SelectedValue = StockIn.FDeliveryMethod;
ddlFDistributionPoint.SelectedValue = StockIn.FDistributionPoint;
hfdCate.Text = StockIn.FCate;
BindDataGrid();
}
break;
}
}
/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
//生成调度单
LHDispatchCenter dispatch = new LHDispatchCenter();
//调度单号生成
string newKeyId = SequenceService.CreateSequence("PC", CurrentUser.AccountComId);
dispatch.KeyId = newKeyId; lblKeyId.Text = newKeyId;
dispatch.FCompanyId = CurrentUser.AccountComId;
dispatch.FBeginDate = dptBeginDate.SelectedDate;
dispatch.FBeginTime = dpBeginTime.Text.Trim();
dispatch.FEndDate = dptEnd.SelectedDate;
dispatch.FEndTime = dpEndTime.Text.Trim();
dispatch.FDate = DateTime.Now;
dispatch.FVehicleNum = ddlFVehicleNum.SelectedValue;
dispatch.FDriver = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray);
dispatch.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray);
dispatch.CreateBy = CurrentUser.AccountName;
dispatch.FFlag = 1;
dispatch.FLogistics = ddlLogistics.SelectedText;
dispatch.FLogisticsCode = ddlLogistics.SelectedValue;
dispatch.FActual = string.IsNullOrEmpty(txtFActual.Text.Trim()) ? 0M : Convert.ToDecimal(txtFActual.Text.Trim());
dispatch.FTrailerPlate = ddlFTrailerPlate.SelectedValue;
dispatch.FFrom = ddlFrom.SelectedValue;
dispatch.FTo = ddlTo.SelectedValue;
dispatch.FDeliveryMethod = ddlDeliveryMethod.SelectedValue;
dispatch.FAuditFlag = 0;
DispatchCenterService.Add(dispatch);
string[] keys = KeyId.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
string[] patch = patchid.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
foreach (string key in keys)
{
if (!string.IsNullOrEmpty(key))
{
//状态
LHBillStatus flow = new LHBillStatus
{
KeyId = key,
FCompanyId = CurrentUser.AccountComId,
FDeptId = CurrentUser.AccountOrgId,
FOperator = CurrentUser.AccountName,
FDate = Convert.ToDateTime(dptBeginDate.SelectedDate),
FActionName = "配车",
FMemo = string.Format(@"单据号{0}被{1}作配车业务处理。", key, CurrentUser.AccountName)
};
BillStatusService.Add(flow);
LHStockOut info = new StockOutService().FirstOrDefault(p => p.KeyId == key && p.FCompanyId == CurrentUser.AccountComId);
if (info != null)
{
Dictionary <string, object> infoParms = new Dictionary <string, object>();
infoParms.Clear();
infoParms.Add("@keyid", info.FLogisticsNumber);
infoParms.Add("@companyId", CurrentUser.AccountComId);
infoParms.Add("@FVehicleNum", ddlFVehicleNum.SelectedValue);
infoParms.Add("@FDriver", GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray));
infoParms.Add("@FSupercargo", GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray));
infoParms.Add("@FDispatchNum", newKeyId); //调度单号
SqlService.ExecuteProcedureCommand("proc_DispatchCenter", infoParms);
}
//变更单据上的司机、押韵员、车牌号
Dictionary <string, object> parms = new Dictionary <string, object>();
parms.Clear();
parms.Add("@keyid", key);
parms.Add("@companyId", CurrentUser.AccountComId);
parms.Add("@FVehicleNum", ddlFVehicleNum.SelectedValue);
parms.Add("@FDriver", GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray));
parms.Add("@FSupercargo", GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray));
parms.Add("@FDispatchNum", newKeyId); //调度单号
SqlService.ExecuteProcedureCommand("proc_DispatchCenter", parms);
List <LHStockOut> outs = new List <LHStockOut>();
List <LHPassCard> cards = new List <LHPassCard>();
}
}
foreach (var item in patch)
{
LHStockOutDispatch dis = StockoutDispatchServices.Where(p => p.KeyId == item).FirstOrDefault();
if (dis != null)
{
dis.FState = 1;
StockoutDispatchServices.SaveChanges();
}
}
return(true);
}
/// <summary>
/// 加载页面数据
/// </summary>
private void LoadData()
{
switch (Actions)
{
case WebAction.Add:
Region1.Title = "添加生产单";
txtKeyId.Text = SequenceService.CreateSequence("TM", CurrentUser.AccountComId);
var temp = new LHStockIn
{
KeyId = txtKeyId.Text,
FFlag = 1,
FDeleteFlag = 1,
//发货单
FType = Convert.ToInt32(GasEnumBill.Production),
CreateBy = CurrentUser.AccountName,
FDate = txtFDate.SelectedDate,
FCompanyId = CurrentUser.AccountComId,
FStatus = Convert.ToInt32(GasEnumBillStauts.Add),
FProgress = Convert.ToInt32(GasEnumBillStauts.Add),
};
//临时写入单据
StockInService.Add(temp);
break;
case WebAction.Edit:
txtKeyId.Text = KeyId;
Region1.Title = "编辑生产单";
if (StockIn != null)
{
txtFMemo.Text = StockIn.FMemo;
ddlFProducer.SelectedValue = StockIn.FProducer;
ddlFSurveyor.SelectedValue = StockIn.FSurveyor;
ddlWorkShop.SelectedValue = StockIn.FProductionWorkshop;
var product =
StockInDetailsService.Where(
p => p.KeyId == KeyId && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();
if (product != null)
{
txtFCode.Text = product.FItemCode;
txtFQty.Text = product.FQty.ToString();
tbxFBottle.SelectedValue = product.FBottle;
txtFBottleQty.Text = product.FBottleQty.ToString();
txtFCostPrice.Text = product.FCostPrice.ToString();
txtFBalance.Text = product.FBalance.ToString();
//
var item =
new ItemsService().Where(
p => p.FCode == txtFCode.Text && p.FCompanyId == CurrentUser.AccountComId)
.FirstOrDefault();
if (item != null)
{
tbxFName.Text = item.FName;
}
}
BindDataGrid();
}
break;
}
}
/// <summary>
/// 加载页面数据
/// </summary>
private void LoadData()
{
switch (Actions)
{
case WebAction.Add:
txtKeyId.Text = SequenceService.CreateSequence("MR", CurrentUser.AccountComId);
Region3.Title = "添加领料单";
var temp = new LHStockOut
{
KeyId = txtKeyId.Text,
FFlag = 1,
FDeleteFlag = 1,
//发货单
FType = Convert.ToInt32(GasEnumBill.picking),
CreateBy = CurrentUser.AccountName,
FDate = txtFDate.SelectedDate,
FCompanyId = CurrentUser.AccountComId,
FStatus = Convert.ToInt32(GasEnumBillStauts.Add),
FProgress = Convert.ToInt32(GasEnumBillStauts.Add),
};
//临时写入单据
StockOutService.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(',');
//ddlFVehicleNum.SelectedValue = StockOut.FVehicleNum;
//ddlFArea.SelectedValue = StockOut.FArea;
//ddlDeliveryMethod.SelectedValue = StockOut.FDeliveryMethod;
ddlFCate.SelectedValue = StockOut.FCate;
ddlOrgnization.SelectedValue = StockOut.FCode;
ddlFReceiver.SelectedValue = StockOut.FSalesman;
ddlFWarehouse.SelectedValue = StockOut.FT6Warehouse;
ddlT6ReceiveSendType.SelectedValue = StockOut.FT6ReceiveSendTypeNum;
ddlFGroup.SelectedValue = StockOut.FGroup;
ddlFDistributionPoint.SelectedValue = StockOut.FDistributionPoint;
BindDataGrid();
}
break;
}
}
/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
var stock = StockOutService.Where(p => p.KeyId == txtKeyId.Text.Trim() && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();
if (stock != null)
{
ModifiedGrid();
stock.FOrgId = int.Parse(ddlOrgnization.SelectedValue);
stock.FOrgName = ddlOrgnization.SelectedText;
stock.FCode = ddlOrgnization.SelectedValue;
stock.FName = ddlOrgnization.SelectedText.Trim();
//--------------------------------------------------
stock.FAuditFlag = 0;
//stock.FAddress = txtFAddress.Text.Trim();
stock.FCompanyId = CurrentUser.AccountComId;
stock.FFlag = 1;
stock.FDeleteFlag = 0;
//stock.FFreight = Convert.ToDecimal(txtFFreight.Text.Trim());
stock.FLinkman = txtFLinkman.Text.Trim();
stock.FReceiver = ddlFReceiver.SelectedValue;
stock.FT6ReceiveSendType = ddlT6ReceiveSendType.SelectedText;
stock.FT6ReceiveSendTypeNum = ddlT6ReceiveSendType.SelectedValue;
stock.FMemo = txtFMemo.Text.Trim();
stock.FT6Warehouse = ddlFWarehouse.SelectedValue;
stock.FT6Status = "未同步";
//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.FTime1 = DateTime.Now;
stock.FDate = txtFDate.SelectedDate;
//stock.FSalesman = ddlFSalesman.SelectedValue;
//stock.FArea = ddlFArea.SelectedValue;
//stock.FAmt = Convert.ToDecimal(txtFAmt.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.FCate = ddlFCate.SelectedValue;
stock.FGroup = ddlFGroup.SelectedValue;
stock.FDistributionPoint = ddlFDistributionPoint.SelectedValue;
StockOutService.SaveChanges();
if (txtKeyId.Text.Contains("TM"))
{
//单据号问题
string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "OT", CurrentUser.AccountComId);
var orderParms = new Dictionary <string, object>();
orderParms.Clear();
orderParms.Add("@oldKeyId", txtKeyId.Text);
orderParms.Add("@newKeyId", newKeyId);
orderParms.Add("@Bill", "20");
orderParms.Add("@companyId", CurrentUser.AccountComId);
SqlService.ExecuteProcedureCommand("proc_num", orderParms);
txtKeyId.Text = newKeyId;
//--------------------------------------------------------------
//var orders = new Dictionary<string, object>();
//orders.Clear();
//orders.Add("@KeyId",newKeyId);
//orders.Add("@companyId", CurrentUser.AccountComId);
//SqlService.ExecuteProcedureCommand("proc_ProuctOrder", orders);
//新增日志
var billStatus = new LHBillStatus
{
KeyId = newKeyId,
FCompanyId = CurrentUser.AccountComId,
FActionName = "新增",
FDate = DateTime.Now,
FDeptId = CurrentUser.AccountOrgId,
FOperator = CurrentUser.AccountName,
FMemo = String.Format("单据号{0},{1}新增{2}单据。", newKeyId, CurrentUser.AccountName, ddlFCate.SelectedValue)
};
GasHelper.AddBillStatus(billStatus);
}
return(true);
}
return(false);
}
/// <summary>
/// 加载页面数据
/// </summary>
private void LoadData()
{
switch (Actions)
{
case WebAction.Add:
Region1.Title = "添加气瓶退租单";
txtKeyId.Text = SequenceService.CreateSequence("TM", CurrentUser.AccountComId);
var temp = new LHLeaseReturn
{
KeyId = txtKeyId.Text,
FFlag = 1,
FDeleteFlag = 1,
//租金收款单
FType = Convert.ToInt32(GasEnumBill.LeaseReturn),
CreateBy = CurrentUser.AccountName,
FDate = txtFDate.SelectedDate,
FCompanyId = CurrentUser.AccountComId,
FStatus = Convert.ToInt32(GasEnumBillStauts.Add),
FProgress = Convert.ToInt32(GasEnumBillStauts.Add),
};
//临时写入单据
LeaseReturnService.Add(temp);
break;
case WebAction.Edit:
Region1.Title = "编辑气瓶退租单";
txtKeyId.Text = KeyId;
if (LeaseReturn != null)
{
txtFCode.Text = LeaseReturn.FCode;
tbxFCustomer.Text = LeaseReturn.FName;
txtFAddress.Text = LeaseReturn.FAddress;
//txtFFreight.Text = LeaseReturn.FFreight.ToString();
txtFLinkman.Text = LeaseReturn.FLinkman;
txtFMemo.Text = LeaseReturn.FMemo;
txtFPhone.Text = LeaseReturn.FPhone;
ddlFDriver.Text = LeaseReturn.FDriver;
ddlFShipper.SelectedValue = LeaseReturn.FShipper;
ddlFSupercargo.Text = LeaseReturn.FSupercargo;
ddlFVehicleNum.SelectedValue = LeaseReturn.FVehicleNum;
hfdClass.Text = LeaseReturn.FCate;
ddlSubjectIn.SelectedValue = LeaseReturn.FSubjectCodeIn;
ddlSubjectOut.SelectedValue = LeaseReturn.FSubjectCodeOut;
txtFDepositSecurity.Text = LeaseReturn.FDepositSecurity.ToString();
txtFPaymentRentals.Text = LeaseReturn.FPaymentRentals.ToString();
BindDataGrid();
}
break;
}
}
/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
var leaseReturn = LeaseReturnService.Where(p => p.KeyId == txtKeyId.Text.Trim() && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();
if (leaseReturn != null)
{
ModifiedGrid();
leaseReturn.FCode = txtFCode.Text;
leaseReturn.FName = tbxFCustomer.Text;
leaseReturn.FAddress = txtFAddress.Text.Trim();
leaseReturn.FCompanyId = CurrentUser.AccountComId;
leaseReturn.FFlag = 1;
leaseReturn.FDeleteFlag = 0;
leaseReturn.FLinkman = txtFLinkman.Text.Trim();
leaseReturn.FMemo = txtFMemo.Text.Trim();
leaseReturn.FPhone = txtFPhone.Text.Trim();
leaseReturn.FShipper = !ddlFShipper.SelectedValue.Equals("-1") ? ddlFShipper.SelectedText : "";
leaseReturn.FVehicleNum = !ddlFVehicleNum.SelectedValue.Equals("-1") ? ddlFVehicleNum.SelectedText : "";
leaseReturn.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray);
leaseReturn.FDriver = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray);
leaseReturn.FPaymentRentals = string.IsNullOrEmpty(txtFPaymentRentals.Text.Trim()) ? 0 : Convert.ToDecimal(txtFPaymentRentals.Text.Trim());
leaseReturn.FDepositSecurity = string.IsNullOrEmpty(txtFDepositSecurity.Text.Trim()) ? 0 : Convert.ToDecimal(txtFDepositSecurity.Text.Trim());
leaseReturn.FSubjectCodeIn = ddlSubjectIn.SelectedValue;
leaseReturn.FSubjectNameIn = ddlSubjectIn.SelectedText;
leaseReturn.FSubjectCodeOut = ddlSubjectOut.SelectedValue;
leaseReturn.FSubjectNameOut = ddlSubjectOut.SelectedText;
leaseReturn.FSKNum = "";
leaseReturn.FCate = hfdClass.Text;
leaseReturn.FFKNum = "";
LeaseReturnService.SaveChanges();
var parms = new Dictionary <string, object>();
parms.Clear();
parms.Add("@keyID", leaseReturn.KeyId);
parms.Add("@companyId", CurrentUser.AccountComId);
var data = SqlService.ExecuteProcedureCommand("proc_LeaseReturnAmt", parms).Tables[0];
for (int i = 0; i < data.Rows.Count; i++)
{
int ids = Convert.ToInt32(data.Rows[i]["FDetailsFId"]);
int qty = Convert.ToInt32(data.Rows[i]["Qty"]);
var details = LeaseDetailsService.FirstOrDefault(p => p.FId == ids);
details.FReturnQty = details.FReturnQty + qty;
LeaseDetailsService.SaveChanges();
}
if (txtKeyId.Text.Contains("TM"))
{
//单据号问题
string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "TZ", CurrentUser.AccountComId);
var orderParms = new Dictionary <string, object>();
orderParms.Clear();
orderParms.Add("@oldKeyId", txtKeyId.Text);
orderParms.Add("@newKeyId", newKeyId);
orderParms.Add("@Bill", "8");
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 parmsAuto = new Dictionary <string, object>();
parmsAuto.Clear();
parmsAuto.Add("@KeyId", newKeyId);
parmsAuto.Add("@companyId", CurrentUser.AccountComId);
parmsAuto.Add("@FCate", hfdClass.Text);
parmsAuto.Add("@date", Convert.ToDateTime(leaseReturn.FDate).ToString("yyyy-MM-dd"));
parmsAuto.Add("@FSKNum", leaseReturn.FSKNum);
parmsAuto.Add("@FAbstract", "退租");
SqlService.ExecuteProcedureCommand("proc_SFKLeaseReturnAuto", parmsAuto);
}
return(true);
}
return(false);
}
/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
var stock = StockInService.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.FCompanyId = CurrentUser.AccountComId;
stock.FFlag = 1;
stock.FDeleteFlag = 0;
stock.FFreight = 0;// Convert.ToDecimal(txtFFreight.Text.Trim());
stock.FLinkman = txtFLinkman.Text.Trim();
stock.FMemo = txtFMemo.Text.Trim();
stock.FPhone = txtFPhone.Text.Trim();
//stock.FDriver = !ddlFDriver.SelectedValue.Equals("-1") ? ddlFDriver.SelectedText : "";
stock.FShipper = !ddlFShipper.SelectedValue.Equals("-1") ? ddlFShipper.SelectedText : "";
//stock.FSupercargo = !ddlFSupercargo.SelectedValue.Equals("-1") ? ddlFSupercargo.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_SalesReturnAmt", parms).Tables[0].Rows[0][0]);
stock.FAmount = amt;
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.FClass = ddlReturn.SelectedValue;
LHCustomer custmernodel = new CustomerService().FirstOrDefault(p => p.FCode == txtFCode.Text.Trim());
if (custmernodel != null)
{
hfdCate.Text = "客户";
}
else
{
hfdCate.Text = "供应商";
}
stock.FCate = hfdCate.Text;
stock.FDate = txtFDate.SelectedDate;
stock.FDistributionPoint = ddlFDistributionPoint.SelectedValue;
stock.FTime1 = DateTime.Now;
StockInService.SaveChanges();
if (txtKeyId.Text.Contains("TM"))
{
//单据号问题
string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "HK", CurrentUser.AccountComId);
var orderParms = new Dictionary <string, object>();
orderParms.Clear();
orderParms.Add("@oldKeyId", txtKeyId.Text);
orderParms.Add("@newKeyId", newKeyId);
orderParms.Add("@Bill", "13");
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);
}
/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
var stock = StockInService.Where(p => p.KeyId == txtKeyId.Text.Trim() && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();
if (stock != null)
{
ModifiedGrid();
var prod =
StockInDetailsService.FirstOrDefault(
p => p.KeyId == txtKeyId.Text && p.FCompanyId == CurrentUser.AccountComId);
if (prod == null)
{
//生产产品入库
var product = new LHStockInDetails
{
KeyId = txtKeyId.Text,
FItemCode = txtFCode.Text,
FPrice = 0,
FAmount = 0,
FQty = Convert.ToDecimal(txtFQty.Text),
FBottle = tbxFBottle.SelectedValue,
FBottleQty = Convert.ToInt16(txtFBottleQty.Text),
FBottleOweQty = 0,
FCompanyId = CurrentUser.AccountComId,
FCateId = 2000,
FMemo = "生产入库",
FCostPrice = Convert.ToDecimal(txtFCostPrice.Text),
FBalance = Convert.ToDecimal(txtFBalance.Text),
};
StockInDetailsService.Add(product);
}
else
{
prod.FItemCode = txtFCode.Text;
prod.FQty = Convert.ToDecimal(txtFQty.Text);
prod.FBottle = tbxFBottle.SelectedValue;
prod.FBottleQty = Convert.ToInt32(txtFBottleQty.Text);
prod.FCostPrice = Convert.ToDecimal(txtFCostPrice.Text);
prod.FBalance = Convert.ToDecimal(txtFBalance.Text);
StockInDetailsService.SaveChanges();
}
//-------------------------------------------------------------------
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_PurchaseAmt", parms).Tables[0].Rows[0][0]);
stock.FAmount = amt;
stock.FSurveyor = !ddlFSurveyor.SelectedValue.Equals("-1") ? ddlFSurveyor.SelectedText : "";
stock.FProducer = !ddlFProducer.SelectedValue.Equals("-1") ? ddlFProducer.SelectedText : "";//GasHelper.GetDropDownListArrayString(ddlFProducer.SelectedItemArray);
stock.FBatchNumber = txtFBatchNumber.Text.Trim();
stock.FProductionWorkshop = ddlWorkShop.SelectedValue;
stock.FCate = "内部";
stock.FCode = CurrentUser.AccountComId.ToString(CultureInfo.InvariantCulture);
stock.FName = "";
stock.FDate = txtFDate.SelectedDate;
StockInService.SaveChanges();
if (txtKeyId.Text.Contains("TM"))
{
//单据号问题
string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "PR", CurrentUser.AccountComId);
var orderParms = new Dictionary <string, object>();
orderParms.Clear();
orderParms.Add("@oldKeyId", txtKeyId.Text);
orderParms.Add("@newKeyId", newKeyId);
orderParms.Add("@Bill", "6");
orderParms.Add("@companyId", CurrentUser.AccountComId);
SqlService.ExecuteProcedureCommand("proc_num", orderParms);
txtKeyId.Text = newKeyId;
var orders = new Dictionary <string, object>();
orders.Clear();
orders.Add("@KeyId", newKeyId);
orders.Add("@companyId", CurrentUser.AccountComId);
SqlService.ExecuteProcedureCommand("proc_ProuctOrder", orders);
//新增日志
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);
}
/// <summary>
/// 加载页面数据
/// </summary>
private void LoadData()
{
switch (Actions)
{
case WebAction.Add:
txtKeyId.Text = SequenceService.CreateSequence("TM", CurrentUser.AccountComId);
Region1.Title = "添加采购单";
txtFT6ExchangeRate.Text = "1";
var temp = new LHStockIn
{
KeyId = txtKeyId.Text,
FFlag = 1,
FDeleteFlag = 1,
//发货单
FType = Convert.ToInt32(GasEnumBill.Purchase),
CreateBy = CurrentUser.AccountName,
FDate = txtFDate.SelectedDate,
FCompanyId = CurrentUser.AccountComId,
FStatus = Convert.ToInt32(GasEnumBillStauts.Add),
FProgress = Convert.ToInt32(GasEnumBillStauts.Add),
FCate = "供应商"
};
//临时写入单据
StockInService.Add(temp);
//合计
var summary = new JObject
{
{ "FItemCode", "合计" },
{ "FQty", 0 },
{ "FAmount", 0 }
};
Grid1.SummaryData = summary;
break;
case WebAction.Edit:
Region1.Title = "编辑采购单";
txtKeyId.Text = KeyId;
if (StockIn != null)
{
WebControlHandler.BindObjectToControls(StockIn, SimpleForm1);
txtFDate.SelectedDate = StockIn.FDate;
tbxFCustomer.Text = StockIn.FName;
if (!string.IsNullOrEmpty(StockIn.FDriver))
{
ddlFDriver.SelectedValueArray = StockIn.FDriver.Split(',');
}
if (!string.IsNullOrEmpty(StockIn.FShipper))
{
ddlFShipper.SelectedValueArray = StockIn.FShipper.Split(',');
}
if (!string.IsNullOrEmpty(StockIn.FSupercargo))
{
ddlFSupercargo.SelectedValueArray = StockIn.FSupercargo.Split(',');
}
if (!string.IsNullOrEmpty(StockIn.FSalesman))
{
ddlFSalesman.SelectedValueArray = StockIn.FSalesman.Split(',');
}
ddlSubject.SelectedValue = StockIn.FSubjectCode;
ddlFVehicleNum.SelectedValue = StockIn.FVehicleNum;
ddlFArea.SelectedValue = StockIn.FArea;
ddlDeliveryMethod.SelectedValue = StockIn.FDeliveryMethod;
ddlFT6PurchaseType.SelectedValue = StockIn.FT6PurchaseTypeNum;
ddlFT6Currency.SelectedValue = StockIn.FT6Currency;
ddlT6ReceiveSendType.SelectedValue = StockIn.FT6ReceiveSendTypeNum;
tbxFLogisticsNumber.Text = StockIn.FLogisticsNumber;
ddlWarehouse.SelectedValue = StockIn.FT6Warehouse;
ddlFDistributionPoint.SelectedValue = StockIn.FDistributionPoint;
BindDataGrid();
}
break;
}
}
/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
var stock = StockInService.Where(p => p.KeyId == txtKeyId.Text.Trim() && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();
if (stock != null)
{
ModifiedGrid();
//stock.FClass = ddlFCate.SelectedValue;
stock.FCode = txtFCode.Text;
stock.FName = tbxFCustomer.Text;
stock.FAddress = txtFAddress.Text.Trim();
stock.FCompanyId = CurrentUser.AccountComId;
stock.FFlag = 1;
stock.FDeleteFlag = 0;
if (!string.IsNullOrEmpty(txtFFreight.Text.Trim()))
{
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_PurchaseAmt", parms).Tables[0].Rows[0][0]);
stock.FAmount = amt;
stock.FDate = txtFDate.SelectedDate;
stock.FReconciliation = txtFReconciliation.Text;
stock.FDeliveryMethod = ddlDeliveryMethod.SelectedValue;
stock.FLogisticsNumber = tbxFLogisticsNumber.Text;
stock.FAmt = string.IsNullOrEmpty(txtFAmt.Text.Trim()) ? 0 : Convert.ToDecimal(txtFAmt.Text.Trim());
stock.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray);
stock.FDriver = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray);
stock.FSubjectCode = ddlSubject.SelectedValue;
stock.FSubjectName = ddlSubject.SelectedText;
stock.FDate = txtFDate.SelectedDate;
#region T6 对接接口
//---------------------------------------------------------
//收发类型
stock.FT6ReceiveSendType = ddlT6ReceiveSendType.SelectedText;
stock.FT6ReceiveSendTypeNum = ddlT6ReceiveSendType.SelectedValue;
//部门名称
stock.FT6Department = "";
//部门代码
stock.FT6DepartmentNum = "";
//业务员代码
stock.FT6SalesmanNum = "";
//币种
stock.FT6Currency = ddlFT6Currency.SelectedValue;
//汇率
stock.FT6ExchangeRate = Convert.ToDecimal(txtFT6ExchangeRate.Text);
//销售类型
stock.FT6PurchaseType = ddlFT6PurchaseType.SelectedText;
stock.FT6PurchaseTypeNum = ddlFT6PurchaseType.SelectedValue;
//T6同步
stock.FT6Status = "未同步";
stock.FT6Warehouse = ddlWarehouse.SelectedValue;
//---------------------------------------------------------
#endregion
stock.FDistributionPoint = ddlFDistributionPoint.SelectedValue;
StockInService.SaveChanges();
//订单出库
var passCard = PassCardService.Where(p => p.KeyId == tbxFLogisticsNumber.Text.Trim()).FirstOrDefault();
if (passCard != null)
{
passCard.FOutFlag = "已出库";
PassCardService.SaveChanges();
}
if (txtKeyId.Text.Contains("TM"))
{
//单据号问题
string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "WC", CurrentUser.AccountComId);
var orderParms = new Dictionary <string, object>();
orderParms.Clear();
orderParms.Add("@oldKeyId", txtKeyId.Text);
orderParms.Add("@newKeyId", newKeyId);
orderParms.Add("@Bill", "4");
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 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", string.IsNullOrEmpty(stock.FSKNum) ? "" : stock.FSKNum);
SqlService.ExecuteProcedureCommand("proc_FKOrderAuto", parmsAuto);
}
return(true);
}
return(false);
}
/// <summary>
/// 加载页面数据
/// </summary>
private void LoadData()
{
switch (Actions)
{
case WebAction.Add:
Region1.Title = "添加收款单";
txtKeyId.Text = SequenceService.CreateSequence("TM", CurrentUser.AccountComId);
var temp = new LHSKOrder
{
keyId = txtKeyId.Text,
FFlag = 1,
FDeleteFlag = 1,
//发货单
//FType = Convert.ToInt32(GasEnumBill.Receipt),
CreateBy = CurrentUser.AccountName,
FDate = txtFDate.SelectedDate,
FAmount = 0,
FCate = "客户",
FCompanyId = CurrentUser.AccountComId
//F = CurrentUser.AccountComId,
//FStatus = Convert.ToInt32(GasEnumBillStauts.Add),
//FProgress = Convert.ToInt32(GasEnumBillStauts.Add),
};
//临时写入单据
SKOrderService.Add(temp);
var summary = new JObject
{
{ "FCode", "合计" },
{ "FAmt", 0 },
};
Grid1.SummaryData = summary;
break;
case WebAction.Edit:
txtKeyId.Text = KeyId;
Region1.Title = "编辑收款单";
if (SkOrder != null)
{
txtFCode.Text = SkOrder.FCode;
tbxFCustomer.Text = SkOrder.FName;
ddlFAbstract.SelectedValue = SkOrder.FAbstract;
txtFMemo.Text = SkOrder.FMemo;
BindDataGrid();
}
break;
}
}