public void SaveDeliveryBill(System.Web.Mvc.FormCollection fc, UserInfo user)
{
Sale_eqm_ch_bill bill = new Sale_eqm_ch_bill();
SomeUtils.SetFieldValueToModel(fc, bill);
List <Sale_eqm_ch_bill_detail> details = JsonConvert.DeserializeObject <List <Sale_eqm_ch_bill_detail> >(fc.Get("ch_bill_details"));
bill.FUserName = user.realName;
bill.FSaveDate = DateTime.Now;
bill.Sale_eqm_ch_bill_detail.AddRange(details);
if (string.IsNullOrEmpty(bill.FSysNo))
{
bill.FSysNo = GetNextSysNo();
}
else
{
var existedBill = db.Sale_eqm_ch_bill.Where(s => s.FSysNo == bill.FSysNo && (s.FDeleted == null || s.FDeleted == false)).FirstOrDefault();
if (existedBill != null)
{
existedBill.FDeleted = true;
}
}
db.Sale_eqm_ch_bill.InsertOnSubmit(bill);
db.SubmitChanges();
}
public JsonResult GetK3StockBill(string account, string billNo)
{
var sv = new EqmSv();
List <getK3EqmChDataResult> list;
try {
list = sv.GetK3StockBill(account, billNo);
}
catch (Exception ex) {
return(Json(new { suc = false, msg = ex.Message }));
}
if (list.Count() < 1)
{
return(Json(new { suc = false, msg = "在K3找不到此销售出库单号" }));
}
var h = list.First();
var bill = new Sale_eqm_ch_bill();
bill.FAccount = account;
bill.FBillNo = billNo;
bill.FDate = h.FDate;
bill.FCustomerName = h.FCustomerName;
bill.FCustomerNumber = h.FCustomerNumber;
bill.FUserName = currentUser.realName;
var details = new List <Sale_eqm_ch_bill_detail>();
foreach (var l in list)
{
var d = new Sale_eqm_ch_bill_detail();
d.FAmount = l.FConsignAmount;
d.FIndex = l.FEntryID;
d.FItemModel = l.FModel;
d.FItemName = l.FName;
d.FItemNumber = l.FNumber;
d.FPrice = l.FConsignPrice;
d.FQty = (int)l.FAuxQty;
d.FUnitName = l.FUnitName;
details.Add(d);
}
var deliveryInfo = sv.GetDeliveryInfo(bill.FCustomerNumber);
Wlog(string.Format("获取出库单信息，account:{0},billNo:{1}", account, billNo));
return(Json(new { suc = true, bill = bill, details = details, deliveryInfo = deliveryInfo }));
}