/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">OrderDetail对象</param>
public int Add(ClassLibrary.Model.OrderDetail model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(string.Format("INSERT INTO {0}(", table));
strSql.Append("orderNumber,UserName,routeID,Number,RouteName,RoutePrice,RouteTime,StartTime,CreatedTime");
strSql.Append(") VALUES (");
strSql.Append("@orderNumber,@UserName,@routeID,@Number,@RouteName,@RoutePrice,@RouteTime,@StartTime,@CreatedTime)");
SqlParameter[] parameters =
{
new SqlParameter("@orderNumber", SqlDbType.VarChar, 32),
new SqlParameter("@UserName", SqlDbType.NVarChar, 100),
new SqlParameter("@routeID", SqlDbType.Int, 4),
new SqlParameter("@Number", SqlDbType.NVarChar, 20),
new SqlParameter("@RouteName", SqlDbType.NVarChar, 200),
new SqlParameter("@RoutePrice", SqlDbType.Decimal, 9),
new SqlParameter("@RouteTime", SqlDbType.NVarChar, 40),
new SqlParameter("@StartTime", SqlDbType.NVarChar, 60),
new SqlParameter("@CreatedTime", SqlDbType.DateTime, 8)
};
parameters[0].Value = model.orderNumber;
parameters[1].Value = model.UserName;
parameters[2].Value = model.routeID;
parameters[3].Value = model.Number;
parameters[4].Value = model.RouteName;
parameters[5].Value = model.RoutePrice;
parameters[6].Value = model.RouteTime;
parameters[7].Value = model.StartTime;
parameters[8].Value = model.CreatedTime;
return(SQLHelper.Execute(strSql.ToString(), parameters));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="ID">主键ID</param>
/// <returns>OrderDetail对象</returns>
public ClassLibrary.Model.OrderDetail GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT ID,orderNumber,UserName,routeID,Number,RouteName,RoutePrice,RouteTime,StartTime,CreatedTime");
strSql.Append(" FROM ");
strSql.Append(table);
strSql.Append(string.Format(" WHERE {0}=@{0}", pk));
SqlParameter[] parameters =
{
new SqlParameter("@" + pk, SqlDbType.Int, 4)
};
parameters[0].Value = ID;
ClassLibrary.Model.OrderDetail model = new ClassLibrary.Model.OrderDetail();
DataTable dt = SQLHelper.Query(strSql.ToString(), parameters);
model.ID = ID;
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["orderNumber"] != DBNull.Value)
{
model.orderNumber = Convert.ToString(dt.Rows[0]["orderNumber"]);
}
if (dt.Rows[0]["UserName"] != DBNull.Value)
{
model.UserName = Convert.ToString(dt.Rows[0]["UserName"]);
}
if (dt.Rows[0]["routeID"] != DBNull.Value)
{
model.routeID = Convert.ToInt32(dt.Rows[0]["routeID"]);
}
if (dt.Rows[0]["Number"] != DBNull.Value)
{
model.Number = Convert.ToString(dt.Rows[0]["Number"]);
}
if (dt.Rows[0]["RouteName"] != DBNull.Value)
{
model.RouteName = Convert.ToString(dt.Rows[0]["RouteName"]);
}
if (dt.Rows[0]["RoutePrice"] != DBNull.Value)
{
model.RoutePrice = Convert.ToDecimal(dt.Rows[0]["RoutePrice"]);
}
if (dt.Rows[0]["RouteTime"] != DBNull.Value)
{
model.RouteTime = Convert.ToString(dt.Rows[0]["RouteTime"]);
}
if (dt.Rows[0]["StartTime"] != DBNull.Value)
{
model.StartTime = Convert.ToString(dt.Rows[0]["StartTime"]);
}
if (dt.Rows[0]["CreatedTime"] != DBNull.Value)
{
model.CreatedTime = Convert.ToDateTime(dt.Rows[0]["CreatedTime"]);
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">OrderDetail对象</param>
/// <returns>影响行数</returns>
public int Update(ClassLibrary.Model.OrderDetail model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(string.Format("UPDATE {0} SET ", table));
strSql.Append("orderNumber=@orderNumber,");
strSql.Append("UserName=@UserName,");
strSql.Append("routeID=@routeID,");
strSql.Append("Number=@Number,");
strSql.Append("RouteName=@RouteName,");
strSql.Append("RoutePrice=@RoutePrice,");
strSql.Append("RouteTime=@RouteTime,");
strSql.Append("StartTime=@StartTime,");
strSql.Append("CreatedTime=@CreatedTime");
strSql.Append(" WHERE ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@orderNumber", SqlDbType.VarChar, 32),
new SqlParameter("@UserName", SqlDbType.NVarChar, 100),
new SqlParameter("@routeID", SqlDbType.Int, 4),
new SqlParameter("@Number", SqlDbType.NVarChar, 20),
new SqlParameter("@RouteName", SqlDbType.NVarChar, 200),
new SqlParameter("@RoutePrice", SqlDbType.Decimal, 9),
new SqlParameter("@RouteTime", SqlDbType.NVarChar, 40),
new SqlParameter("@StartTime", SqlDbType.NVarChar, 60),
new SqlParameter("@CreatedTime", SqlDbType.DateTime, 8)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.orderNumber;
parameters[2].Value = model.UserName;
parameters[3].Value = model.routeID;
parameters[4].Value = model.Number;
parameters[5].Value = model.RouteName;
parameters[6].Value = model.RoutePrice;
parameters[7].Value = model.RouteTime;
parameters[8].Value = model.StartTime;
parameters[9].Value = model.CreatedTime;
return(SQLHelper.Execute(strSql.ToString(), parameters));
}
//保存订单
protected void SaveOrder()
{
string orderNumber = DateTime.Now.ToString("yyMMddHHssmmff");
ClassLibrary.BLL.Orders orderBLL = new ClassLibrary.BLL.Orders();
ClassLibrary.BLL.OrderDetail detailBLL = new ClassLibrary.BLL.OrderDetail();
try
{
string[] products = Request.Form["productList"].Split('|');
ClassLibrary.Model.Orders orderModel = new ClassLibrary.Model.Orders();
orderModel.OrderNumber = orderNumber;
orderModel.UserName = "";
orderModel.proQuantity = Request.Form["adultnum"] + "," + Request.Form["childnum"];
orderModel.proTotalPrice = Convert.ToDecimal(Request.Form["totalPrice"]);
orderModel.Linkman = Request.Form["Linkman"];
orderModel.Fax = "";
orderModel.Mobile = Request.Form["Mobile"];
orderModel.Telphone = Request.Form["Mobile"];
orderModel.Email = "";
orderModel.IdentityCard = "";
orderModel.ContractType = Request.Form["ContractType"];
orderModel.Payment = Request.Form["Payment"];
orderModel.Remark = string.Empty;
orderModel.Status = SysConfig.OrderType.未付款待处理.ToString();
orderModel.CreatedTime = DateTime.Now;
if (orderBLL.Add(orderModel) > 0)
{
ClassLibrary.Model.OrderDetail detailModel;
//依次将订单详情信息插入表中
foreach (string pro in products)
{
if (pro == "")
{
continue;
}
detailModel = new ClassLibrary.Model.OrderDetail();
detailModel.orderNumber = orderModel.OrderNumber;
detailModel.UserName = orderModel.UserName;
detailModel.routeID = Convert.ToInt32(pro.Split(',')[0]);
//string tempNum = pro.Split(',')[2];
//detailModel.Number = tempNum.Substring(0, tempNum.IndexOf("大")) + ",";
//tempNum = tempNum.Substring(tempNum.IndexOf("大") + 1);
//detailModel.Number += tempNum.Substring(0, tempNum.IndexOf("小"));
detailModel.Number = Request.Form["adultnum"] + "," + Request.Form["childnum"];
detailModel.RouteName = pro.Split(',')[1];
detailModel.RoutePrice = Convert.ToDecimal(Request.Form["totalPrice"]);
detailModel.RouteTime = pro.Split(',')[4];
detailModel.StartTime = pro.Split(',')[5];
detailBLL.Add(detailModel);
}
//扣钱
if (orderModel.Payment != SysConfig.Payment.支付宝.ToString())
{
Response.Redirect("/success/o" + orderModel.OrderNumber + ".html", false);
//Response.Redirect("/WebApp/appOrder.aspx?order=" + orderModel.OrderNumber, false);
}
else
{
//---use pay
string payURL = string.Format("/onlinepayment/alipay/default.aspx?order_no={0}&total_fee={1}",
orderModel.OrderNumber,
orderModel.proTotalPrice);
Response.Redirect(payURL, false);
//---
}
}
//发送短信
ClassLibrary.BLL.MsgLinks msg = new ClassLibrary.BLL.MsgLinks();
string customMsg = "尊敬的用户：您的订单" + orderNumber + "已提交成功，我们将尽快联系您，或拨打400-017-5761。";
string webRoutName = products[0].Split(',')[1].Replace("【", "").Replace("】", "").Replace("[", "").Replace("]", "")
.Replace("(", "").Replace(")", "").Replace("（", "").Replace("）", "").Replace("...", "");
string webMsg = "您有新订单" + orderNumber.Substring(10) + "！\n姓名：" + orderModel.Linkman + "\n电话：" + orderModel.Mobile + "\n日期：" + products[0].Split(',')[5]
+ "\n线路：" + Function.Clip(webRoutName, 16, false) + "。";
string backMsg = msg.sendMsg(orderModel.Mobile, customMsg);
ClassLibrary.BLL.WebMeta bll = new ClassLibrary.BLL.WebMeta();
ClassLibrary.Model.WebMeta webMeta = bll.GetModelList(string.Empty)[0];
msg.sendMsg(webMeta.Telphone, webMsg);
}
catch (Exception ex)
{
//回滚数据
orderBLL.Deletes("OrderNumber='" + orderNumber + "'");
detailBLL.Deletes("orderNumber='" + orderNumber + "'");
Response.Write("<script>alert('订单提交失败！');location.href='/shopcart/'</script>");
}
}
