/// <summary>
/// 更新数据
/// </summary>
public bool UpdateOrder(EmsModel.OrderInfo EmsModel, List <EmsModel.OrderEquipDetail> list)
{
using (SqlTransaction trans = dbHelper.BeginTransaction())
{
int count = Update(trans, EmsModel);//修改订单状态
for (int i = 0; i < list.Count; i++)
{
list[i].Type = Convert.ToByte(EmsModel.Status);
count += new EmsDAL.OrderEquipDetail().Update(trans, list[i]);
}
if (count < list.Count)
{//如果没有全部修改
//回滚
trans.Rollback();
return(false);
}
else
{
//提交
trans.Commit();
return(true);
}
}
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private EmsModel.OrderInfo GetEmsModel(DbDataReader dr)
{
EmsModel.OrderInfo EmsModel = new EmsModel.OrderInfo();
PrepareEmsModel(EmsModel, dr);
return(EmsModel);
}
public void ToLend(HttpContext context)
{
string callback = context.Request["jsoncallback"];
string strData = context.Request["strData"];
string OrderNo = context.Request["OrderNo"];
string IDCard = context.Request["IDCard"];
string stuCard = context.Request["stuCard"];
EmsModel.OrderInfo mod = new EmsModel.OrderInfo();
mod.OrderNo = "SY" + DateTime.Now.ToString("yy-MM-dd");
mod.IDCard = IDCard;
mod.stuLoanIDCard = stuCard;
mod.ExperimentId = Convert.ToInt32(OrderNo);
mod.Creator = "admin";
mod.CreateTime = DateTime.Now;
mod.Type = 0;
mod.Status = 2;
mod.IsDelete = 0;
mod.LoanName = "admin";
mod.LendTime = DateTime.Now;
bool isok = new EmsBLL.OrderInfo().Lend(strData, OrderNo, mod);
//序列化
System.Web.Script.Serialization.JavaScriptSerializer jss = new System.Web.Script.Serialization.JavaScriptSerializer();
//输出Json
HttpContext.Current.Response.Write(callback +
"({\"result\":" + jss.Serialize(isok) + "})");
HttpContext.Current.Response.End();
}
public void GetDatePageLoan(HttpContext context)
{
string callback = context.Request["jsoncallback"];
//当前页
int startIndex = Convert.ToInt32(context.Request["startIndex"]);
//页容量
int pageSize = Convert.ToInt32(context.Request["pageSize"]);
EmsModel.OrderInfo Mod = new EmsModel.OrderInfo();
//订单状态
if (context.Request["Status"] != null && context.Request["Status"] != "-1")
{
Mod.Status = Convert.ToInt32(context.Request["Status"]);
}
//借用人
if (context.Request["LoanName"] != null)
{
Mod.LoanName = context.Request["LoanName"];
}
//序列化
System.Web.Script.Serialization.JavaScriptSerializer jss = new System.Web.Script.Serialization.JavaScriptSerializer();
EmsModel.JsonModel mod = new EmsBLL.OrderInfo().GetJsonModel(Mod, startIndex, pageSize);
//输出Json
HttpContext.Current.Response.Write(callback +
"({\"result\":" + jss.Serialize(mod) + "})");
HttpContext.Current.Response.End();
}
public bool OtherLend(List <EmsModel.OrderEquipDetail> listModer, string LoanName, string Creator, string orderNo, int orderType, int DetailType)
{
using (SqlTransaction trans = dbHelper.BeginTransaction())
{
int count = 0;
try
{
EmsModel.OrderInfo order = new EmsModel.OrderInfo();
order.OrderNo = "WJ" + DateTime.Now.ToString("yyMMdd");
order.LoanName = LoanName;
order.ExperimentId = 0;
order.Type = Convert.ToByte(orderType);
order.Status = 0;
order.Creator = Creator;
order.CreateTime = DateTime.Now;
order.IsDelete = 0;
EmsDAL.OrderInfo orderDAL = new OrderInfo();
int num = orderDAL.Add(trans, order);
order.Id = num;
count += orderDAL.Update(trans, order);
foreach (var item in listModer)
{
count += new EmsDAL.OrderEquipDetail().Add(trans, item);
}
//count = UpdateStatus(trans, orderType, orderNo);//修改订单状态
}
catch (Exception)
{
//回滚
trans.Rollback();
count = 0;
//写入日志
//throw;
}
if (count < 1)
{//如果没有修改
//回滚
trans.Rollback();
return(false);
}
else
{
//提交
trans.Commit();
return(true);
}
}
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private void GerEmsModelByDR(EmsModel.OrderInfo EmsModel, DbDataReader dr)
{
EmsModel.Id = dr["ID"] as int?;
EmsModel.OrderNo = GetString(dr["OrderNo"]);
EmsModel.LoanName = GetString(dr["LoanName"]);
EmsModel.ExperimentId = GetInt(dr["ExperimentId"]);
EmsModel.Attachment = GetString(dr["Attachment"]);
EmsModel.Type = GetByte(dr["Type"]);
EmsModel.Status = GetInt(dr["Status"]);
EmsModel.Remarks = GetString(dr["Remarks"]);
EmsModel.LendTime = GetDateTime(dr["LendTime"]);
EmsModel.ReturnTime = GetDateTime(dr["ReturnTime"]);
EmsModel.Creator = GetString(dr["Creator"]);
EmsModel.CreateTime = GetDateTime(dr["CreateTime"]);
EmsModel.Editor = GetString(dr["Editor"]);
EmsModel.UpdateTime = GetDateTime(dr["UpdateTime"]);
EmsModel.IsDelete = GetByte(dr["IsDelete"]);
}
/// <summary>
/// 获取订单数据(借还)
/// </summary>
/// <param name="context"></param>
public void GetDate(HttpContext context)
{
string callback = context.Request["jsoncallback"];
int startIndex = Convert.ToInt32(context.Request["startIndex"]);
//状态
int Status = Convert.ToInt32(context.Request["Status"]);
//租借人
string LoanName = context.Request["LoanName"];
EmsModel.OrderInfo Mod = new EmsModel.OrderInfo();
Mod.LoanName = LoanName;
Mod.Status = Status;
;
//序列化
System.Web.Script.Serialization.JavaScriptSerializer jss = new System.Web.Script.Serialization.JavaScriptSerializer();
EmsModel.JsonModel mod = new EmsBLL.OrderInfo().GetJsonModel(Mod, startIndex, 10);
//输出Json
HttpContext.Current.Response.Write(callback +
"({\"result\":" + jss.Serialize(mod) + "})");
HttpContext.Current.Response.End();
}
/// <summary>
/// 订单借出
/// </summary>
/// <param name="listModer"></param>
/// <param name="orderNo"></param>
/// <param name="orderType"></param>
/// <param name="DetailType"></param>
/// <returns></returns>
public bool UpdateOrderLend(List <EmsModel.OrderEquipDetail> listModer, string orderNo, int orderType, int DetailType, EmsModel.OrderInfo mod)
{
using (SqlTransaction trans = dbHelper.BeginTransaction())
{
int count = 0;
try
{
int orderid = Add(trans, mod);
foreach (var item in listModer)
{
item.OrderId = orderid;
count += new EmsDAL.OrderEquipDetail().Add(trans, item);
}
}
catch (Exception)
{
//回滚
trans.Rollback();
count = 0;
//写入日志
//throw;
}
if (count < 0)
{//如果没有修改
//回滚
trans.Rollback();
return(false);
}
else
{
//提交
trans.Commit();
return(true);
}
}
}
