/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
var order = SKOrderService.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;
order.FAbstract = ddlFAbstract.SelectedValue;
order.FDate = txtFDate.SelectedDate;
//order.FVerificationFlag = 0;//未核销的
var parms = new Dictionary <string, object>();
parms.Clear();
parms.Add("@KeyId", txtKeyId.Text.Trim());
parms.Add("@companyId", CurrentUser.AccountComId);
var amt =
Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_SKOrderAmt", parms).Tables[0].Rows[0][0]);
order.FAmount = amt;
SKOrderService.SaveChanges();
if (txtKeyId.Text.Contains("TM"))
{
//单据号问题
string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "SK", CurrentUser.AccountComId);
var orderParms = new Dictionary <string, object>();
orderParms.Clear();
orderParms.Add("@oldKeyId", txtKeyId.Text);
orderParms.Add("@newKeyId", newKeyId);
orderParms.Add("@Bill", "12");
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:
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;
}
}
/// <summary>
/// 提交编辑
/// </summary>
private bool SubmintEdit()
{
if (SkOrder != null)
{
SkOrder.FCode = txtFCode.Text;
SkOrder.FName = tbxFCustomer.Text;
SkOrder.FAbstract = ddlFAbstract.SelectedValue;
//------------------------------------------------------
SkOrder.FDate = txtFDate.SelectedDate;
//StockOut.FAddress = txtFAddress.Text.Trim();
//CollectionOrder.FCompanyId = CurrentUser.AccountComId;
//StockOut.FShipper = !ddlFShipper.SelectedValue.Equals("-1") ? ddlFShipper.SelectedText : "";
//StockOut.FVehicleNum = !ddlFVehicleNum.SelectedValue.Equals("-1") ? ddlFVehicleNum.SelectedText : "";
//StockOut.FFlag = 1;
//StockOut.FFreight = Convert.ToDecimal(txtFFreight.Text.Trim());
//StockOut.FLinkman = txtFLinkman.Text.Trim();
SkOrder.FMemo = txtFMemo.Text.Trim();
//StockOut.FPhone = txtFPhone.Text.Trim();
//var parms = new Dictionary<string, object>();
//parms.Clear();
//parms.Add("@keyID", CollectionOrder.keyId);
//var amt =
// Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_SalesAmt", parms).Tables[0].Rows[0][0]);
//CollectionOrder.FAmount = amt;
//if (ddlFSupercargo.SelectedItem != null)
//{
// var texts = new List<string>();
// foreach (ListItem item in ddlFSupercargo.SelectedItemArray)
// {
// texts.Add(item.Text);
// }
// if (!string.IsNullOrEmpty(String.Join(",", texts.ToArray())))
// {
// StockOut.FSupercargo = String.Join(",", texts.ToArray());
// }
//}
//if (ddlFDriver.SelectedItem != null)
//{
// var texts = new List<string>();
// foreach (ListItem item in ddlFDriver.SelectedItemArray)
// {
// texts.Add(item.Text);
// }
// if (!string.IsNullOrEmpty(String.Join(",", texts.ToArray())))
// {
// StockOut.FDriver = String.Join(",", texts.ToArray());
// }
//}
var parms = new Dictionary <string, object>();
parms.Clear();
parms.Add("@KeyId", txtKeyId.Text.Trim());
parms.Add("@companyId", CurrentUser.AccountComId);
var amt =
Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_SKOrderAmt", parms).Tables[0].Rows[0][0]);
SkOrder.FAmount = amt;
SkOrder.CreateBy = CurrentUser.AccountName;
return(SKOrderService.SaveChanges() >= 0);
}
return(false);
}
