/// <summary> /// 明细编辑 /// </summary> /// <param name="billNo">单据号</param> /// <param name="listInfo">明细信息列表</param> /// <param name="error">错误信息</param> /// <returns>成功返回True,否则False</returns> public bool EditListInfo(string billNo, List <View_S_GoodsEnteringBill> listInfo, out string error) { DepotManagementDataContext ctx = CommentParameter.DepotDataContext; error = null; try { var varData = from a in ctx.S_GoodsEnteringBill where a.BillNo == billNo select a; ctx.S_GoodsEnteringBill.DeleteAllOnSubmit(varData); ctx.SubmitChanges(); foreach (View_S_GoodsEnteringBill item in listInfo) { S_GoodsEnteringBill templnq = new S_GoodsEnteringBill(); templnq.BillNo = billNo; templnq.Depot = item.材料类别编码; templnq.GoodsCode = item.图号型号; templnq.GoodsName = item.物品名称; templnq.Remark = item.备注; templnq.Spec = item.规格; templnq.Remark = item.备注; string strUnitID = UniversalFunction.GetUnitID(item.单位); templnq.UnitID = strUnitID == "" ? null : (int?)Convert.ToInt32(strUnitID); ctx.S_GoodsEnteringBill.InsertOnSubmit(templnq); } ctx.SubmitChanges(); return(true); } catch (Exception ex) { error = ex.Message; return(false); } }
/// <summary> /// 明细编辑 /// </summary> /// <param name="ctx">数据上下文</param> /// <param name="billNo">单据号</param> /// <param name="listInfo">明细信息列表</param> void EditListInfo(DepotManagementDataContext ctx, string billNo, List <View_S_GoodsEnteringBill> listInfo) { try { var varData = from a in ctx.S_GoodsEnteringBill where a.BillNo == billNo select a; ctx.S_GoodsEnteringBill.DeleteAllOnSubmit(varData); ctx.SubmitChanges(); foreach (View_S_GoodsEnteringBill item in listInfo) { S_GoodsEnteringBill templnq = new S_GoodsEnteringBill(); templnq.BillNo = billNo; templnq.Depot = item.材料类别编码; templnq.GoodsCode = item.图号型号; templnq.GoodsName = item.物品名称; templnq.Remark = item.备注; templnq.Spec = item.规格; templnq.Remark = item.备注; string strUnitID = UniversalFunction.GetUnitID(item.单位); templnq.UnitID = strUnitID == "" ? null : (int?)Convert.ToInt32(strUnitID); ctx.S_GoodsEnteringBill.InsertOnSubmit(templnq); } ctx.SubmitChanges(); } catch (Exception ex) { throw new Exception(ex.Message); } }