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