/// <summary>
/// 更新Item零售价格表打包标识方法
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="bat_id">批次标识</param>
/// <param name="strError">错误信息返回</param>
/// <returns></returns>
public bool SetSkuPriceIfFlagInfo(LoggingSessionInfo loggingSessionInfo, string bat_id, out string strError)
{
SkuPriceInfo skuPriceInfo = new SkuPriceInfo();
skuPriceInfo.bat_id = bat_id;
skuPriceInfo.modify_user_id = loggingSessionInfo.CurrentUser.User_Id;
skuPriceInfo.modify_time = GetCurrentDateTime();
cSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).Update("SkuPrice.UpdateUnDownloadIfFlag", skuPriceInfo);
strError = "Success";
return(true);
}
/// <summary>
/// 设置零售价格打包批次号
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="bat_id">批次号</param>
/// <param name="ItemPriceTypeId">价格类型</param>
/// <param name="SkuPriceInfoList">SKU集合</param>
/// <param name="strError">错误信息返回</param>
/// <returns></returns>
public bool SetSkuPriceBatInfo(LoggingSessionInfo loggingSessionInfo, string bat_id, string ItemPriceTypeId, IList <SkuPriceInfo> SkuPriceInfoList, out string strError)
{
SkuPriceInfo skuPriceInfo = new SkuPriceInfo();
skuPriceInfo.modify_user_id = loggingSessionInfo.CurrentUser.User_Id;
skuPriceInfo.modify_time = GetCurrentDateTime();
skuPriceInfo.bat_id = bat_id;
skuPriceInfo.SkuPriceInfoList = SkuPriceInfoList;
skuPriceInfo.item_price_type_id = ItemPriceTypeId;
MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).Update("SkuPrice.UpdateUnDownloadBatId", skuPriceInfo);
strError = "Success";
return(true);
}
/// <summary>
/// 修改sku相关价格信息
/// </summary>
/// <param name="skuPriceInfo"></param>
/// <param name="pTran"></param>
public void UpdateSkuPrice(SkuPriceInfo skuPriceInfo, IDbTransaction pTran)
{
string sql = "update T_Sku_Price "
+ " set sku_price = " + skuPriceInfo.sku_price
+ " ,customer_id = '" + this.CurrentUserInfo.CurrentLoggingManager.Customer_Id + "' "
+ " ,modify_user_id = '" + skuPriceInfo.create_user_id + "' "
+ " ,modify_time = '" + skuPriceInfo.create_time + "' "
+ " ,status = '1' "
+ " ,if_flag = '0' where sku_price_id = '" + skuPriceInfo.sku_price_id + "'";
if (pTran != null)
{
this.SQLHelper.ExecuteNonQuery((SqlTransaction)pTran, CommandType.Text, sql.ToString(), null);
}
else
{
this.SQLHelper.ExecuteNonQuery(sql);
}
}
/// <summary>
/// 插入sku相关价格信息
/// </summary>
/// <param name="skuPriceInfo"></param>
/// <param name="pTran"></param>
public void InsertSkuPrice(SkuPriceInfo skuPriceInfo, IDbTransaction pTran)
{
#region
string sql = "insert into T_Sku_Price "
+ " (sku_price_id "
+ " ,sku_id "
+ " ,item_price_type_id "
+ " ,sku_price "
+ " ,status "
+ " ,create_user_id "
+ " ,create_time "
+ " ,modify_user_id "
+ " ,modify_time "
+ " ,if_flag "
+ " ,customer_id "
+ " ) "
+ " select a.* From ( select '" + skuPriceInfo.sku_price_id + "' sku_price_id"
+ ", '" + skuPriceInfo.sku_id + "' sku_id"
+ ", '" + skuPriceInfo.item_price_type_id + "' item_price_type_id"
+ ", " + skuPriceInfo.sku_price + " sku_price"
+ ", '1' status"
+ ", '" + skuPriceInfo.create_user_id + "' create_user_id"
+ ", '" + skuPriceInfo.create_time + "' create_time"
+ ", '" + skuPriceInfo.modify_user_id + "' modify_user_id"
+ ", '" + skuPriceInfo.modify_time + "' modify_time"
+ ", '0' if_flag"
+ ", '" + this.CurrentUserInfo.CurrentLoggingManager.Customer_Id + "' customer_id"
+ " ) a "
+ " left join T_Sku_Price b on(a.sku_price_id = b.sku_price_id) where b.sku_price_id is null ;";
#endregion
if (pTran != null)
{
this.SQLHelper.ExecuteNonQuery((SqlTransaction)pTran, CommandType.Text, sql.ToString(), null);
}
else
{
this.SQLHelper.ExecuteNonQuery(sql);
}
}
