public void UpdateProductRelatePriority(ProductRelatedInfo info)
{
DataCommand dc = DataCommandManager.GetDataCommand("UpdateProductRelatePriority");
dc.SetParameterValue("@Priority", info.Priority);
dc.SetParameterValue("@SysNo", info.SysNo);
dc.ExecuteNonQuery();
}
private void map(ProductRelatedInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.MasterProductSysNo = Util.TrimIntNull(tempdr["MasterProductSysNo"]);
oParam.RelatedProductSysNo = Util.TrimIntNull(tempdr["RelatedProductSysNo"]);
oParam.CreateUserSysNo = Util.TrimIntNull(tempdr["CreateUserSysNo"]);
oParam.CreateTime = Util.TrimDateNull(tempdr["CreateTime"]);
oParam.Status = Util.TrimIntNull(tempdr["Status"]);
}
/// <summary>
/// 创建相关商品信息
/// </summary>
/// <param name="model"></param>
/// <param name="callback"></param>
public void CreateItemRelated(ProductRelatedVM model, EventHandler <RestClientEventArgs <ProductRelatedInfo> > callback)
{
ProductRelatedInfo info = new ProductRelatedInfo();
info.Priority = Convert.ToInt32(model.Priority);
info.ProductSysNo = Convert.ToInt32(model.ProductSysNo);
info.RelatedProductSysNo = Convert.ToInt32(model.RelatedProductSysNo);
info.CompanyCode = CPApplication.Current.CompanyCode;
info.LanguageCode = CPApplication.Current.LanguageCode;
info.IsMutual = model.IsMutual;
restClient.Create(CreateItemRelateUrl, info, callback);
}
public int CreateProductRelate(ProductRelatedInfo info)
{
DataCommand dc = DataCommandManager.GetDataCommand("CreateItemRelated");
dc.SetParameterValue("@CreateUserSysNo", ServiceContext.Current.UserSysNo);
dc.SetParameterValue("@ProductSysNo", info.ProductSysNo);
dc.SetParameterValue("@RelatedProductSysNo", info.RelatedProductSysNo);
dc.SetParameterValue("@IsMutual", info.IsMutual);
dc.SetParameterValue("@CompanyCode", info.CompanyCode);
dc.SetParameterValue("@Priority", info.Priority);
dc.SetParameterValue("@LanguageCode", info.LanguageCode);
dc.ExecuteNonQuery();
int flag = Convert.ToInt32(dc.GetParameterValue("@Flag"));
return(flag);
}
public ProductRelatedInfo Load(int SysNo)
{
string sql = "select * from product_Related where sysno=" + SysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
{
ProductRelatedInfo oInfo = new ProductRelatedInfo();
map(oInfo, ds.Tables[0].Rows[0]);
return(oInfo);
}
else
{
return(null);
}
}
/// <summary>
/// 添加不同规格 Type=2
/// </summary>
internal int ProductRelated_SaveDifferentSpec(ProductRelatedInfo info)
{
/*
* @productid INT ,@childproductid INT ,@name NVARCHAR(64),@creator NVARCHAR(32)
*/
var sql = "ProductRelated_SaveDifferentSpec";
var cmd = dbw.GetStoredProcCommand(sql);
dbw.AddInParameter(cmd, "ProductID", DbType.Int32, info.ProductID);
dbw.AddInParameter(cmd, "ChildProductID", DbType.Int32, info.ChildProductID);
dbw.AddInParameter(cmd, "Name", DbType.String, info.Name);
dbw.AddInParameter(cmd, "Creator", DbType.String, info.Creator);
var result = dbw.ExecuteScalar(cmd);
return(int.Parse(result.ToString()));
}
/// <summary>
/// 创建相关商品
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public virtual ProductRelatedInfo CreateItemRelated(ProductRelatedInfo info)
{
int result = productRelatedDA.CreateProductRelate(info);
if (result == -1)
{
//主商品必须是show(1)状态！（主商品）
throw new BizException(ResouceManager.GetMessageString("IM.Product", "CreateItemRelatedResult1"));
}
else if (result == 1)
{
//相关商品必须是show状态！（从商品）
throw new BizException(ResouceManager.GetMessageString("IM.Product", "CreateItemRelatedResult2"));
}
else if (result == -2)
{
//相关商品所属类别必须是Valid(0)状态！（主商品）
throw new BizException(ResouceManager.GetMessageString("IM.Product", "CreateItemRelatedResult3"));
}
else if (result == 2)
{
//相关商品所属类别必须是Valid状态！（从商品）
throw new BizException(ResouceManager.GetMessageString("IM.Product", "CreateItemRelatedResult4"));
}
else if (result == 3)
{
//相关商品所属类别必须是相关类别！
throw new BizException(ResouceManager.GetMessageString("IM.Product", "CreateItemRelatedResult5"));
}
else if (result == 4)
{
//相关商品已存在！
throw new BizException(ResouceManager.GetMessageString("IM.Product", "CreateItemRelatedResult6"));
}
return(info);
}
/// <summary>
/// Create ProductRelated
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public ProductRelatedInfo CreateProductRelated(ProductRelatedInfo info)
{
return ObjectFactory<ProductRelateProcessor>.Instance.CreateItemRelated(info);
}
public void SetProductRelated(Hashtable paramHash, int CreateUserSysNo)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
DataSet ds = ProductRelatedQuery(paramHash);
if (Util.HasMoreRow(ds) && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
int invalidstatus = (int)AppEnum.BiStatus.InValid;
string Updatesql = "update Product_Related set status=" + invalidstatus + " where MasterProductSysNo =" + dr["MasterProductSysNo"] + "and RelatedProductSysNo=" + dr["RelatedProductSysNo"];
SqlHelper.ExecuteDataSet(Updatesql);
}
}
string sql = @"select Product.sysno from Product
inner join category3 on category3.sysno=Product.c3sysno
inner join category2 on category3.c2sysno = category2.sysno
inner join category1 on category2.c1sysno = category1.sysno
where 1=1 @MasterProductSysNo @Category @C3 @KeyWords @MasterProductList ";
if (paramHash.Contains("MasterProductSysNo"))
{
sql = sql.Replace("@MasterProductSysNo", " and Product.sysno=" + paramHash["MasterProductSysNo"].ToString());
}
else
{
sql = sql.Replace("@MasterProductSysNo", " ");
}
if (paramHash.ContainsKey("Category"))
{
sql = sql.Replace("@Category", " and " + (string)paramHash["Category"]);
}
else
{
sql = sql.Replace("@Category", "");
}
if (paramHash.ContainsKey("C3"))
{
sql = sql.Replace("@C3", " and Product." + (string)paramHash["C3"]);
}
else
{
sql = sql.Replace("@C3", "");
}
if (paramHash.ContainsKey("KeyWords"))
{
string[] Keys = (Util.TrimNull(paramHash["KeyWords"].ToString())).Split(' ');
if (Keys.Length == 1)
{
sql = sql.Replace("@KeyWords", "and (Product.productid like " + Util.ToSqlLikeString(paramHash["KeyWords"].ToString()) + " or Product.productname like " + Util.ToSqlLikeString(paramHash["KeyWords"].ToString()) + ")");
}
else
{
string t = "";
t += " and (Product.productid like " + Util.ToSqlLikeString(paramHash["KeyWords"].ToString()) + " or ( 1=1 ";
for (int i = 0; i < Keys.Length; i++)
{
t += " and Product.productname like " + Util.ToSqlLikeString(Keys[i]);
}
t += "))";
sql = sql.Replace("@KeyWords", t);
}
}
else
{
sql = sql.Replace("@KeyWords", "");
}
if (paramHash.ContainsKey("MasterProductList"))
{
sql = sql.Replace("@MasterProductList", "and product.sysno in (" + paramHash["MasterProductList"].ToString() + ")");
}
else
{
sql = sql.Replace("@MasterProductList", "");
}
sql += "order by createtime desc";
DataSet MasterSysNods = SqlHelper.ExecuteDataSet(sql);
if (!Util.HasMoreRow(MasterSysNods))
{
throw new BizException("没有此条件的主商品记录");
}
foreach (DataRow dr in MasterSysNods.Tables[0].Rows)
{
ProductRelatedInfo oInfo = new ProductRelatedInfo();
oInfo.MasterProductSysNo = Util.TrimIntNull(dr["sysno"]);
oInfo.RelatedProductSysNo = Util.TrimIntNull(paramHash["RelatedProductSysNo"].ToString());
oInfo.CreateTime = DateTime.Now;
oInfo.CreateUserSysNo = CreateUserSysNo;
oInfo.Status = (int)AppEnum.BiStatus.Valid;
Insert(oInfo);
}
scope.Complete();
}
}
private void Insert(ProductRelatedInfo oParam)
{
new ProductRelatedDac().Insert(oParam);
}
public virtual ProductRelatedInfo CreateProductRelated(ProductRelatedInfo info)
{
var entity = ObjectFactory <ProductRelateAppService> .Instance.CreateProductRelated(info);
return(entity);
}
public int Update(ProductRelatedInfo oParam)
{
string sql = @"UPDATE Product_Related SET
MasterProductSysNo=@MasterProductSysNo, RelatedProductSysNo=@RelatedProductSysNo,
CreateUserSysNo=@CreateUserSysNo, CreateTime=@CreateTime,
Status=@Status
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramMasterProductSysNo = new SqlParameter("@MasterProductSysNo", SqlDbType.Int, 4);
SqlParameter paramRelatedProductSysNo = new SqlParameter("@RelatedProductSysNo", SqlDbType.Int, 4);
SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4);
SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
if (oParam.SysNo != AppConst.IntNull)
{
paramSysNo.Value = oParam.SysNo;
}
else
{
paramSysNo.Value = System.DBNull.Value;
}
if (oParam.MasterProductSysNo != AppConst.IntNull)
{
paramMasterProductSysNo.Value = oParam.MasterProductSysNo;
}
else
{
paramMasterProductSysNo.Value = System.DBNull.Value;
}
if (oParam.RelatedProductSysNo != AppConst.IntNull)
{
paramRelatedProductSysNo.Value = oParam.RelatedProductSysNo;
}
else
{
paramRelatedProductSysNo.Value = System.DBNull.Value;
}
if (oParam.CreateUserSysNo != AppConst.IntNull)
{
paramCreateUserSysNo.Value = oParam.CreateUserSysNo;
}
else
{
paramCreateUserSysNo.Value = System.DBNull.Value;
}
if (oParam.CreateTime != AppConst.DateTimeNull)
{
paramCreateTime.Value = oParam.CreateTime;
}
else
{
paramCreateTime.Value = System.DBNull.Value;
}
if (oParam.Status != AppConst.IntNull)
{
paramStatus.Value = oParam.Status;
}
else
{
paramStatus.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramMasterProductSysNo);
cmd.Parameters.Add(paramRelatedProductSysNo);
cmd.Parameters.Add(paramCreateUserSysNo);
cmd.Parameters.Add(paramCreateTime);
cmd.Parameters.Add(paramStatus);
return(SqlHelper.ExecuteNonQuery(cmd));
}
public int Insert(ProductRelatedInfo oParam)
{
string sql = @"INSERT INTO Product_Related
(
MasterProductSysNo, RelatedProductSysNo, CreateUserSysNo, CreateTime,
Status
)
VALUES (
@MasterProductSysNo, @RelatedProductSysNo, @CreateUserSysNo, @CreateTime,
@Status
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramMasterProductSysNo = new SqlParameter("@MasterProductSysNo", SqlDbType.Int, 4);
SqlParameter paramRelatedProductSysNo = new SqlParameter("@RelatedProductSysNo", SqlDbType.Int, 4);
SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4);
SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.MasterProductSysNo != AppConst.IntNull)
{
paramMasterProductSysNo.Value = oParam.MasterProductSysNo;
}
else
{
paramMasterProductSysNo.Value = System.DBNull.Value;
}
if (oParam.RelatedProductSysNo != AppConst.IntNull)
{
paramRelatedProductSysNo.Value = oParam.RelatedProductSysNo;
}
else
{
paramRelatedProductSysNo.Value = System.DBNull.Value;
}
if (oParam.CreateUserSysNo != AppConst.IntNull)
{
paramCreateUserSysNo.Value = oParam.CreateUserSysNo;
}
else
{
paramCreateUserSysNo.Value = System.DBNull.Value;
}
if (oParam.CreateTime != AppConst.DateTimeNull)
{
paramCreateTime.Value = oParam.CreateTime;
}
else
{
paramCreateTime.Value = System.DBNull.Value;
}
if (oParam.Status != AppConst.IntNull)
{
paramStatus.Value = oParam.Status;
}
else
{
paramStatus.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramMasterProductSysNo);
cmd.Parameters.Add(paramRelatedProductSysNo);
cmd.Parameters.Add(paramCreateUserSysNo);
cmd.Parameters.Add(paramCreateTime);
cmd.Parameters.Add(paramStatus);
return(SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo));
}
