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