/// <summary> /// 增加一条上传数据 /// </summary> /// <param name="upload">上传模型变量</param> public void AddUpload(UploadInfo upload) { SqlParameter[] parameters = { new SqlParameter("@tableID", SqlDbType.Int), new SqlParameter("@classID", SqlDbType.Int), new SqlParameter("@recordID", SqlDbType.Int), new SqlParameter("@uploadName", SqlDbType.NVarChar), new SqlParameter("@otherFile", SqlDbType.NVarChar), new SqlParameter("@size", SqlDbType.Int), new SqlParameter("@fileType", SqlDbType.NVarChar), new SqlParameter("@randomNumber", SqlDbType.NVarChar), new SqlParameter("@date", SqlDbType.DateTime), new SqlParameter("@iP", SqlDbType.NVarChar) }; parameters[0].Value = upload.TableID; parameters[1].Value = upload.ClassID; parameters[2].Value = upload.RecordID; parameters[3].Value = upload.UploadName; parameters[4].Value = upload.OtherFile; parameters[5].Value = upload.Size; parameters[6].Value = upload.FileType; parameters[7].Value = upload.RandomNumber; parameters[8].Value = upload.Date; parameters[9].Value = upload.IP; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "AddUpload", parameters); }
/// <summary> /// 按产品删除规格记录数据 /// </summary> /// <param name="strProductID">产品ID,以,号分隔</param> public void DeleteByProductID(string strProductID) { SqlParameter[] parameters = { new SqlParameter("@strProductID", SqlDbType.NVarChar) }; parameters[0].Value = strProductID; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "DeleteStandardRecordByProductID", parameters); }
/// <summary> /// 上移图片 /// </summary> /// <param name="id">要移动的id</param> public void MoveUpWechatMenu(int id) { SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int) }; parameters[0].Value = id; ShopMssqlHelper.ExecuteNonQuery("MoveUpWechatMenu", parameters); }
/// <summary> /// 下移图片 /// </summary> /// <param name="id">要移动的id</param> public void MoveDownProductPhoto(int id) { SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int) }; parameters[0].Value = id; ShopMssqlHelper.ExecuteNonQuery("MoveDownProductPhoto", parameters); }
/// <summary> /// 删除多条链接数据 /// </summary> /// <param name="strID">链接的主键值,以,号分隔</param> public void DeleteLink(string strID) { SqlParameter[] parameters = { new SqlParameter("@strID", SqlDbType.NVarChar) }; parameters[0].Value = strID; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "DeleteLink", parameters); }
/// <summary> /// 按分类删除商品回复数据 /// </summary> /// <param name="strCommentID">分类ID,以,号分隔</param> public void DeleteProductReplyByCommentID(string strCommentID) { SqlParameter[] parameters = { new SqlParameter("@strCommentID", SqlDbType.NVarChar) }; parameters[0].Value = strCommentID; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "DeleteProductReplyByCommentID", parameters); }
/// <summary> /// 下移分类 /// </summary> /// <param name="id">要移动的id</param> public void MoveDownRegion(int id) { SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int) }; parameters[0].Value = id; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "MoveDownRegion", parameters); }
/// <summary> /// 删除一条菜单数据 /// </summary> /// <param name="id">菜单的主键值</param> public void DeleteMenu(int id) { SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int) }; parameters[0].Value = id; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "DeleteMenu", parameters); }
/// <summary> /// 记录用户打开的邮件 /// </summary> /// <param name="email"></param> public void RecordOpenedEmailRecord(string email, int id) { SqlParameter[] parameters = { new SqlParameter("@email", SqlDbType.NVarChar), new SqlParameter("@id", SqlDbType.Int) }; parameters[0].Value = email; parameters[1].Value = id; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "RecordOpenedEmailRecord", parameters); }
/// <summary> /// 通过下级表改变列表投票选项数量 /// </summary> /// <param name="strID">下级表的主键值,以,号分隔</param> /// <param name="action">改变动作,减:ChangeAction.Minus;加:ChangeActon.Plus</param> public void ChangeVoteItemCountByGeneral(string strID, ChangeAction action) { SqlParameter[] parameters = { new SqlParameter("@strID", SqlDbType.NVarChar), new SqlParameter("@action", SqlDbType.NVarChar) }; parameters[0].Value = strID; parameters[1].Value = action.ToString(); ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "ChangeVoteItemCountByGeneral", parameters); }
/// <summary> /// 删除多条缺货登记数据 /// </summary> /// <param name="strID">缺货登记的主键值,以,号分隔</param> /// <param name="userID">用户ID</param> public void DeleteBookingProduct(string strID, int userID) { SqlParameter[] parameters = { new SqlParameter("@strID", SqlDbType.NVarChar), new SqlParameter("@userID", SqlDbType.Int) }; parameters[0].Value = strID; parameters[1].Value = userID; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "DeleteBookingProduct", parameters); }
/// <summary> /// 改变列表投票数量 /// </summary> /// <param name="id">投票的主键值</param> /// <param name="action">改变动作,减:ChangeAction.Minus;加:ChangeActon.Plus</param> public void ChangeVoteCount(int id, ChangeAction action) { SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@action", SqlDbType.NVarChar) }; parameters[0].Value = id; parameters[1].Value = action.ToString(); ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "ChangeVoteCount", parameters); }
/// <summary> /// 移动数据排序 /// </summary> /// <param name="action">改变动作,向上:ChangeAction.Up;向下:ChangeActon.Down</param> /// <param name="id">当前记录的主键值</param> public void ChangeLinkOrder(ChangeAction action, int id) { SqlParameter[] parameters = { new SqlParameter("@action", SqlDbType.NVarChar), new SqlParameter("@id", SqlDbType.Int) }; parameters[0].Value = action.ToString(); parameters[1].Value = id; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "ChangeLinkOrder", parameters); }
/// <summary> /// 更新一条商品回复数据 /// </summary> /// <param name="productReply">商品回复模型变量</param> public void UpdateProductReply(ProductReplyInfo productReply) { SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@content", SqlDbType.NText) }; parameters[0].Value = productReply.ID; parameters[1].Value = productReply.Content; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "UpdateProductReply", parameters); }
/// <summary> /// 根据ClassID删除上传上传文件 /// </summary> /// <param name="tableID">表ID</param> /// <param name="strClassID">strClassID</param> public void DeleteUploadByClassID(int tableID, string strClassID) { SqlParameter[] parameters = { new SqlParameter("@tableID", SqlDbType.Int), new SqlParameter("@strClassID", SqlDbType.NVarChar) }; parameters[0].Value = tableID; parameters[1].Value = strClassID; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "DeleteUploadByClassID", parameters); }
/// <summary> /// 保存发送完成状态 /// </summary> /// <param name="emailSendRecord">邮件发送模型变量</param> public void SaveEmailSendRecordStatus(EmailSendRecordInfo emailSendRecord) { SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@sendStatus", SqlDbType.Int), new SqlParameter("@sendDate", SqlDbType.DateTime), }; parameters[0].Value = emailSendRecord.ID; parameters[1].Value = emailSendRecord.SendStatus; parameters[2].Value = emailSendRecord.SendDate; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "SaveEmailSendRecordStatus", parameters); }
/// <summary> /// 待收货订单自动收货--所有订单--存储过程 /// </summary> public void CheckOrderRecieveTimeProg() { SqlParameter[] parameters = { new SqlParameter("@type", SqlDbType.VarChar), new SqlParameter("@recieveDays", SqlDbType.Int), new SqlParameter("@clientIP", SqlDbType.VarChar) }; parameters[0].Value = "CheckOrderRecieveTime"; parameters[1].Value = ShopConfig.ReadConfigInfo().OrderRecieveShippingDays; parameters[2].Value = ClientHelper.IP; ShopMssqlHelper.ExecuteNonQuery("usp_Order", parameters); }
/// <summary> /// 增加一条会员价格数据 /// </summary> /// <param name="memberPrice">会员价格模型变量</param> public void AddMemberPrice(MemberPriceInfo memberPrice) { SqlParameter[] parameters = { new SqlParameter("@productID", SqlDbType.Int), new SqlParameter("@gradeID", SqlDbType.Int), new SqlParameter("@price", SqlDbType.Decimal) }; parameters[0].Value = memberPrice.ProductID; parameters[1].Value = memberPrice.GradeID; parameters[2].Value = memberPrice.Price; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "AddMemberPrice", parameters); }
/// <summary> /// 更改产品的规格属性 /// </summary> /// <param name="strID">产品的主键值,以,号分隔</param> /// <param name="standardType">规格值</param> /// <param name="id">当前产品ID</param> public void UpdateProductStandardType(string strID, int standardType, int id) { SqlParameter[] parameters = { new SqlParameter("@strID", SqlDbType.NVarChar), new SqlParameter("@standardType", SqlDbType.Int), new SqlParameter("@id", SqlDbType.Int) }; parameters[0].Value = strID; parameters[1].Value = standardType; parameters[2].Value = id; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "UpdateProductStandardType", parameters); }
/// <summary> /// 更新一条地区数据 /// </summary> /// <param name="region">地区模型变量</param> public void UpdateRegion(RegionInfo region) { SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@fatherID", SqlDbType.Int), new SqlParameter("@orderID", SqlDbType.Int), new SqlParameter("@regionName", SqlDbType.NVarChar) }; parameters[0].Value = region.ID; parameters[1].Value = region.FatherID; parameters[2].Value = region.OrderID; parameters[3].Value = region.RegionName; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "UpdateRegion", parameters); }
/// <summary> /// 更新多条上传数据 /// </summary> /// <param name="tableID">表ID</param> /// <param name="classID">分类ID</param> /// <param name="recordID">记录ID</param> /// <param name="randomNumber">随机数字</param> public void UpdateUpload(int tableID, int classID, int recordID, string randomNumber) { SqlParameter[] parameters = { new SqlParameter("@tableID", SqlDbType.Int), new SqlParameter("@classID", SqlDbType.Int), new SqlParameter("@recordID", SqlDbType.Int), new SqlParameter("@randomNumber", SqlDbType.NVarChar) }; parameters[0].Value = tableID; parameters[1].Value = classID; parameters[2].Value = recordID; parameters[3].Value = randomNumber; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "UpdateUpload", parameters); }
/// <summary> /// 待付款订单失效检查--指定用户订单--存储过程 /// </summary> public void CheckOrderPayTimeProg(int userId) { SqlParameter[] parameters = { new SqlParameter("@type", SqlDbType.VarChar), new SqlParameter("@payTime", SqlDbType.Int), new SqlParameter("@theUserID", SqlDbType.Int), new SqlParameter("@clientIP", SqlDbType.VarChar) }; parameters[0].Value = "CheckOrderPayTime"; parameters[1].Value = ShopConfig.ReadConfigInfo().OrderPayTime; parameters[2].Value = userId; parameters[3].Value = ClientHelper.IP; ShopMssqlHelper.ExecuteNonQuery("usp_Order", parameters); }
/// <summary> /// 更新一条链接数据 /// </summary> /// <param name="link">链接模型变量</param> public void UpdateLink(LinkInfo link) { SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@linkClass", SqlDbType.Int), new SqlParameter("@display", SqlDbType.NVarChar), new SqlParameter("@uRL", SqlDbType.NVarChar), new SqlParameter("@remark", SqlDbType.NVarChar) }; parameters[0].Value = link.ID; parameters[1].Value = link.LinkClass; parameters[2].Value = link.Display; parameters[3].Value = link.URL; parameters[4].Value = link.Remark; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "UpdateLink", parameters); }
/// <summary> /// 更新一条缺货登记数据 /// </summary> /// <param name="bookingProduct">缺货登记模型变量</param> public void UpdateBookingProduct(BookingProductInfo bookingProduct) { SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@isHandler", SqlDbType.Int), new SqlParameter("@handlerDate", SqlDbType.DateTime), new SqlParameter("@handlerAdminID", SqlDbType.Int), new SqlParameter("@handlerAdminName", SqlDbType.NVarChar), new SqlParameter("@handlerNote", SqlDbType.NVarChar) }; parameters[0].Value = bookingProduct.ID; parameters[1].Value = bookingProduct.IsHandler; parameters[2].Value = bookingProduct.HandlerDate; parameters[3].Value = bookingProduct.HandlerAdminID; parameters[4].Value = bookingProduct.HandlerAdminName; parameters[5].Value = bookingProduct.HandlerNote; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "UpdateBookingProduct", parameters); }
/// <summary> /// 更新一条菜单数据 /// </summary> /// <param name="Menu">菜单模型变量</param> public void UpdateMenu(MenuInfo Menu) { SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@fatherID", SqlDbType.Int), new SqlParameter("@orderID", SqlDbType.Int), new SqlParameter("@menuName", SqlDbType.NVarChar), new SqlParameter("@menuImage", SqlDbType.Int), new SqlParameter("@uRL", SqlDbType.NVarChar) }; parameters[0].Value = Menu.ID; parameters[1].Value = Menu.FatherID; parameters[2].Value = Menu.OrderID; parameters[3].Value = Menu.MenuName; parameters[4].Value = Menu.MenuImage; parameters[5].Value = Menu.URL; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "UpdateMenu", parameters); }
/// <summary> /// 批量更新产品数据 /// </summary> /// <param name="productIDList">产品id串</param> /// <param name="product">产品模型变量</param> public void UnionUpdateProduct(string productIDList, ProductInfo product) { SqlParameter[] parameters = { new SqlParameter("@productIDList", SqlDbType.NVarChar), new SqlParameter("@marketPrice", SqlDbType.Decimal), new SqlParameter("@weight", SqlDbType.Int), new SqlParameter("@sendPoint", SqlDbType.Int), new SqlParameter("@totalStorageCount", SqlDbType.Int), new SqlParameter("@lowerCount", SqlDbType.Int), new SqlParameter("@upperCount", SqlDbType.Int) }; parameters[0].Value = productIDList; parameters[1].Value = product.MarketPrice; parameters[2].Value = product.Weight; parameters[3].Value = product.SendPoint; parameters[4].Value = product.TotalStorageCount; parameters[5].Value = product.LowerCount; parameters[6].Value = product.UpperCount; ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "UnionUpdateProduct", parameters); }