//保存表单数据
public ActionResult SaveData(BackOutput BackOutput)
{
//参数对象可以对应接受数据
BackOutput.MakePerson = Session["UserName"].ToString(); //保存制单人
string result = BackOutputService.SaveData(BackOutput); //保存数据
return(Content(result.ToString()));
}
private string AddBackOutput(DataTable dt)
{
BackOutput bill = DataTableToEntites.GetEntity <BackOutput>(dt.Rows[0]);
bill.Record = HandleRecords(dt);
BackOutputService Service = new BackOutputService();
Service.SaveData(bill);
return(bill.BillCode);
}
//获取表单数据
public ActionResult GetData()
{
string str = Request.Params["BackOutputId"];//单号
//如果新单据 没有数据
if (string.IsNullOrEmpty(str))
{
return(Json(new BackOutput()));//返回一个新建的空对象
}
//如果有数据
Guid BackOutputId = new Guid(Request["BackOutputId"]); //单据编号
BackOutput bill = BackOutputService.LoadEntities(t => t.Id == BackOutputId).FirstOrDefault(); //获取表单
return(Json(bill));
}
/// <summary>
/// 导出退货单
/// </summary>
/// <param name="billId"></param>
/// <param name="TemplateUrl"></param>
/// <returns></returns>
private MemoryStream ExportBackOutput(Guid billId, string TemplateUrl)
{
BackOutput bill = CurrentDBSession.BackOutputDal.LoadEntities(a => a.Id == billId).FirstOrDefault();
if (bill == null)
{
return(null);
}
DataTable dt = ExcelHelp.ExcelToDT(TemplateUrl);
foreach (var record in bill.Record)
{
DataRow dr = dt.NewRow();
dr["LBBillCode"] = bill.LBBillCode;
dr["LBBillDate"] = bill.LBBillDate;
dr["LBCustomerCode"] = bill.LBCustomerCode;
dr["LBCustomerName"] = bill.LBCustomerName;
dr["LBSendAddress"] = bill.LBSendAddress;
dr["LBContacts"] = bill.LBContacts;
dr["LBPhone"] = bill.LBPhone;
dr["LBMailCode"] = bill.LBMailCode;
dr["LBReson"] = bill.LBReson;
dr["LBRemark"] = bill.LBRemark;
dr["CreateDate"] = bill.CreateDate;
dr["Warehouse"] = bill.Warehouse;
dr["WarehouseId"] = bill.WarehouseId;
dr["LoadGoodsType"] = bill.LoadGoodsType;
dr["InputType"] = bill.InputType;
dr["InputTypeId"] = bill.InputTypeId;
dr["ChargePerson"] = bill.ChargePerson;
dr["MakePerson"] = bill.MakePerson;
dr["BusinessType"] = bill.BusinessType;
dr["LineWay"] = bill.LineWay;
dr["Remark"] = bill.Remark;
dr["Department"] = bill.Department;
dr["DepartmentId"] = bill.DepartmentId;
dr["Company"] = bill.Company;
dr["CompanyId"] = bill.CompanyId;
//子表
dr["ItemCode"] = record.ItemCode;
dr["ItemLocationId"] = record.ItemLocationId;
dr["ItemBatch"] = record.ItemBatch;
dr["Count"] = record.Count;
dt.Rows.Add(dr);
}
return(NPIOHelper.RenderToMemory(dt, "sheet1"));
}
