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 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 InsertProviderContactHistory(ProviderContactHistoryModel model, out string ID) { ArrayList listADD = new ArrayList(); bool result = false; ID = "0"; #region 采购供应商联络添加SQL语句 StringBuilder sqlArrive = new StringBuilder(); sqlArrive.AppendLine("INSERT INTO officedba.ProviderContactHistory"); sqlArrive.AppendLine("(CompanyCD,CustID,ContactNo,Title,LinkManID,LinkManName,LinkReasonID,LinkMode,LinkDate,Linker,Contents)"); sqlArrive.AppendLine("VALUES (@CompanyCD,@CustID,@ContactNo,@Title,@LinkManID,@LinkManName,@LinkReasonID,@LinkMode,@LinkDate,@Linker,@Contents)"); sqlArrive.AppendLine("set @ID=@@IDENTITY"); SqlCommand comm = new SqlCommand(); comm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD)); comm.Parameters.Add(SqlHelper.GetParameter("@CustID", model.CustID)); comm.Parameters.Add(SqlHelper.GetParameter("@ContactNo", model.ContactNo)); comm.Parameters.Add(SqlHelper.GetParameter("@Title", model.Title)); comm.Parameters.Add(SqlHelper.GetParameter("@LinkManID", model.LinkManID)); comm.Parameters.Add(SqlHelper.GetParameter("@LinkManName", model.LinkManName)); comm.Parameters.Add(SqlHelper.GetParameter("@LinkReasonID", model.LinkReasonID)); comm.Parameters.Add(SqlHelper.GetParameter("@LinkMode", model.LinkMode)); comm.Parameters.Add(SqlHelper.GetParameter("@LinkDate", model.LinkDate == null ? SqlDateTime.Null : SqlDateTime.Parse(model.LinkDate.ToString()))); comm.Parameters.Add(SqlHelper.GetParameter("@Linker", model.Linker)); comm.Parameters.Add(SqlHelper.GetParameter("@Contents", model.Contents)); comm.Parameters.Add(SqlHelper.GetOutputParameter("@ID", SqlDbType.Int)); comm.CommandText = sqlArrive.ToString(); listADD.Add(comm); #endregion try { if (SqlHelper.ExecuteTransWithArrayList(listADD)) { ID = comm.Parameters["@ID"].Value.ToString(); result = true; } return(result); } catch (Exception ex) { throw ex; } }
public static bool UpdateProviderContactHistory(ProviderContactHistoryModel model) { if (model.ID <= 0) { return(false); } ArrayList listADD = new ArrayList(); bool result = false; #region 修改供应商联络 StringBuilder sqlArrive = new StringBuilder(); sqlArrive.AppendLine("Update Officedba.ProviderContactHistory set CompanyCD=@CompanyCD,"); sqlArrive.AppendLine("CustID=@CustID,ContactNo=@ContactNo,Title=@Title,LinkManID=@LinkManID,LinkManName=@LinkManName,LinkReasonID=@LinkReasonID,"); sqlArrive.AppendLine("LinkMode=@LinkMode,LinkDate=@LinkDate,Linker=@Linker,Contents=@Contents where CompanyCD=@CompanyCD and ID=@ID"); SqlCommand comm = new SqlCommand(); comm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD)); comm.Parameters.Add(SqlHelper.GetParameter("@CustID", model.CustID)); comm.Parameters.Add(SqlHelper.GetParameter("@ContactNo", model.ContactNo)); comm.Parameters.Add(SqlHelper.GetParameter("@Title", model.Title)); comm.Parameters.Add(SqlHelper.GetParameter("@LinkManID", model.LinkManID)); comm.Parameters.Add(SqlHelper.GetParameter("@LinkManName", model.LinkManName)); comm.Parameters.Add(SqlHelper.GetParameter("@LinkReasonID", model.LinkReasonID)); comm.Parameters.Add(SqlHelper.GetParameter("@LinkMode", model.LinkMode)); comm.Parameters.Add(SqlHelper.GetParameter("@LinkDate", model.LinkDate == null ? SqlDateTime.Null : SqlDateTime.Parse(model.LinkDate.ToString()))); comm.Parameters.Add(SqlHelper.GetParameter("@Linker", model.Linker)); comm.Parameters.Add(SqlHelper.GetParameter("@Contents", model.Contents)); comm.Parameters.Add(SqlHelper.GetParameter("@ID", model.ID)); comm.CommandText = sqlArrive.ToString(); listADD.Add(comm); #endregion try { if (SqlHelper.ExecuteTransWithArrayList(listADD)) { result = true; } return(result); } catch (Exception ex) { throw ex; } }