/// <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);
}
}
