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