public static bool UpdateProviderProduct(ProviderProductModel model) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; if (model.ID <= 0) { return false; } try { bool succ = false; LogInfoModel logModel = InitLogInfo("推荐物品ID:" + Convert.ToString(model.ID)); logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; //设置模块ID 模块ID请在ConstUtil中定义,以便维护 logModel.ModuleID = ConstUtil.MODULE_ID_PROVIDERPRODUCT_ADD; succ = ProviderProductDBHelper.UpdateProviderProduct(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 InsertProviderProduct(ProviderProductModel model, out string ID) { ArrayList listADD = new ArrayList(); bool result = false; ID = "0"; #region 采购供应商联系人添加SQL语句 StringBuilder sqlArrive = new StringBuilder(); sqlArrive.AppendLine("INSERT INTO officedba.ProviderProduct"); sqlArrive.AppendLine("(CompanyCD,CustNo,ProductID,Grade,Remark,JoinDate,Joiner)"); sqlArrive.AppendLine("VALUES (@CompanyCD,@CustNo,@ProductID,@Grade,@Remark,@JoinDate,@Joiner)"); sqlArrive.AppendLine("set @ID=@@IDENTITY"); SqlCommand comm = new SqlCommand(); comm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD)); comm.Parameters.Add(SqlHelper.GetParameter("@CustNo", model.CustNo)); comm.Parameters.Add(SqlHelper.GetParameter("@ProductID", model.ProductID)); comm.Parameters.Add(SqlHelper.GetParameter("@Grade", model.Grade)); comm.Parameters.Add(SqlHelper.GetParameter("@Remark", model.Remark)); comm.Parameters.Add(SqlHelper.GetParameter("@JoinDate", model.JoinDate == null ? SqlDateTime.Null :SqlDateTime.Parse(model.JoinDate.ToString()))); comm.Parameters.Add(SqlHelper.GetParameter("@Joiner", model.Joiner)); 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 { return false; } }
public static bool UpdateProviderProduct(ProviderProductModel model) { if (model.ID <= 0) { return false; } ArrayList listADD = new ArrayList(); bool result = false; #region 修改供应商联系人 StringBuilder sqlArrive = new StringBuilder(); sqlArrive.AppendLine("Update Officedba.ProviderProduct set CompanyCD=@CompanyCD,"); sqlArrive.AppendLine("CustNo=@CustNo,ProductID=@ProductID,Grade=@Grade,Remark=@Remark,"); sqlArrive.AppendLine("JoinDate=@JoinDate,Joiner=@Joiner where CompanyCD=@CompanyCD and ID=@ID"); SqlCommand comm = new SqlCommand(); comm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD)); comm.Parameters.Add(SqlHelper.GetParameter("@CustNo", model.CustNo)); comm.Parameters.Add(SqlHelper.GetParameter("@ProductID", model.ProductID)); comm.Parameters.Add(SqlHelper.GetParameter("@Grade", model.Grade)); comm.Parameters.Add(SqlHelper.GetParameter("@Remark", model.Remark)); comm.Parameters.Add(SqlHelper.GetParameter("@JoinDate", model.JoinDate == null ? SqlDateTime.Null : SqlDateTime.Parse(model.JoinDate.ToString()))); comm.Parameters.Add(SqlHelper.GetParameter("@Joiner", model.Joiner)); 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 { return false; } }
public static bool InsertProviderProduct(ProviderProductModel model, out string ID) { try { bool succ = false; succ = ProviderProductDBHelper.InsertProviderProduct(model, out ID); string ProviderProductID = ID; LogInfoModel logModel = InitLogInfo("推荐物品ID:" + ProviderProductID); logModel.Element = ConstUtil.LOG_PROCESS_INSERT; //设置模块ID 模块ID请在ConstUtil中定义,以便维护 logModel.ModuleID = ConstUtil.MODULE_ID_PROVIDERPRODUCT_ADD; 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; } }