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