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