public List <MyOrderEntity> list()
{
List <MyOrderEntity> list = new List <MyOrderEntity>();
string sql = "select MyOrder.*,Member.MemberAcc from MyOrder left join Member on Member.MemberId=MyOrder.MemberId";
db.PrepareSql(sql);
DataTable dt = db.ExecQuery();
foreach (DataRow item in dt.Rows)
{
MyOrderEntity entity = new MyOrderEntity();
entity.OrderId = int.Parse(item["OrderId"].ToString());
entity.MemberId = int.Parse(item["MyOrder.MemberId"].ToString());
entity.OrderCode = item["OrderCode"].ToString();
entity.OrderPeople = item["OrderPeople"].ToString();
entity.OrderPhone = item["OrderPhone"].ToString();
entity.OrderAddress = item["OrderAddress"].ToString();
entity.OrderAllMoney = decimal.Parse(item["OrderAllMoney"].ToString());
entity.OrderStatus = int.Parse(item["OrderStatus"].ToString());
entity.OrderTime = item["OrderTime"].ToString();
entity.Member = new MemberEntity();
entity.Member.MemberAcc = item["MemberAcc"].ToString();
list.Add(entity);
}
return(list);
}
public List <MyOrderEntity> list(int merbid, int Pageint, int Pagesize, out int Count)
{
string sqlwhere = "and MemberId=" + merbid;
string sql = "select count(*) from MyOrder left join Member on Member.MemberId=MyOrder.MemberId where 1=1 " + sqlwhere;
db.PrepareSql(sql);
Count = int.Parse(db.ExecScalar().ToString());
List <MyOrderEntity> list = new List <MyOrderEntity>();
sql = @"select *from(
select ROW_NUMBER()over(order by OrderId) rowid,MyOrder.*,Member.MemberAcc from MyOrder left join Member on Member.MemberId=MyOrder.MemberId where 1=1 " + sqlwhere + ") Tamp where rowid between @satr and @end order by OrderStatus";
db.PrepareSql(sql);
db.SetParameter("satr", (Pageint - 1) * Pagesize + 1);
db.SetParameter("end", Pageint * Pagesize);
DataTable dt = db.ExecQuery();
foreach (DataRow item in dt.Rows)
{
MyOrderEntity entity = new MyOrderEntity();
entity.OrderId = int.Parse(item["OrderId"].ToString());
entity.MemberId = int.Parse(item["MemberId"].ToString());
entity.OrderCode = item["OrderCode"].ToString();
entity.OrderPeople = item["OrderPeople"].ToString();
entity.OrderPhone = item["OrderPhone"].ToString();
entity.OrderAddress = item["OrderAddress"].ToString();
entity.OrderAllMoney = decimal.Parse(item["OrderAllMoney"].ToString());
entity.OrderStatus = int.Parse(item["OrderStatus"].ToString());
entity.OrderTime = item["OrderTime"].ToString();
entity.Member = new MemberEntity();
entity.Member.MemberAcc = item["MemberAcc"].ToString();
list.Add(entity);
}
return(list);
}
public MyOrderEntity list(int id)
{
string sql = "select * from MyOrder where OrderId=" + id;
db.PrepareSql(sql);
DataTable dt = db.ExecQuery();
if (dt.Rows.Count == 0)
{
return(null);
}
MyOrderEntity entity = new MyOrderEntity();
entity.OrderId = int.Parse(dt.Rows[0]["OrderId"].ToString());
entity.MemberId = int.Parse(dt.Rows[0]["MemberId"].ToString());
entity.OrderCode = dt.Rows[0]["OrderCode"].ToString();
entity.OrderPeople = dt.Rows[0]["OrderPeople"].ToString();
entity.OrderPhone = dt.Rows[0]["OrderPhone"].ToString();
entity.OrderAddress = dt.Rows[0]["OrderAddress"].ToString();
entity.OrderAllMoney = decimal.Parse(dt.Rows[0]["OrderAllMoney"].ToString());
entity.OrderStatus = int.Parse(dt.Rows[0]["OrderStatus"].ToString());
entity.OrderTime = dt.Rows[0]["OrderTime"].ToString();
return(entity);
}
private void OrderList_Delete()
{
MyOrderBLL orderBLL = new MyOrderBLL();
MyOrderEntity orderEntity = orderBLL.list(int.Parse(Request["OrderId"]));
orderEntity.OrderStatus = 5;
Response.Write(orderBLL.Update(orderEntity));
Response.End();
}
public List <MyOrderEntity> list(string time, MyOrderEntity myentity, int Pageint, int Pagesize, out int Count)
{
string sqlwhere = "";
if (myentity != null)
{
if (time != null && !time.Equals(""))
{
sqlwhere += " and OrderTime between '" + time.Split(',')[0] + "' and '" + time.Split(',')[1] + "'";
}
if (myentity.OrderStatus != null && myentity.OrderStatus != 0)
{
sqlwhere += " and OrderStatus =" + myentity.OrderStatus;
}
if (myentity.OrderCode != null && !myentity.OrderCode.Equals(""))
{
sqlwhere += " and OrderCode =" + myentity.OrderCode;
}
}
string sql = "select count(*) from MyOrder left join Member on Member.MemberId=MyOrder.MemberId where 1=1 " + sqlwhere;
db.PrepareSql(sql);
Count = int.Parse(db.ExecScalar().ToString());
List <MyOrderEntity> list = new List <MyOrderEntity>();
sql = @"select *from(
select ROW_NUMBER()over(order by OrderId) rowid,MyOrder.*,Member.MemberAcc from MyOrder left join Member on Member.MemberId=MyOrder.MemberId where 1=1 " + sqlwhere + ") Tamp where rowid between @satr and @end";
db.PrepareSql(sql);
db.SetParameter("satr", (Pageint - 1) * Pagesize + 1);
db.SetParameter("end", Pageint * Pagesize);
DataTable dt = db.ExecQuery();
foreach (DataRow item in dt.Rows)
{
MyOrderEntity entity = new MyOrderEntity();
entity.OrderId = int.Parse(item["OrderId"].ToString());
entity.MemberId = int.Parse(item["MemberId"].ToString());
entity.OrderCode = item["OrderCode"].ToString();
entity.OrderPeople = item["OrderPeople"].ToString();
entity.OrderPhone = item["OrderPhone"].ToString();
entity.OrderAddress = item["OrderAddress"].ToString();
entity.OrderAllMoney = decimal.Parse(item["OrderAllMoney"].ToString());
entity.OrderStatus = int.Parse(item["OrderStatus"].ToString());
entity.OrderTime = item["OrderTime"].ToString();
entity.Member = new MemberEntity();
entity.Member.MemberAcc = item["MemberAcc"].ToString();
list.Add(entity);
}
return(list);
}
public int Add(MyOrderEntity entity)
{
string sql = @"insert into MyOrder (OrderCode,MemberId,OrderPeople,OrderPhone,OrderAddress,OrderAllMoney,OrderStatus,OrderTime) values(@OrderCode, @MemberId,@OrderPeople,@OrderPhone, @OrderAddress,@OrderAllMoney,@OrderStatus, GETDATE())";
db.PrepareSql(sql);
db.SetParameter("OrderCode", entity.OrderCode);
db.SetParameter("MemberId", entity.MemberId);
db.SetParameter("OrderPeople", entity.OrderPeople);
db.SetParameter("OrderPhone", entity.OrderPhone);
db.SetParameter("OrderAddress", entity.OrderAddress);
db.SetParameter("OrderAllMoney", entity.OrderAllMoney);
db.SetParameter("OrderStatus", entity.OrderStatus);
return(db.ExecNonQuery());
}
public int Update(MyOrderEntity entity)
{
string sql = "Update MyOrder set OrderCode=@OrderCode, MemberId=@MemberId,OrderPeople=@OrderPeople,OrderPhone=@OrderPhone, OrderAddress=@OrderAddress,OrderAllMoney=@OrderAllMoney,OrderStatus=@OrderStatus where OrderId=@OrderId";
db.PrepareSql(sql);
db.SetParameter("OrderCode", entity.OrderCode);
db.SetParameter("MemberId", entity.MemberId);
db.SetParameter("OrderPeople", entity.OrderPeople);
db.SetParameter("OrderPhone", entity.OrderPhone);
db.SetParameter("OrderAddress", entity.OrderAddress);
db.SetParameter("OrderAllMoney", entity.OrderAllMoney);
db.SetParameter("OrderStatus", entity.OrderStatus);
db.SetParameter("OrderId", entity.OrderId);
return(db.ExecNonQuery());
}
private void Order_list()
{
MyOrderBLL orderBLL = new MyOrderBLL();
string date = "";
if (!string.IsNullOrWhiteSpace(Request["startdate"]) || !string.IsNullOrWhiteSpace(Request["enddate"]))
{
date = Request["startdate"] + "," + Request["enddate"];
}
MyOrderEntity orderEntity = new MyOrderEntity();
int count = 0;
orderEntity.OrderStatus = Convert.ToInt32(Request["OrderStatus"]);
List <MyOrderEntity> list = orderBLL.list(date, orderEntity, int.Parse(Request["PageInt"]), int.Parse(Request["Pagesize"]), out count);
Response.Write(count + "||" + MyJson.ToJsJson(list));
Response.End();
}
protected void lbtOrderSubmit_Click(object sender, EventArgs e)
{
MemberEntity member = (MemberEntity)Session["usr"];
BookCartBLL cartBLL = new BookCartBLL();
List <BookCartEntity> list = cartBLL.list(member.MemberId);
MyOrderEntity orderEntity = new MyOrderEntity();
MyOrderBLL orderBLL = new MyOrderBLL();
OrderDetailEntity orderDetailEntity = new OrderDetailEntity();
orderEntity.OrderCode = DateTime.Now.ToString("yyyyMMddhhmmss") + member.MemberId;
orderEntity.MemberId = member.MemberId;
orderEntity.OrderPeople = txtMemberName.Text;
orderEntity.OrderPhone = txtPhone.Text;
orderEntity.OrderAddress = txtAddress.Text;
decimal counpic = 0;
foreach (BookCartEntity item in list)
{
if (item.IsSelect == 1)
{
counpic += (item.BookCount * (item.BookInfo.BookPrice * item.BookInfo.BookDisCount));
}
}
orderEntity.OrderAllMoney = counpic;
orderEntity.OrderStatus = 1;
orderBLL.Add(orderEntity);
orderEntity = orderBLL.list(orderEntity.OrderCode);
OrderDetailBLL orderDetailBLL = new OrderDetailBLL();
foreach (BookCartEntity item in list)
{
if (item.IsSelect == 1)
{
orderDetailEntity.OrderId = orderEntity.OrderId;
orderDetailEntity.BookId = item.BookId;
orderDetailEntity.BookSalePrice = (item.BookInfo.BookPrice * item.BookInfo.BookDisCount);
orderDetailEntity.BookSaleCount = item.BookCount;
orderDetailBLL.Add(orderDetailEntity);
cartBLL.Delete(item.CartId);
}
}
Response.Redirect("~/Member/OrderList.aspx");
}
public HttpResponseMessage AddOrderedItem(int userId, int productId)
{
HttpResponseMessage response = null;
try
{
using (var userCartEntity = new RepositoryDataAccessLayer <MyOrderEntity>())
{
var isProductAlreadyAdded = userCartEntity
.FindBy(a => a.UserId == userId && a.ProductId == productId && !a.IsDeleted).Any();
if (!isProductAlreadyAdded)
{
var userCart = new MyOrderEntity()
{
UserId = userId,
TotalQuantity = 1,
AddedDateTime = DateTime.Now,
IsDeleted = false,
ProductId = productId
};
userCartEntity.Add(userCart);
return(response = Request.CreateResponse(HttpStatusCode.OK,
new Status {
IsSuccess = true, Message = "Item added to cart successfully."
}));
}
}
}
catch (Exception ex)
{
response = Request.CreateResponse(HttpStatusCode.OK,
new Status {
IsSuccess = false, Message = ex.Message
});
}
return(response);
}
public int Update(MyOrderEntity entity)
{
return(dal.Update(entity));
}
public int Add(MyOrderEntity entity)
{
return(dal.Add(entity));
}
public List <MyOrderEntity> list(string time, MyOrderEntity myentity, int Pageint, int Pagesize, out int Count)
{
return(dal.list(time, myentity, Pageint, Pagesize, out Count));
}
