/// <summary> /// 添加/修改 /// </summary> /// <param name="modelBillMain"></param> /// <param name="modelTravelReport"></param> /// <param name="strMsg"></param> /// <returns></returns> public int Insert(Models.Bill_Main modelBillMain, Models.Bill_TravelReport modelTravelReport, out string strMsg) { try { strMsg = ""; if (modelBillMain == null || modelTravelReport == null) { throw new Exception("主表或出差报告单模型不能为空"); } //主表 int iMainRel = bllMainBill.Add(modelBillMain); if (iMainRel <= 0) { throw new Exception("向主表插入数据时发生未知错误!"); } //出差申请单 int iTravelRepRel = dalTravelReport.Add(modelTravelReport); if (iTravelRepRel <= 0) { throw new Exception("向出差报告单插入数据时发生未知错误!"); } return(1); } catch (Exception e) { strMsg = e.Message; return(-1); } }
/// <summary> /// 添加 /// </summary> /// <param name="lstmodelWeiXiuShenQing"></param> /// <param name="strmsg"></param> /// <returns></returns> public int Add(List <Models.ZiChan_WeiXiuShenQing> lstmodelWeiXiuShenQing, out string strmsg) { strmsg = ""; if (lstmodelWeiXiuShenQing.Count == 0) { strmsg = "添加明细不能为空!"; return(-1); } //添加到主表 Models.Bill_Main modelBillMain = new Models.Bill_Main(); modelBillMain.BillCode = lstmodelWeiXiuShenQing[0].MainCode; modelBillMain.BillDate = DateTime.Parse(lstmodelWeiXiuShenQing[0].Note1); modelBillMain.BillDept = lstmodelWeiXiuShenQing[0].Note2; modelBillMain.BillJe = lstmodelWeiXiuShenQing.Sum(p => Convert.ToInt32(p.YuJiJinE)); modelBillMain.BillName = lstmodelWeiXiuShenQing[0].MainCode; modelBillMain.BillName2 = ""; modelBillMain.BillType = ""; modelBillMain.BillUser = lstmodelWeiXiuShenQing[0].ShenQingRenCode; modelBillMain.FlowId = "wxsq"; modelBillMain.GkDept = ""; modelBillMain.IsGk = "0"; modelBillMain.LoopTimes = 0; modelBillMain.StepId = "-1"; try { if (new Bll.Bills.BillMainBLL().Add(modelBillMain) <= 0) { throw new Exception("未知错误!"); } } catch (Exception ex) { strmsg = "添加主表时失败,原因:" + ex.Message; return(-1); } //添加明细表 dalZiChan_WeiXiuShenQing.Deletezb(lstmodelWeiXiuShenQing[0].MainCode); for (int i = 0; i < lstmodelWeiXiuShenQing.Count; i++) { try { int iRel = dalZiChan_WeiXiuShenQing.Add(lstmodelWeiXiuShenQing[i]); if (iRel <= 0) { throw new Exception("未知错误!"); } } catch (Exception ex) { strmsg = "添加子表时失败,原因:" + ex.Message; return(-1);; } } return(1); }