public List<Model.ReturnBookDetail> GetList(Int32 ReturnBookDetailId, Int32 ReturnBookId, Int32 OrderDetailId, int ReturnDetailStatus, int Start, int Limit)
{
List<Model.ReturnBookDetail> list = new List<Model.ReturnBookDetail>();
try
{
SqlParameter[] p = {
new SqlParameter("@ReturnBookDetailId", SqlDbType.Int, 4),
new SqlParameter("@ReturnBookId", SqlDbType.Int, 4),
new SqlParameter("@OrderDetailId", SqlDbType.Int, 4),
new SqlParameter("@ReturnDetailStatus", SqlDbType.Int, 4),
new SqlParameter("@Start", SqlDbType.Int, 4),
new SqlParameter("@Limit", SqlDbType.Int, 4)
};
p[0].Value = ReturnBookDetailId;
p[1].Value = ReturnBookId;
p[2].Value = OrderDetailId;
p[3].Value = ReturnDetailStatus;
p[4].Value = Start;
p[5].Value = Limit;
DataTable dt = db.ExcuteSelectReturnDataTable("ReturnBookDetail_DS", CommandType.StoredProcedure, p);
if (null != dt && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
Model.ReturnBookDetail model = new Model.ReturnBookDetail();
model.Ind = Convert.ToInt16(dr["Ind"]);
model.ReturnBookDetailId = Convert.ToInt32(dr["ReturnBookDetailId"]);
model.ReturnBookId = Convert.ToInt32(dr["ReturnBookId"]);
model.Title = dr["Title"].ToString();
model.OrderDetailId = Convert.ToInt32(dr["OrderDetailId"]);
model.ReturnDetailStatus = Convert.ToInt16(dr["ReturnDetailStatus"]);
model.CreateTime = dr["CreateTime"].ToString();
model.TotalRow = Convert.ToInt32(dr["TotalRow"]);
list.Add(model);
}
}
}
catch (Exception ex)
{
PTSLog.Error(ex);
}
return list;
}
public int Update(Model.ReturnBook model)
{
int rowEffect = 0;
try
{
string cmdText = "ReturnBook_Update";
SqlParameter[] p = {
new SqlParameter("@ReturnBookId", SqlDbType.Int, 4),
new SqlParameter("@MemberId", SqlDbType.Int, 4),
new SqlParameter("@ReturnDate", SqlDbType.DateTime),
new SqlParameter("@ReturnTime", SqlDbType.NVarChar, 250),
new SqlParameter("@ReturnNote", SqlDbType.NText),
new SqlParameter("@ReturnStatus", SqlDbType.Int, 4),
new SqlParameter("@CreateBy", SqlDbType.NVarChar, 250),
new SqlParameter("@ReturnAddress", SqlDbType.NVarChar, 250),
new SqlParameter("@ReturnPhone", SqlDbType.NVarChar, 250)
};
p[0].Value = model.ReturnBookId;
p[0].Direction = ParameterDirection.InputOutput;
p[1].Value = model.MemberId;
p[2].Value = model.ReturnDate;
p[3].Value = model.ReturnTime;
p[4].Value = model.ReturnNote;
p[5].Value = model.ReturnStatus;
p[6].Value = model.CreateBy;
p[7].Value = model.ReturnAddress;
p[8].Value = model.ReturnPhone;
rowEffect = db.ExcuteCommandReturnInt(cmdText, CommandType.StoredProcedure, p);
if (rowEffect > 0)
{
Int32 ReturnBookId = (Int32)p[0].Value;
if (model.ReturnBookDetailList != null && model.ReturnBookDetailList.Count > 0)
{
BLL.ReturnBookDetail bll = BLL.ReturnBookDetail.Instance;
foreach (var item in model.ReturnBookDetailList)
{
Model.ReturnBookDetail returnmodel = new Model.ReturnBookDetail();
returnmodel.ReturnBookId = ReturnBookId;
returnmodel.OrderDetailId = item.OrderDetailId;
bll.Update(returnmodel);
}
}
}
}
catch (Exception ex)
{
PTSLog.Error(ex);
}
return rowEffect;
}
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);
}
