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