public static bool InsertProviderContactHistory(ProviderContactHistoryModel model, out string ID) { try { bool succ = false; LogInfoModel logModel = InitLogInfo(model.ContactNo); logModel.Element = ConstUtil.LOG_PROCESS_INSERT; //设置模块ID 模块ID请在ConstUtil中定义,以便维护 logModel.ModuleID = ConstUtil.MODULE_ID_PROVIDERCONTRACTHISTORY_ADD; succ = ProviderContactHistoryDBHelper.InsertProviderContactHistory(model, out ID); if (!succ) { logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; } else { logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; } LogDBHelper.InsertLog(logModel); return(succ); } catch (System.Exception ex) { throw ex; } }
public static bool UpdateProviderContactHistory(ProviderContactHistoryModel model) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; if (model.ID <= 0) { return(false); } try { bool succ = false; LogInfoModel logModel = InitLogInfo(model.ContactNo); logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; //设置模块ID 模块ID请在ConstUtil中定义,以便维护 logModel.ModuleID = ConstUtil.MODULE_ID_PROVIDERCONTRACTHISTORY_ADD; succ = ProviderContactHistoryDBHelper.UpdateProviderContactHistory(model); if (!succ) { logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; } else { logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; } LogDBHelper.InsertLog(logModel); return(succ); } catch (System.Exception ex) { throw ex; } }
public static bool DeleteProviderContactHistory(string ID, string CompanyCD) { if (string.IsNullOrEmpty(ID)) { return(false); } try { //LogInfoModel logModel = InitLogInfo(ContactNo); UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; bool isSucc = ProviderContactHistoryDBHelper.DeleteProviderContactHistory(ID, CompanyCD);//供应商联系人 string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } //获取删除的编号列表 string[] noList = ID.Split(','); //遍历所有编号,登陆操作日志 for (int i = 0; i < noList.Length; i++) { //获取编号 string no = noList[i]; //替换两边的 ' no = no.Replace("'", string.Empty); //操作日志 LogInfoModel logModel = InitLogInfo("联络单ID:" + no); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_DELETE; //设置模块ID 模块ID请在ConstUtil中定义,以便维护 logModel.ModuleID = ConstUtil.MODULE_ID_PROVIDERCONTRACTHISTORYINFO; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); } return(isSucc); } catch (Exception) { return(false); throw; } }
/// <summary> /// 获取供应商联络延期警告的信息 /// </summary> /// <returns></returns> public static DataTable SelectProviderContactDelay(int pageIndex, int pageCount, string orderBy, ref int TotalCount, string CompanyCD) { try { return(ProviderContactHistoryDBHelper.SelectProviderContactDelay(pageIndex, pageCount, orderBy, ref TotalCount, CompanyCD)); } catch { return(null); } }
public static DataTable SelectProviderContactHistory(int ID) { try { return(ProviderContactHistoryDBHelper.SelectProviderContactHistory(ID)); } catch { return(null); } }
public static DataTable SelectProviderContactHistory(int pageIndex, int pageCount, string orderBy, ref int TotalCount, string CustID, string Linker, string StartLinkDate, string EndLinkDate) { try { return(ProviderContactHistoryDBHelper.SelectProviderContactHistoryList(pageIndex, pageCount, orderBy, ref TotalCount, CustID, Linker, StartLinkDate, EndLinkDate)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 绑定采购供应商联络方式 /// </summary> /// <returns>DataTable</returns> public static DataTable GetdrpLinkMode() { DataTable dt = ProviderContactHistoryDBHelper.GetdrpLinkMode(); return(dt); }