public bool UpdateJob(JobInfo model) { DbParameter[] parms = { GenerateInParam("@JobTitle", SqlDbType.NVarChar, 50, model.JobTitle), GenerateInParam("@PubDate", SqlDbType.DateTime, 8, model.PubDate), GenerateInParam("@EndDate", SqlDbType.DateTime, 8, model.EndDate), GenerateInParam("@Number", SqlDbType.Int, 4, model.Number), GenerateInParam("@State", SqlDbType.Int, 4, model.State), GenerateInParam("@Body", SqlDbType.NText, 0, model.Body), GenerateInParam("@City", SqlDbType.NVarChar, 50, model.City), GenerateInParam("@JobID", SqlDbType.Int, 4, model.JobID) }; string commandText = string.Format("update {0}Jobs set JobTitle=@JobTitle,PubDate=@PubDate,EndDate=@EndDate,Number=@Number,State=@State,Body=@Body,City=@City where JobID=@JobID ", RDBSHelper.RDBSTablePre); if (RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms) > 0) { return(true); } else { return(false); } }
public bool UpdateShop(ShopInfo model) { DbParameter[] parms = { GenerateInParam("@ShopName", SqlDbType.NVarChar, 50, model.ShopName), GenerateInParam("@Address", SqlDbType.NVarChar, 200, model.Address), GenerateInParam("@Tel", SqlDbType.NVarChar, 200, model.Tel), GenerateInParam("@Fax", SqlDbType.NVarChar, 200, model.Fax), GenerateInParam("@ShopImg", SqlDbType.NVarChar, 200, model.ShopImg), GenerateInParam("@Position", SqlDbType.NVarChar, 50, model.Position), GenerateInParam("@Body", SqlDbType.NText, 0, model.Body), GenerateInParam("@Area", SqlDbType.NVarChar, 50, model.Area), GenerateInParam("@Type", SqlDbType.NVarChar, 50, model.Type), GenerateInParam("@OrderID", SqlDbType.Int, 4, model.OrderID), GenerateInParam("@Remark", SqlDbType.NVarChar, 200, model.Remark), GenerateInParam("@ShopID", SqlDbType.Int, 4, model.ShopID) }; string commandText = string.Format("update {0}Shops set ShopName=@ShopName,Address=@Address,Tel=@Tel,Fax=@Fax,ShopImg=@ShopImg,Position=@Position,Body=@Body,Area=@Area,Type=@Type,OrderID=@OrderID,Remark=@Remark where ShopID=@ShopID ", RDBSHelper.RDBSTablePre); if (RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms) > 0) { return(true); } else { return(false); } }
/// <summary> /// 运行SQL语句 /// </summary> /// <param name="sql">SQL语句</param> /// <returns></returns> public string RunSql(string sql) { if (!string.IsNullOrWhiteSpace(sql)) { SqlConnection conn = new SqlConnection(RDBSHelper.ConnectionString); conn.Open(); using (SqlTransaction trans = conn.BeginTransaction()) { string[] sqlList = StringHelper.SplitString(sql, "-sqlseparator-"); foreach (string item in sqlList) { if (!string.IsNullOrWhiteSpace(item)) { try { RDBSHelper.ExecuteNonQuery(CommandType.Text, item); trans.Commit(); } catch (Exception ex) { trans.Rollback(); return(ex.Message); } } } } conn.Close(); } return(string.Empty); }
/// <summary> /// 更新店铺 /// </summary> /// <param name="storeInfo">店铺信息</param> public void UpdateStore(StoreInfo storeInfo) { DbParameter[] parms = { GenerateInParam("@state", SqlDbType.TinyInt, 1, storeInfo.State), GenerateInParam("@name", SqlDbType.NChar, 60, storeInfo.Name), GenerateInParam("@regionid", SqlDbType.SmallInt, 2, storeInfo.RegionId), GenerateInParam("@storerid", SqlDbType.SmallInt, 2, storeInfo.StoreRid), GenerateInParam("@storeiid", SqlDbType.SmallInt, 2, storeInfo.StoreIid), GenerateInParam("@logo", SqlDbType.NChar, 100, storeInfo.Logo), GenerateInParam("@createtime", SqlDbType.DateTime, 8, storeInfo.CreateTime), GenerateInParam("@mobile", SqlDbType.Char, 15, storeInfo.Mobile), GenerateInParam("@phone", SqlDbType.Char, 12, storeInfo.Phone), GenerateInParam("@qq", SqlDbType.Char, 11, storeInfo.QQ), GenerateInParam("@ww", SqlDbType.Char, 50, storeInfo.WW), GenerateInParam("@depoint", SqlDbType.Decimal, 4, storeInfo.DePoint), GenerateInParam("@sepoint", SqlDbType.Decimal, 4, storeInfo.SePoint), GenerateInParam("@shpoint", SqlDbType.Decimal, 4, storeInfo.ShPoint), GenerateInParam("@honesties", SqlDbType.Int, 4, storeInfo.Honesties), GenerateInParam("@stateendtime", SqlDbType.DateTime, 8, storeInfo.StateEndTime), GenerateInParam("@theme", SqlDbType.Char, 20, storeInfo.Theme), GenerateInParam("@banner", SqlDbType.NChar, 100, storeInfo.Banner), GenerateInParam("@announcement", SqlDbType.NChar, 200, storeInfo.Announcement), GenerateInParam("@description", SqlDbType.NChar, 300, storeInfo.Description), GenerateInParam("@storeid", SqlDbType.Int, 4, storeInfo.StoreId) }; string commandText = string.Format("UPDATE [{0}stores] SET [state]=@state,[name]=@name,[regionid]=@regionid,[storerid]=@storerid,[storeiid]=@storeiid,[logo]=@logo,[createtime]=@createtime,[mobile]=@mobile,[phone]=@phone,[qq]=@qq,[ww]=@ww,[depoint]=@depoint,[sepoint]=@sepoint,[shpoint]=@shpoint,[honesties]=@honesties,[stateendtime]=@stateendtime,[theme]=@theme,[banner]=@banner,[announcement]=@announcement,[description]=@description WHERE [storeid]=@storeid", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); }
public bool UpdateServiceEval(ServiceEvalInfo model) { DbParameter[] parms = { GenerateInParam("@Name", SqlDbType.NVarChar, 50, model.Name), GenerateInParam("@Contact", SqlDbType.NVarChar, 50, model.Contact), GenerateInParam("@Province", SqlDbType.NVarChar, 50, model.Province), GenerateInParam("@City", SqlDbType.NVarChar, 50, model.City), GenerateInParam("@Courier", SqlDbType.NVarChar, 250, model.Courier), GenerateInParam("@EvalProduct", SqlDbType.Int, 4, model.EvalProduct), GenerateInParam("@EvalLogistics", SqlDbType.Int, 4, model.EvalLogistics), GenerateInParam("@EvalService", SqlDbType.Int, 4, model.EvalService), GenerateInParam("@Body", SqlDbType.NText, 0, model.Body), GenerateInParam("@CreateTime", SqlDbType.DateTime, 8, model.CreateTime), GenerateInParam("@State", SqlDbType.Int, 4, model.State), GenerateInParam("@WeChatName", SqlDbType.NVarChar, 250, model.WeChatName), GenerateInParam("@WeChatOpenId", SqlDbType.NVarChar, 50, model.WeChatOpenId), GenerateInParam("@id", SqlDbType.Int, 4, model.Id) }; string commandText = string.Format("update {0}ServiceEval set Name=@Name,Contact=@Contact,Province=@Province,Courier=@Courier,City=@City,EvalProduct=@EvalProduct,EvalLogistics=@EvalLogistics,EvalService=@EvalService,Body=@Body,CreateTime=@CreateTime,State=@State,WeChatName=@WeChatName,weChatOpenId=@weChatOpenId where id=@id ", RDBSHelper.RDBSTablePre); if (RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms) > 0) { return(true); } else { return(false); } }
public bool UpdateProductFeedbacks(ProductFeedbacksInfo model) { DbParameter[] parms = { GenerateInParam("@CityName", SqlDbType.NVarChar, 50, model.CityName), GenerateInParam("@ProductName", SqlDbType.NVarChar, 50, model.ProductName), GenerateInParam("@ProductModel", SqlDbType.NVarChar, 50, model.ProductModel), GenerateInParam("@CustomerName", SqlDbType.NVarChar, 50, model.CustomerName), GenerateInParam("@Contact", SqlDbType.NVarChar, 50, model.Contact), GenerateInParam("@Address", SqlDbType.NVarChar, 250, model.Address), GenerateInParam("@Body", SqlDbType.NText, 0, model.Body), GenerateInParam("@State", SqlDbType.Int, 4, model.State), GenerateInParam("@CreateTime", SqlDbType.DateTime, 8, model.CreateTime), GenerateInParam("@WeChatName", SqlDbType.NVarChar, 250, model.WeChatName), GenerateInParam("@WeChatOpenId", SqlDbType.NVarChar, 50, model.WeChatOpenId), GenerateInParam("@Imgs", SqlDbType.NVarChar, 1000, model.Imgs), GenerateInParam("@id", SqlDbType.Int, 4, model.Id) }; string commandText = string.Format("update {0}ProductFeedbacks set CityName=@CityName,ProductName=@ProductName,ProductModel=@ProductModel,CustomerName=@CustomerName,Contact=@Contact,Address=@Address,sBody=@Body,CreateTime=@CreateTime,State=@State,WeChatName=@WeChatName,weChatOpenId=@weChatOpenId,Imgs=@Imgs where id=@id ", RDBSHelper.RDBSTablePre); if (RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms) > 0) { return(true); } else { return(false); } }
/// <summary> /// 申请退款 /// </summary> /// <param name="orderRefundInfo">订单退款信息</param> public void ApplyRefund(OrderRefundInfo orderRefundInfo) { DbParameter[] parms = { GenerateInParam("@storeid", SqlDbType.Int, 4, orderRefundInfo.StoreId), GenerateInParam("@storename", SqlDbType.NVarChar, 60, orderRefundInfo.StoreName), GenerateInParam("@oid", SqlDbType.Int, 4, orderRefundInfo.Oid), GenerateInParam("@osn", SqlDbType.VarChar, 30, orderRefundInfo.OSN), GenerateInParam("@uid", SqlDbType.Int, 4, orderRefundInfo.Uid), GenerateInParam("@state", SqlDbType.TinyInt, 1, orderRefundInfo.State), GenerateInParam("@applytime", SqlDbType.DateTime, 8, orderRefundInfo.ApplyTime), GenerateInParam("@paymoney", SqlDbType.Decimal, 8, orderRefundInfo.PayMoney), GenerateInParam("@refundmoney", SqlDbType.Decimal, 8, orderRefundInfo.RefundMoney), GenerateInParam("@refundsn", SqlDbType.VarChar, 30, orderRefundInfo.RefundSN), GenerateInParam("@refundsystemname", SqlDbType.VarChar, 20, orderRefundInfo.RefundSystemName), GenerateInParam("@refundfriendname", SqlDbType.NVarChar, 30, orderRefundInfo.RefundFriendName), GenerateInParam("@refundtime", SqlDbType.DateTime, 8, orderRefundInfo.RefundTime), GenerateInParam("@paysn", SqlDbType.VarChar, 30, orderRefundInfo.PaySN), GenerateInParam("@paysystemname", SqlDbType.VarChar, 20, orderRefundInfo.PaySystemName), GenerateInParam("@payfriendname", SqlDbType.NVarChar, 30, orderRefundInfo.PayFriendName) }; RDBSHelper.ExecuteNonQuery(CommandType.StoredProcedure, string.Format("{0}applyrefund", RDBSHelper.RDBSTablePre), parms); }
/// <summary> /// 清空购物车的商品 /// </summary> /// <param name="sid">sid</param> /// <returns></returns> public int ClearCart(string sid) { DbParameter[] parms = { GenerateInParam("@sid", SqlDbType.Char, 16, sid) }; return(RDBSHelper.ExecuteNonQuery(CommandType.StoredProcedure, string.Format("{0}clearcartbysid", RDBSHelper.RDBSTablePre), parms)); }
/// <summary> /// 更新订单商品的满减促销活动 /// </summary> /// <param name="orderProductList">订单商品列表</param> public void UpdateOrderProductFullCut(List <OrderProductInfo> orderProductList) { StringBuilder sql = new StringBuilder(); foreach (OrderProductInfo orderProductInfo in orderProductList) { sql.AppendFormat("UPDATE [{0}orderproducts] SET [extcode5]={1} WHERE [recordid]={2};", RDBSHelper.RDBSTablePre, orderProductInfo.ExtCode5, orderProductInfo.RecordId); } RDBSHelper.ExecuteNonQuery(CommandType.Text, sql.ToString()); }
/// <summary> /// 更新订单商品的单品促销活动 /// </summary> /// <param name="orderProductList">订单商品列表</param> public void UpdateOrderProductSingle(List <OrderProductInfo> orderProductList) { StringBuilder sql = new StringBuilder(); foreach (OrderProductInfo orderProductInfo in orderProductList) { sql.AppendFormat("UPDATE [{0}orderproducts] SET [discountprice]={1},[paycredits]={2},[coupontypeid]={3},[extcode1]={4} WHERE [recordid]={5};", RDBSHelper.RDBSTablePre, orderProductInfo.DiscountPrice, orderProductInfo.PayCredits, orderProductInfo.CouponTypeId, orderProductInfo.ExtCode1, orderProductInfo.RecordId); } RDBSHelper.ExecuteNonQuery(CommandType.Text, sql.ToString()); }
/// <summary> /// 更新订单商品的买送促销活动 /// </summary> /// <param name="orderProductList">订单商品列表</param> public void UpdateOrderProductBuySend(List <OrderProductInfo> orderProductList) { StringBuilder sql = new StringBuilder(); foreach (OrderProductInfo orderProductInfo in orderProductList) { sql.AppendFormat("UPDATE [{0}orderproducts] SET [realcount]={1},[buycount]={2},[extcode2]={3} WHERE [recordid]={4};", RDBSHelper.RDBSTablePre, orderProductInfo.RealCount, orderProductInfo.BuyCount, orderProductInfo.ExtCode2, orderProductInfo.RecordId); } RDBSHelper.ExecuteNonQuery(CommandType.Text, sql.ToString()); }
public void DeleteUserById(int userID) { DbParameter[] param = { GenerateInParam("@userID", SqlDbType.Int, 4, userID) }; string commandText = String.Format("DELETE FROM [{0}User] WHERE [userID]=@userID;", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, param); }
/// <summary> /// 清空过期购物车 /// </summary> /// <param name="expireTime">过期时间</param> public void ClearExpiredCart(DateTime expireTime) { DbParameter[] parms = { GenerateInParam("@expiretime", SqlDbType.DateTime, 8, expireTime) }; string commandText = string.Format("DELETE FROM [{0}orderproducts] WHERE [oid]=0 AND [addtime]<@expiretime", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); }
/// <summary> /// 更新购物车的用户id /// </summary> /// <param name="uid">用户id</param> /// <param name="sid">用户sid</param> public void UpdateCartUidBySid(int uid, string sid) { DbParameter[] parms = { GenerateInParam("@uid", SqlDbType.Int, 4, uid), GenerateInParam("@sid", SqlDbType.Char, 16, sid) }; RDBSHelper.ExecuteNonQuery(CommandType.StoredProcedure, string.Format("{0}updatecartuidbysid", RDBSHelper.RDBSTablePre), parms); }
/// <summary> /// 删除商品关键词 /// </summary> /// <param name="pid">商品id</param> public void DeleteProductKeyword(int pid) { DbParameter[] parms = { GenerateInParam("@pid", SqlDbType.Int, 4, pid) }; string commandText = string.Format("DELETE FROM [{0}productkeywords] WHERE [pid]=@pid", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); }
/// <summary> /// 更新订单状态 /// </summary> /// <param name="oid">订单id</param> /// <param name="orderState">订单状态</param> public void UpdateOrderState(int oid, OrderState orderState) { DbParameter[] parms = { GenerateInParam("@oid", SqlDbType.Int, 4, oid), GenerateInParam("@orderstate", SqlDbType.TinyInt, 1, (int)orderState) }; RDBSHelper.ExecuteNonQuery(CommandType.StoredProcedure, string.Format("{0}updateorderstate", RDBSHelper.RDBSTablePre), parms); }
/// <summary> /// 删除店铺配送费用 /// </summary> /// <param name="recordId">记录id</param> public void DeleteStoreShipFeeById(int recordId) { DbParameter[] parms = { GenerateInParam("@recordid", SqlDbType.Int, 4, recordId) }; string commandText = string.Format("DELETE FROM [{0}storeshipfees] WHERE [recordid]=@recordId", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); }
/// <summary> /// 删除店铺配送模板 /// </summary> /// <param name="storeSTid">店铺配送模板id</param> public void DeleteStoreShipTemplateById(int storeSTid) { DbParameter[] parms = { GenerateInParam("@storestid", SqlDbType.Int, 4, storeSTid) }; string commandText = string.Format("DELETE FROM [{0}storeshipfees] WHERE [storestid]=@storestid;DELETE FROM [{0}storeshiptemplates] WHERE [storestid]=@storestid", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); }
/// <summary> /// 更新用户密码 /// </summary> /// <param name="userid"></param> /// <param name="password"></param> public void UpdateUserPasswordByUid(int userId, string password) { DbParameter[] parms = { GenerateInParam("@UserID", SqlDbType.Int, 4, userId), GenerateInParam("@password", SqlDbType.Char, 32, password) }; RDBSHelper.ExecuteNonQuery(CommandType.Text, string.Format("update [{0}User] set password = @password where UserID = @UserID", RDBSHelper.RDBSTablePre), parms); }
/// <summary> /// 清空过期的线下支付订单 /// </summary> /// <param name="expireTime">过期时间</param> public void ClearExpiredOfflinePayOrder(DateTime expireTime) { DbParameter[] parms = { GenerateInParam("@expiretime", SqlDbType.DateTime, 8, expireTime) }; string commandText = string.Format("DELETE FROM [{0}orderproducts] WHERE [oid] IN (SELECT [oid] FROM [{0}orders] WHERE [paymode]=2 AND [paysn]='' AND [addtime]<@expiretime);DELETE FROM [{0}orders] WHERE [paymode]=2 AND [paysn]='' AND [addtime]<@expiretime", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); }
/// <summary> /// 删除店铺行业 /// </summary> /// <param name="storeIid">店铺行业id</param> public void DeleteStoreIndustryById(int storeIid) { DbParameter[] param = { GenerateInParam("@storeiid", SqlDbType.SmallInt, 2, storeIid) }; string commandText = String.Format("DELETE FROM [{0}storeindustries] WHERE [storeiid]=@storeiid", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, param); }
/// <summary> /// 更新订单的评价 /// </summary> /// <param name="oid">订单id</param> /// <param name="isReview">是否评价</param> public void UpdateOrderIsReview(int oid, int isReview) { DbParameter[] parms = { GenerateInParam("@oid", SqlDbType.Int, 4, oid), GenerateInParam("@isreview", SqlDbType.TinyInt, 1, isReview) }; RDBSHelper.ExecuteNonQuery(CommandType.StoredProcedure, string.Format("{0}updateorderisreview", RDBSHelper.RDBSTablePre), parms); }
/// <summary> /// 创建店铺行业 /// </summary> public void CreateStoreIndustry(StoreIndustryInfo storeIndustryInfo) { DbParameter[] param = { GenerateInParam("@title", SqlDbType.NChar, 150, storeIndustryInfo.Title), GenerateInParam("@displayorder", SqlDbType.Int, 4, storeIndustryInfo.DisplayOrder) }; string commandText = String.Format("INSERT INTO [{0}storeindustries] ([title],[displayorder]) VALUES(@title,@displayorder)", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, param); }
/// <summary> /// 更新订单折扣 /// </summary> /// <param name="oid">订单id</param> /// <param name="discount">折扣</param> /// <param name="surplusMoney">剩余金额</param> public void UpdateOrderDiscount(int oid, decimal discount, decimal surplusMoney) { DbParameter[] parms = { GenerateInParam("@oid", SqlDbType.Int, 4, oid), GenerateInParam("@discount", SqlDbType.Decimal, 8, discount), GenerateInParam("@surplusmoney", SqlDbType.Decimal, 8, surplusMoney) }; RDBSHelper.ExecuteNonQuery(CommandType.StoredProcedure, string.Format("{0}updateorderdiscount", RDBSHelper.RDBSTablePre), parms); }
/// <summary> /// 更新店铺状态 /// </summary> /// <param name="storeId">店铺id</param> /// <param name="state">状态</param> /// <param name="stateEndTime">状态结束时间</param> public void UpdateStoreState(int storeId, StoreState state, DateTime stateEndTime) { DbParameter[] parms = { GenerateInParam("@state", SqlDbType.TinyInt, 1, (int)state), GenerateInParam("@stateendtime", SqlDbType.DateTime, 8, stateEndTime), GenerateInParam("@storeid", SqlDbType.Int, 4, storeId) }; string commandText = string.Format("UPDATE [{0}stores] SET [state]=@state,[stateendtime]=@stateendtime WHERE [storeid]=@storeid", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); }
/// <summary> /// 更新店铺行业 /// </summary> public void UpdateStoreIndustry(StoreIndustryInfo storeIndustryInfo) { DbParameter[] param = { GenerateInParam("@title", SqlDbType.NChar, 150, storeIndustryInfo.Title), GenerateInParam("@displayorder", SqlDbType.Int, 4, storeIndustryInfo.DisplayOrder), GenerateInParam("@storeiid", SqlDbType.SmallInt, 2, storeIndustryInfo.StoreIid) }; string commandText = String.Format("UPDATE [{0}storeindustries] SET [title]=@title,[displayorder]=@displayorder WHERE [storeiid]=@storeiid", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, param); }
/// <summary> /// 创建商品关键词 /// </summary> /// <param name="productKeywordInfo">商品关键词信息</param> public void CreateProductKeyword(ProductKeywordInfo productKeywordInfo) { DbParameter[] parms = { GenerateInParam("@keyword", SqlDbType.NChar, 40, productKeywordInfo.Keyword), GenerateInParam("@pid", SqlDbType.Int, 4, productKeywordInfo.Pid), GenerateInParam("@relevancy", SqlDbType.Int, 4, productKeywordInfo.Relevancy) }; string commandText = string.Format("INSERT INTO [{0}productkeywords]([keyword],[pid],[relevancy]) VALUES(@keyword,@pid,@relevancy)", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); }
/// <summary> /// 付款 /// </summary> /// <param name="oid">订单id</param> /// <param name="orderState">订单状态</param> /// <param name="paySN">支付单号</param> /// <param name="payTime">支付时间</param> public void PayOrder(int oid, OrderState orderState, string paySN, DateTime payTime) { DbParameter[] parms = { GenerateInParam("@oid", SqlDbType.Int, 4, oid), GenerateInParam("@orderstate", SqlDbType.TinyInt, 1, (int)orderState), GenerateInParam("@paysn", SqlDbType.Char, 30, paySN), GenerateInParam("@paytime", SqlDbType.DateTime, 8, payTime) }; RDBSHelper.ExecuteNonQuery(CommandType.StoredProcedure, string.Format("{0}payorder", RDBSHelper.RDBSTablePre), parms); }
/// <summary> /// 发货 /// </summary> /// <param name="oid">订单id</param> /// <param name="orderState">订单状态</param> /// <param name="shipSN">配送单号</param> /// <param name="shipTime">配送时间</param> public void SendOrderProduct(int oid, OrderState orderState, string shipSN, DateTime shipTime) { DbParameter[] parms = { GenerateInParam("@oid", SqlDbType.Int, 4, oid), GenerateInParam("@orderstate", SqlDbType.TinyInt, 1, (int)orderState), GenerateInParam("@shipsn", SqlDbType.Char, 30, shipSN), GenerateInParam("@shiptime", SqlDbType.DateTime, 8, shipTime) }; RDBSHelper.ExecuteNonQuery(CommandType.StoredProcedure, string.Format("{0}sendorderproduct", RDBSHelper.RDBSTablePre), parms); }
/// <summary> /// 更新店铺积分 /// </summary> /// <param name="storeId">店铺id</param> /// <param name="dePoint">商品描述评分</param> /// <param name="sePoint">商家服务评分</param> /// <param name="shPoint">商家配送评分</param> public void UpdateStorePoint(int storeId, decimal dePoint, decimal sePoint, decimal shPoint) { DbParameter[] parms = { GenerateInParam("@depoint", SqlDbType.Decimal, 4, dePoint), GenerateInParam("@sepoint", SqlDbType.Decimal, 4, sePoint), GenerateInParam("@shpoint", SqlDbType.Decimal, 4, shPoint), GenerateInParam("@storeid", SqlDbType.Int, 4, storeId) }; string commandText = string.Format("UPDATE [{0}stores] SET [depoint]=@depoint,[sepoint]=@sepoint,[shpoint]=@shpoint WHERE [storeid]=@storeid", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); }