private void RptBind() { if (!int.TryParse(Request.Params["Id"] as string, out this.ReturnBookId)) { this.ReturnBookId = -1; } List<Model.ReturnBook> lModel = bll.GetList(this.ReturnBookId, -1, -1, 1, 1); if (lModel.Any()) { model = lModel.FirstOrDefault(); } }
public List<Model.ReturnBook> GetList(Int32 ReturnBookId, Int32 MemberId, Int32 ReturnStatus, int Start, int Limit) { List<Model.ReturnBook> list = new List<Model.ReturnBook>(); try { SqlParameter[] p = { new SqlParameter("@ReturnBookId", SqlDbType.Int, 4), new SqlParameter("@MemberId", SqlDbType.Int, 4), new SqlParameter("@ReturnStatus", SqlDbType.Int, 4), new SqlParameter("@Start", SqlDbType.Int, 4), new SqlParameter("@Limit", SqlDbType.Int, 4) }; p[0].Value = ReturnBookId; p[1].Value = MemberId; p[2].Value = ReturnStatus; p[3].Value = Start; p[4].Value = Limit; DataTable dt = db.ExcuteSelectReturnDataTable("ReturnBook_DS", CommandType.StoredProcedure, p); if (null != dt && dt.Rows.Count > 0) { BLL.ReturnBookDetail bll_returnbookdetail = BLL.ReturnBookDetail.Instance; foreach (DataRow dr in dt.Rows) { Model.ReturnBook model = new Model.ReturnBook(); model.Ind = Convert.ToInt16(dr["Ind"]); model.ReturnBookId = Convert.ToInt32(dr["ReturnBookId"]); model.MemberId = Convert.ToInt32(dr["MemberId"]); model.Email = dr["Email"].ToString(); model.PhoneNumber = dr["PhoneNumber"].ToString(); model.ReturnAddress = dr["ReturnAddress"].ToString(); model.ReturnPhone = dr["ReturnPhone"].ToString(); model.ReturnDate = dr["ReturnDate"].ToString(); model.ReturnNote = dr["ReturnNote"].ToString(); model.ReturnStatus = Convert.ToInt16(dr["ReturnStatus"]); model.ReturnStatusText = dr["ReturnStatusText"].ToString(); model.CreateBy = dr["CreateBy"].ToString(); model.CreateTime = dr["CreateTime"].ToString(); model.ModifyBy = dr["ModifyBy"].ToString(); model.ModifyTime = dr["ModifyTime"].ToString(); model.TotalRow = Convert.ToInt32(dr["TotalRow"]); List<Model.ReturnBookDetail> BookList = bll_returnbookdetail.GetList(-1, ReturnBookId, -1, -1, 1, 1000); model.ReturnBookDetailList = BookList; list.Add(model); } } } catch (Exception ex) { PTSLog.Error(ex); } return list; }
protected void ReturnBook(HttpContext context) { string result = string.Empty; int errCode = 0; try { string Address = context.Request["Address"]; string Phone = context.Request["Phone"]; string Note = context.Request["Note"]; string MemberId = context.Request["MemberId"]; string OrderDetailId = context.Request["OrderDetailId"]; BLL.ReturnBook bll = BLL.ReturnBook.Instance; BLL.ReturnBookDetail bll_detail = BLL.ReturnBookDetail.Instance; Model.ReturnBook model = new Model.ReturnBook(); model.ReturnBookId = 0; model.MemberId = Convert.ToInt32(MemberId); model.ReturnPhone = Phone; model.ReturnAddress = Address; model.ReturnNote = Note; model.ReturnDate = DateTime.Now.ToString(); model.ReturnTime = string.Empty; model.ReturnStatus = 0; model.CreateBy = string.Empty; List<Model.ReturnBookDetail> list = new List<Model.ReturnBookDetail>(); if (!string.IsNullOrEmpty(OrderDetailId)) { string[] arr = OrderDetailId.Split('|'); for (int i = 0; i < arr.Length; i++) { if (!string.IsNullOrEmpty(arr[i])) { Model.ReturnBookDetail model_detail = new Model.ReturnBookDetail(); model_detail.ReturnBookDetailId = 0; model_detail.OrderDetailId = Convert.ToInt32(arr[i]); list.Add(model_detail); } } } model.ReturnBookDetailList = list; int rows = bll.Update(model); result = "Đơn hàng trả sách của bạn đã gởi đến hệ thống thành công, Chúng tôi sẽ liên lạc với bạn sớm nhất có thể !"; } catch (Exception ex) { errCode = 1; result = "Lỗi xảy ra, vui lòng thử lại !"; } Hashtable hashtable = new Hashtable(); hashtable["code"] = errCode; hashtable["msg"] = result; var json = Newtonsoft.Json.JsonConvert.SerializeObject(hashtable); context.Response.Write(json); }