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