private void Bind() { if (!string.IsNullOrEmpty(orderNum)) { if (bll == null) { bll = new BLL.Order(); } Model.OrderInfo model = bll.GetModel(orderNum, userId); if (model == null) { ltrBank.Text = ""; WebHelper.MessageBox.Messager(this.Page, lbtnPostBack, "非法操作,已终止执行", "操作错误", "error"); return; } ViewState["OrderId"] = model.OrderId; ViewState["TotalPrice"] = model.TotalPrice; string htmlAppend = "<s class=\"icon-succ02\"></s><h3 class=\"ftx-02\">订单提交成功,请您尽快付款!</h3>"; htmlAppend += "<ul class=\"list-h\"><li class=\"fore1\">订单号:" + model.OrderNum + "</li>"; htmlAppend += "<li class=\"fore2\">应付金额:<strong class=\"ftx-01\">" + model.TotalPrice + "元</strong></li>"; htmlAppend += "</ul><p id=\"p_show_info\"> </p><p class=\"reminder\"><strong>立即支付<span class=\"ftx-01\">" + model.TotalPrice + "元</span>,即可完成订单。</strong>"; htmlAppend += "请您在<span class=\"ftx-04\">24小时</span>内完成支付,否则订单会被自动取消。</p></div>"; ltrSucceed.Text = htmlAppend; } }
/// <summary> /// 增加一条数据 /// </summary> public static int Add(Model.OrderInfo model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into OrderInfo("); strSql.Append("orderNo,orderName,proTotal,sendTotal,orderTotal,orderDesc,remark,recieveUser,pid,PName,cid,CName,regionId,ReginName,address,mobile,tel,status,addTime,infoType,addUser)"); strSql.Append(" values ("); strSql.Append("@orderNo,@orderName,@proTotal,@sendTotal,@orderTotal,@orderDesc,@remark,@recieveUser,@pid,@PName,@cid,@CName,@regionId,@ReginName,@address,@mobile,@tel,@status,@addTime,@infoType,@addUser)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@orderNo", SqlDbType.VarChar,50), new SqlParameter("@orderName", SqlDbType.VarChar,100), new SqlParameter("@proTotal", SqlDbType.Money,8), new SqlParameter("@sendTotal", SqlDbType.Money,8), new SqlParameter("@orderTotal", SqlDbType.Money,8), new SqlParameter("@orderDesc", SqlDbType.VarChar,150), new SqlParameter("@remark", SqlDbType.VarChar,150), new SqlParameter("@recieveUser", SqlDbType.VarChar,50), new SqlParameter("@pid", SqlDbType.Int,4), new SqlParameter("@PName", SqlDbType.VarChar,50), new SqlParameter("@cid", SqlDbType.Int,4), new SqlParameter("@CName", SqlDbType.VarChar,50), new SqlParameter("@regionId", SqlDbType.Int,4), new SqlParameter("@ReginName", SqlDbType.VarChar,50), new SqlParameter("@address", SqlDbType.VarChar,150), new SqlParameter("@mobile", SqlDbType.VarChar,20), new SqlParameter("@tel", SqlDbType.VarChar,20), new SqlParameter("@status", SqlDbType.Int,4), new SqlParameter("@addTime", SqlDbType.DateTime), new SqlParameter("@infoType", SqlDbType.Int,4),new SqlParameter("@addUser",SqlDbType.Int,4)}; parameters[0].Value = model.orderNo; parameters[1].Value = model.orderName; parameters[2].Value = model.proTotal; parameters[3].Value = model.sendTotal; parameters[4].Value = model.orderTotal; parameters[5].Value = model.orderDesc; parameters[6].Value = model.remark; parameters[7].Value = model.recieveUser; parameters[8].Value = model.pid; parameters[9].Value = model.PName; parameters[10].Value = model.cid; parameters[11].Value = model.CName; parameters[12].Value = model.regionId; parameters[13].Value = model.ReginName; parameters[14].Value = model.address; parameters[15].Value = model.mobile; parameters[16].Value = model.tel; parameters[17].Value = model.status; parameters[18].Value = model.addTime; parameters[19].Value = model.infoType; parameters[20].Value = model.addUser; object obj = DBHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
private void Bind() { if (string.IsNullOrEmpty(orderNum)) { WebHelper.MessageBox.Messager(this.Page, Page.Controls[0], "非法进入,已终止执行", "操作错误", "error"); return; } if (bll == null) { bll = new BLL.OrderInfo(); } Model.OrderInfo model = bll.GetModel(orderNum, userId); if (model == null) { WebHelper.MessageBox.Messager(this.Page, Page.Controls[0], "非法操作,已终止执行", "操作错误", "error"); return; } string htmlAppend = "<s class=\"icon-succ02\"></s><h3 class=\"ftx-02\">付款成功,我们将尽快处理,请耐心等待!</h3>"; htmlAppend += "<ul class=\"list-h\"><li class=\"fore1\">订单号:" + model.OrderNum + "</li>"; htmlAppend += "<li class=\"fore2\">已付金额:<strong class=\"ftx-01\">" + model.TotalPrice + "元</strong></li>"; htmlAppend += "</ul></div>"; ltrSucceed.Text = htmlAppend; }
/// <summary> /// 获取数据分页列表,并返回所有记录数 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="totalCount"></param> /// <param name="sqlWhere"></param> /// <param name="commandParameters"></param> /// <returns></returns> public IList <Model.OrderInfo> GetList(int pageIndex, int pageSize, out int totalCount, string sqlWhere, params SqlParameter[] commandParameters) { //获取数据集总数 string cmdText = "select count(*) from [OrderInfo] t1 "; if (!string.IsNullOrEmpty(sqlWhere)) { cmdText += "where 1=1 " + sqlWhere; } totalCount = (int)SqlHelper.ExecuteScalar(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, commandParameters); //返回分页数据 int startIndex = (pageIndex - 1) * pageSize + 1; int endIndex = pageIndex * pageSize; cmdText = @"select * from(select row_number() over(order by t1.CreateDate desc) as RowNumber,t1.OrderId,t1.OrderNum,t1.UserId,t1.Receiver,t1.Address,t1.Mobilephone,t1.Telephone,t1.Email,t1.Products,t1.TotalCount,t1.TotalPrice,t1.PayPrice,t1.PayOption,t1.PayStatus,t1.Status,t1.PayDate,t1.LastUpdatedDate from [OrderInfo] t1 "; if (!string.IsNullOrEmpty(sqlWhere)) { cmdText += "where 1=1 " + sqlWhere; } cmdText += ")as objTable where RowNumber between " + startIndex + " and " + endIndex + " "; IList <Model.OrderInfo> list = null; using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, commandParameters)) { if (reader != null && reader.HasRows) { list = new List <Model.OrderInfo>(); while (reader.Read()) { Model.OrderInfo model = new Model.OrderInfo(); model.OrderId = reader.GetGuid(1); model.OrderNum = reader.GetString(2); model.UserId = reader.GetGuid(3); model.Receiver = reader.GetString(4); model.Address = reader.GetString(5); model.Mobilephone = reader.GetString(6); model.Telephone = reader.GetString(7); model.Email = reader.GetString(8); model.Products = reader.GetString(9); model.TotalCount = reader.GetInt32(10); model.TotalPrice = reader.GetDecimal(11); model.PayPrice = reader.GetDecimal(12); model.PayOption = reader.GetString(3); model.PayStatus = reader.GetByte(14); model.Status = reader.GetByte(15); model.PayDate = reader.GetDateTime(16); model.LastUpdatedDate = reader.GetDateTime(17); list.Add(model); } } } return(list); }
/// <summary> /// 修改订单 /// </summary> /// <param name="a"></param> /// <returns></returns> public int UptOrderInfo(Model.OrderInfo a) { try { string sql = $" update orderInfo set CommodityId={a.CommodityId},UserId={a.UserId},SendWay={a.SendWay},OrderState={a.OrderState},Remark='{a.Remark}',CommodityPrice={a.CommodityPrice},DistributionCosts={a.DistributionCosts},OrderPrice={a.OrderPrice},CouponPrice={a.CouponPrice},AmountPaid={a.AmountPaid},StartTime='{a.StartTime}',Taketheir='{a.Taketheir}' where Orderid = {a.Orderid} "; return(DapperHelper.Execute(sql)); } catch (Exception) { throw; } }
/// <summary> /// 获取对应的数据 /// </summary> /// <param name="orderNum"></param> /// <param name="userId"></param> /// <returns></returns> public Model.OrderInfo GetModel(string orderNum, object userId) { Model.OrderInfo model = null; string cmdText = @"select top 1 OrderId,OrderNum,UserId,Receiver,ProviceCity,Address,Mobilephone,Telephone,Email,Products, TotalCount,TotalPrice,PayPrice,PayOption,PayStatus,Status,PayDate,LastUpdatedDate,CreateDate, (case PayStatus when 1 then '已支付' else '未支付' end) as PayStatusName, (case Status when 0 then '未处理' when 1 then '正在出库' when 10 then '已完成' when 11 then '已取消' else '未知' end) as StatusName from [OrderInfo] where OrderNum = @OrderNum and UserId = @UserId order by LastUpdatedDate desc "; SqlParameter[] parms = { new SqlParameter("OrderNum", SqlDbType.VarChar, 30), new SqlParameter("UserId", SqlDbType.UniqueIdentifier) }; parms[0].Value = orderNum; parms[1].Value = Guid.Parse(userId.ToString()); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms)) { if (reader != null) { while (reader.Read()) { model = new Model.OrderInfo(); model.OrderId = reader.GetGuid(0); model.OrderNum = reader.GetString(1); model.UserId = reader.GetGuid(2); model.Receiver = reader.GetString(3); model.ProviceCity = reader.GetString(4); model.Address = reader.GetString(5); model.Mobilephone = reader.GetString(6); model.Telephone = reader.GetString(7); model.Email = reader.GetString(8); model.Products = reader.GetString(9); model.TotalCount = reader.GetInt32(10); model.TotalPrice = reader.GetDecimal(11); model.PayPrice = reader.GetDecimal(12); model.PayOption = reader.GetString(13); model.PayStatus = reader.GetByte(14); model.Status = reader.GetByte(15); model.PayDate = reader.GetDateTime(16); model.LastUpdatedDate = reader.GetDateTime(17); model.CreateDate = reader.GetDateTime(18); model.PayStatusName = reader.GetString(19); model.StatusName = reader.GetString(20); } } } return(model); }
/// <summary> /// 获取对应的数据 /// </summary> /// <param name="numberId"></param> /// <returns></returns> public Model.OrderInfo GetModel(object numberId) { if (numberId != null) { if (!(numberId is Guid)) { return(null); } } Model.OrderInfo model = null; string cmdText = @"select top 1 OrderId,OrderNum,UserId,Receiver,ProviceCity,Address,Mobilephone,Telephone,Email,Products,TotalCount, TotalPrice,PayPrice,PayOption,PayStatus,Status,PayDate,LastUpdatedDate,CreateDate from [OrderInfo] where OrderId = @OrderId order by CreateDate desc "; SqlParameter parm = new SqlParameter("@OrderId", SqlDbType.UniqueIdentifier); parm.Value = numberId; using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parm)) { if (reader != null) { while (reader.Read()) { model = new Model.OrderInfo(); model.OrderId = reader.GetGuid(0); model.OrderNum = reader.GetString(1); model.UserId = reader.GetGuid(2); model.Receiver = reader.GetString(3); model.ProviceCity = reader.GetString(4); model.Address = reader.GetString(5); model.Mobilephone = reader.GetString(6); model.Telephone = reader.GetString(7); model.Email = reader.GetString(8); model.Products = reader.GetString(9); model.TotalCount = reader.GetInt32(10); model.TotalPrice = reader.GetDecimal(11); model.PayPrice = reader.GetDecimal(12); model.PayOption = reader.GetString(13); model.PayStatus = reader.GetByte(14); model.Status = reader.GetByte(15); model.PayDate = reader.GetDateTime(16); model.LastUpdatedDate = reader.GetDateTime(17); model.CreateDate = reader.GetDateTime(18); } } } return(model); }
/// <summary> /// 修改数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(Model.OrderInfo model) { if (model == null) { return(-1); } //定义查询命令 string cmdText = @"update [OrderInfo] set Receiver = @Receiver,Address = @Address,Mobilephone = @Mobilephone,Telephone = @Telephone,Email = @Email,Products = @Products,TotalCount = @TotalCount,TotalPrice = @TotalPrice,PayPrice = @PayPrice,PayOption = @PayOption,PayStatus = @PayStatus,Status = @Status,PayDate = @PayDate,LastUpdatedDate = @LastUpdatedDate,ProviceCity = @ProviceCity where OrderId = @OrderId"; //创建查询命令参数集 SqlParameter[] parms = { new SqlParameter("@OrderId", SqlDbType.VarChar, 40), new SqlParameter("@Receiver", SqlDbType.NVarChar, 50), new SqlParameter("@Address", SqlDbType.NVarChar, 256), new SqlParameter("@Mobilephone", SqlDbType.VarChar, 20), new SqlParameter("@Telephone", SqlDbType.VarChar, 20), new SqlParameter("@Email", SqlDbType.NVarChar, 256), new SqlParameter("@Products", SqlDbType.NVarChar, 4000), new SqlParameter("@TotalCount", SqlDbType.Int), new SqlParameter("@TotalPrice", SqlDbType.Decimal), new SqlParameter("@PayPrice", SqlDbType.Decimal), new SqlParameter("@PayOption", SqlDbType.NVarChar, 20), new SqlParameter("@PayStatus", SqlDbType.TinyInt), new SqlParameter("@Status", SqlDbType.TinyInt), new SqlParameter("@PayDate", SqlDbType.DateTime), new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime), new SqlParameter("@ProviceCity", SqlDbType.NVarChar, 30) }; parms[0].Value = model.OrderId; parms[1].Value = model.Receiver; parms[2].Value = model.Address; parms[3].Value = model.Mobilephone; parms[4].Value = model.Telephone; parms[5].Value = model.Email; parms[6].Value = model.Products; parms[7].Value = model.TotalCount; parms[8].Value = model.TotalPrice; parms[9].Value = model.PayPrice; parms[10].Value = model.PayOption; parms[11].Value = model.PayStatus; parms[12].Value = model.Status; parms[13].Value = model.PayDate; parms[14].Value = model.LastUpdatedDate; parms[15].Value = model.ProviceCity; return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms)); }
public void Update(Model.OrderInfo order) { //dal.Update(order); using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required)) { dal.Update(order); // Update the inventory to reflect the current inventory after the order submission //Inventory inventory = new Inventory(); //inventory.TakeStock(order.LineItems); // Calling Complete commits the transaction. // Excluding this call by the end of TransactionScope's scope will rollback the transaction ts.Complete(); } }
/// <summary> /// 添加数据到数据库 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(Model.OrderInfo model) { if (model == null) { return(-1); } string cmdText = "insert into [OrderInfo] (OrderNum,UserId,Receiver,Address,Mobilephone,Telephone,Email,Products,TotalCount,TotalPrice,PayOption,LastUpdatedDate,ProviceCity,CreateDate) values (@OrderNum,@UserId,@Receiver,@Address,@Mobilephone,@Telephone,@Email,@Products,@TotalCount,@TotalPrice,@PayOption,@LastUpdatedDate,@ProviceCity,@CreateDate)"; //创建查询命令参数集 SqlParameter[] parms = { new SqlParameter("@OrderNum", SqlDbType.VarChar, 30), new SqlParameter("@UserId", SqlDbType.VarChar, 40), new SqlParameter("@Receiver", SqlDbType.NVarChar, 50), new SqlParameter("@Address", SqlDbType.NVarChar, 256), new SqlParameter("@Mobilephone", SqlDbType.VarChar, 20), new SqlParameter("@Telephone", SqlDbType.VarChar, 20), new SqlParameter("@Email", SqlDbType.NVarChar, 256), new SqlParameter("@Products", SqlDbType.NVarChar, 4000), new SqlParameter("@TotalCount", SqlDbType.Int), new SqlParameter("@TotalPrice", SqlDbType.Decimal), new SqlParameter("@PayOption", SqlDbType.NVarChar, 20), new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime), new SqlParameter("@ProviceCity", SqlDbType.NVarChar, 30), new SqlParameter("@CreateDate", SqlDbType.DateTime) }; parms[0].Value = model.OrderNum; parms[1].Value = model.UserId; parms[2].Value = model.Receiver; parms[3].Value = model.Address; parms[4].Value = model.Mobilephone; parms[5].Value = model.Telephone; parms[6].Value = model.Email; parms[7].Value = model.Products; parms[8].Value = model.TotalCount; parms[9].Value = model.TotalPrice; parms[10].Value = model.PayOption; parms[11].Value = model.LastUpdatedDate; parms[12].Value = model.ProviceCity; parms[13].Value = model.CreateDate; //执行数据库操作 return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms)); }
private void Bind() { if (!string.IsNullOrEmpty(orderNum)) { IList <Model.OrderInfo> list = new List <Model.OrderInfo>(); if (bll == null) { bll = new BLL.OrderInfo(); } Model.OrderInfo model = bll.GetModel(orderNum, Guid.Parse(userId)); if (model != null) { list.Add(model); } rpData.DataSource = list; rpData.DataBind(); GetProductList(model.Products); } }
public static bool Add(Model.OrderInfo entity) { var sql = @" INSERT INTO [OrderInfo] ( ConsumerID ,HuodongID ,Number ,CreateTime ) VALUES ( @ConsumerID ,@HuodongID ,@Number ,GETDATE() )"; var parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter() { ParameterName = "@ConsumerID", Value = entity.ConsumerID }); parameters.Add(new SqlParameter() { ParameterName = "@HuodongID", Value = entity.HuodongID }); parameters.Add(new SqlParameter() { ParameterName = "@Number", Value = entity.Number }); try { return(SqlHelper.ExecuteNonQuery(sql, parameters.ToArray()) > 0); } catch { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public static Model.OrderInfo GetModel(string orderNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from OrderInfo "); strSql.Append(" where orderNo=@orderNo"); SqlParameter[] parameters = { new SqlParameter("@orderNo", SqlDbType.VarChar,154) }; parameters[0].Value = orderNo; Model.OrderInfo model = new Model.OrderInfo(); DataSet ds = DBHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }
/// <summary> /// 添加数据到数据库 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(Model.OrderInfo model) { return(dal.Insert(model)); }
public void Update(Model.OrderInfo order) { throw new System.NotImplementedException(); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.OrderInfo model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update OrderInfo set "); strSql.Append("orderNo=@orderNo,"); strSql.Append("orderName=@orderName,"); strSql.Append("proTotal=@proTotal,"); strSql.Append("sendTotal=@sendTotal,"); strSql.Append("orderTotal=@orderTotal,"); strSql.Append("orderDesc=@orderDesc,"); strSql.Append("remark=@remark,"); strSql.Append("recieveUser=@recieveUser,"); strSql.Append("pid=@pid,"); strSql.Append("PName=@PName,"); strSql.Append("cid=@cid,"); strSql.Append("CName=@CName,"); strSql.Append("regionId=@regionId,"); strSql.Append("ReginName=@ReginName,"); strSql.Append("address=@address,"); strSql.Append("mobile=@mobile,"); strSql.Append("tel=@tel,"); strSql.Append("status=@status,"); strSql.Append("addTime=@addTime,"); strSql.Append("infoType=@infoType"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@orderNo", SqlDbType.VarChar,50), new SqlParameter("@orderName", SqlDbType.VarChar,100), new SqlParameter("@proTotal", SqlDbType.Money,8), new SqlParameter("@sendTotal", SqlDbType.Money,8), new SqlParameter("@orderTotal", SqlDbType.Money,8), new SqlParameter("@orderDesc", SqlDbType.VarChar,150), new SqlParameter("@remark", SqlDbType.VarChar,150), new SqlParameter("@recieveUser", SqlDbType.VarChar,50), new SqlParameter("@pid", SqlDbType.Int,4), new SqlParameter("@PName", SqlDbType.VarChar,50), new SqlParameter("@cid", SqlDbType.Int,4), new SqlParameter("@CName", SqlDbType.VarChar,50), new SqlParameter("@regionId", SqlDbType.Int,4), new SqlParameter("@ReginName", SqlDbType.VarChar,50), new SqlParameter("@address", SqlDbType.VarChar,150), new SqlParameter("@mobile", SqlDbType.VarChar,20), new SqlParameter("@tel", SqlDbType.VarChar,20), new SqlParameter("@status", SqlDbType.Int,4), new SqlParameter("@addTime", SqlDbType.DateTime), new SqlParameter("@infoType", SqlDbType.Int,4), new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = model.orderNo; parameters[1].Value = model.orderName; parameters[2].Value = model.proTotal; parameters[3].Value = model.sendTotal; parameters[4].Value = model.orderTotal; parameters[5].Value = model.orderDesc; parameters[6].Value = model.remark; parameters[7].Value = model.recieveUser; parameters[8].Value = model.pid; parameters[9].Value = model.PName; parameters[10].Value = model.cid; parameters[11].Value = model.CName; parameters[12].Value = model.regionId; parameters[13].Value = model.ReginName; parameters[14].Value = model.address; parameters[15].Value = model.mobile; parameters[16].Value = model.tel; parameters[17].Value = model.status; parameters[18].Value = model.addTime; parameters[19].Value = model.infoType; parameters[20].Value = model.id; int rows=DBHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新订单的二维码 /// </summary> /// <param name="item"></param> /// <returns></returns> public static int UpdateCodeUrl(Model.OrderInfo item) { string sql = "update OrderInfo set pName = '" + item.PName + "' where id = " + item.id; return DBHelperSQL.ExecuteSql(sql); }
public int UptOrderInfo([FromForm] Model.OrderInfo orderInfo) { return(_orderInfoRepository.UptOrderInfo(orderInfo)); }
/// <summary> /// 得到一个对象实体 /// </summary> public static Model.OrderInfo DataRowToModel(DataRow row) { Model.OrderInfo model=new Model.OrderInfo(); if (row != null) { if(row["id"]!=null && row["id"].ToString()!="") { model.id=int.Parse(row["id"].ToString()); } if(row["orderNo"]!=null) { model.orderNo=row["orderNo"].ToString(); } if(row["orderName"]!=null) { model.orderName=row["orderName"].ToString(); } if(row["proTotal"]!=null && row["proTotal"].ToString()!="") { model.proTotal=double.Parse(row["proTotal"].ToString()); } if(row["sendTotal"]!=null && row["sendTotal"].ToString()!="") { model.sendTotal=double.Parse(row["sendTotal"].ToString()); } if(row["orderTotal"]!=null && row["orderTotal"].ToString()!="") { model.orderTotal=double.Parse(row["orderTotal"].ToString()); } if(row["orderDesc"]!=null) { model.orderDesc=row["orderDesc"].ToString(); } if(row["remark"]!=null) { model.remark=row["remark"].ToString(); } if(row["recieveUser"]!=null) { model.recieveUser=row["recieveUser"].ToString(); } if(row["pid"]!=null && row["pid"].ToString()!="") { model.pid=int.Parse(row["pid"].ToString()); } if(row["PName"]!=null) { model.PName=row["PName"].ToString(); } if(row["cid"]!=null && row["cid"].ToString()!="") { model.cid=int.Parse(row["cid"].ToString()); } if(row["CName"]!=null) { model.CName=row["CName"].ToString(); } if(row["regionId"]!=null && row["regionId"].ToString()!="") { model.regionId=int.Parse(row["regionId"].ToString()); } if(row["ReginName"]!=null) { model.ReginName=row["ReginName"].ToString(); } if(row["address"]!=null) { model.address=row["address"].ToString(); } if(row["mobile"]!=null) { model.mobile=row["mobile"].ToString(); } if(row["tel"]!=null) { model.tel=row["tel"].ToString(); } if(row["status"]!=null && row["status"].ToString()!="") { model.status=int.Parse(row["status"].ToString()); } if(row["addTime"]!=null && row["addTime"].ToString()!="") { model.addTime=DateTime.Parse(row["addTime"].ToString()); } if(row["infoType"]!=null && row["infoType"].ToString()!="") { model.infoType=int.Parse(row["infoType"].ToString()); } if (row["addUser"] != null && row["addUser"].ToString() != "") { model.addUser = int.Parse(row["addUser"].ToString()); } } return model; }
public bool Add(Model.OrderInfo t) { throw new NotImplementedException(); }
private void OnCommit() { if (WebHelper.Common.GetUserId() != Guid.Empty) { WebHelper.MessageBox.Messager(this.Page, lbtnSave, "请先登录再执行操作"); return; } string addressId = hNId.Value.Trim(); if (string.IsNullOrEmpty(addressId)) { WebHelper.MessageBox.Messager(this.Page, lbtnSave, "请选择收货人信息", "操作错误", "error"); return; } if (profile == null) { profile = new CustomProfileCommon(); } Model.UserAddress addressModel = profile.UserAddress.GetModel(Guid.Parse(addressId)); if (addressModel == null) { WebHelper.MessageBox.Messager(this.Page, lbtnSave, "不存在当前收货人信息记录,请检查", "操作错误", "error"); return; } string payOption = selectPay.InnerText.Trim(); if (string.IsNullOrEmpty(payOption)) { WebHelper.MessageBox.Messager(this.Page, lbtnSave, "请选择支付及配送方式", "操作错误", "error"); return; } int totalCount = profile.ShoppingCart.Count; decimal totalPrice = profile.ShoppingCart.TotalPrice; if (totalCount < 1) { WebHelper.MessageBox.Messager(this.Page, lbtnSave, "商品清单不存在任何商品,请检查", "操作错误", "error"); return; } string sProducts = ""; ICollection <Model.CartItemInfo> items = profile.ShoppingCart.CartItems; foreach (Model.CartItemInfo item in items) { sProducts += string.Format("{2},{1},{0}|", item.Subtotal, item.Quantity, item.ProductId); } sProducts = sProducts.Trim('|'); DateTime dtime = DateTime.Now; Model.OrderInfo model = new Model.OrderInfo(); model.OrderNum = WebHelper.CustomsHelper.CreateDateTimeString(); model.UserId = WebHelper.Common.GetUserId(); model.Receiver = addressModel.Receiver; model.ProviceCity = addressModel.ProvinceCity; model.Address = addressModel.Address; model.Mobilephone = addressModel.Mobilephone; model.Telephone = addressModel.Telephone; model.Email = addressModel.Email; model.Products = sProducts; model.TotalCount = totalCount; model.TotalPrice = totalPrice; model.PayOption = payOption; model.LastUpdatedDate = dtime; model.CreateDate = dtime; string errorMsg = ""; try { TransactionOptions options = new TransactionOptions(); options.IsolationLevel = IsolationLevel.ReadUncommitted; options.Timeout = TimeSpan.FromSeconds(90); using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { if (bll == null) { bll = new BLL.OrderInfo(); } if (bll.Insert(model) > 0) { profile.ShoppingCart.Clear(); profile.Save(); } //提交事务 scope.Complete(); } Response.Redirect(string.Format("AddOrderSucceed.aspx?oN={0}", HttpUtility.UrlEncode(model.OrderNum)), true); } catch (Exception ex) { errorMsg = ex.Message; } if (!string.IsNullOrEmpty(errorMsg)) { WebHelper.MessageBox.Messager(this.Page, lbtnSave, errorMsg, "系统异常提醒"); return; } }
/// <summary> /// 修改数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(Model.OrderInfo model) { return(dal.Update(model)); }
public static bool Add(Model.OrderInfo entity) { return(DAL.OrderInfoDal.Add(entity)); }