/// <summary> /// 插入采购询价单 /// </summary> /// <param name="PurchaseAskPriceM">采购询价单主表model</param> /// <param name="PurchaseAskPriceDetailMList">采购询价单明细表model列表</param> /// <returns>bool</returns> public static bool InsertPurchaseAskPrice(PurchaseAskPriceModel PurchaseAskPriceM , List <PurchaseAskPriceDetailModel> PurchaseAskPriceDetailMList, out int IndexIDentity, Hashtable htExtAttr) { try { ArrayList lstAdd = new ArrayList(); SqlCommand AddPri = PurchaseAskPriceDBHelper.InsertPurAskPricePri(PurchaseAskPriceM); lstAdd.Add(AddPri); foreach (PurchaseAskPriceDetailModel PurchaseAskPriceDetailM in PurchaseAskPriceDetailMList) { SqlCommand AddDtl = PurchaseAskPriceDBHelper.InsertPurAskPriceDetail(PurchaseAskPriceDetailM); lstAdd.Add(AddDtl); } #region 拓展属性 SqlCommand cmd = new SqlCommand(); GetExtAttrCmd(PurchaseAskPriceM, htExtAttr, cmd); if (htExtAttr.Count > 0) { lstAdd.Add(cmd); } #endregion //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //定义返回变量 bool isSucc = false; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ //执行插入操作 try { isSucc = SqlHelper.ExecuteTransWithArrayList(lstAdd); } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } //定义变量 string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; IndexIDentity = int.Parse(((SqlCommand)AddPri).Parameters["@IndexID"].Value.ToString()); } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; IndexIDentity = 0; } LogInfoModel logModel = InitLogInfo(PurchaseAskPriceM.AskNo); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_INSERT; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return(isSucc); } catch (Exception ex) { throw ex; } }
/// <summary> /// 更新采购询价单 /// </summary> /// <param name="PurchaseAskPriceM">采购询价单主表model</param> /// <param name="PurchaseAskPriceDetailMList">采购询价单明细表model列表</param> /// <returns>bool</returns> /// public static bool UpdatePurchaseAskPrice(PurchaseAskPriceModel PurchaseAskPriceM , List <PurchaseAskPriceDetailModel> PurchaseAskPriceDetailMList, Hashtable htExtAttr) { try { ArrayList lstUpdate = new ArrayList(); if (PurchaseAskPriceM.AskAgain == "1") {//再次询价,需将此次询价之前的那次询价记录记入询价历史表 SqlCommand AskAgain = PurchaseAskPriceDBHelper.InsertPurchaseAskHistory(PurchaseAskPriceM.ID); lstUpdate.Add(AskAgain); } SqlCommand UpdatePri = PurchaseAskPriceDBHelper.UpdatePurAskPricePri(PurchaseAskPriceM); lstUpdate.Add(UpdatePri); #region 拓展属性 SqlCommand cmd = new SqlCommand(); GetExtAttrCmd(PurchaseAskPriceM, htExtAttr, cmd); if (htExtAttr.Count > 0) { lstUpdate.Add(cmd); } #endregion SqlCommand DelDtl = PurchaseAskPriceDBHelper.DeletePurAskPriceDetail(PurchaseAskPriceM.AskNo); lstUpdate.Add(DelDtl); foreach (PurchaseAskPriceDetailModel PurchaseAskPriceDetailM in PurchaseAskPriceDetailMList) { SqlCommand AddDtl = PurchaseAskPriceDBHelper.InsertPurAskPriceDetail(PurchaseAskPriceDetailM); lstUpdate.Add(AddDtl); } //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //定义返回变量 bool isSucc = false; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ //执行插入操作 try { isSucc = SqlHelper.ExecuteTransWithArrayList(lstUpdate); } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } //定义变量 string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } LogInfoModel logModel = InitLogInfo(PurchaseAskPriceM.AskNo); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_INSERT; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return(isSucc); } catch (Exception ex) { throw ex; } }