/// <summary> /// 由一行数据得到一个实体 /// </summary> private EmsModel.Warehouse GetEmsModel(DbDataReader dr) { EmsModel.Warehouse EmsModel = new EmsModel.Warehouse(); DbDataReaderToModel(EmsModel, dr); return(EmsModel); }
public void AddWarehouse(HttpContext context) { string callback = context.Request["jsoncallback"]; string name = context.Request["name"]; int result; if (new EmsBLL.Warehouse().IsNameExists(name)) { result = -1; } else { string useridcard = context.Request["useridcard"]; string remarks = context.Request["remarks"]; EmsModel.MenuInfo menu = new EmsModel.MenuInfo(); menu.Name = name; menu.Pid = 0; menu.isMeu = false; menu.isShow = 0; EmsModel.Warehouse ware = new EmsModel.Warehouse(); ware.Name = name; ware.Remarks = remarks; ware.Creator = useridcard; ware.CreateTime = DateTime.Now; ware.IsDelete = 0; ware.UseStatus = 0; //HttpPostedFile file = context.Request.Files[0]; //string path = "/EMS.Web/Upload/Warehouse"; //path = HttpContext.Current.Server.MapPath("~" + path); //if (!Directory.Exists(path)) //{ // Directory.CreateDirectory(path); //} //path += "/" + DateTime.Now.ToString("yyyyMMddhhmmss") + "-" + file.FileName; //try //{ // file.SaveAs(path); // ware.PlaneGraph = path; //} //catch (Exception ex) //{ // HttpContext.Current.Response.End(); //} result = new EmsBLL.Warehouse().AddWarehouse(ware, menu); } //输出Json HttpContext.Current.Response.Write(callback + "({\"result\":" + result + "})"); HttpContext.Current.Response.End(); }
///<summary> ///获取泛型数据列表 分页 /// </summary> public List <EmsModel.Warehouse> GetListByPageAndSear(EmsModel.Warehouse EmsMod, int startIndex, int endIndex) { //表名 string TableName = "Warehouse"; //条件 string strWhere = ""; //排序 string orderby = "UseStatus,T.ID desc "; //参数 List <DbParameter> parmsList = new List <DbParameter>(); if (EmsMod.Name != null) { strWhere += " and Name like '%'+@in_Name+'%' "; parmsList.Add(dbHelper.CreateInDbParameter("@in_Name", DbType.String, EmsMod.Name)); } if (EmsMod.Remarks != null) { strWhere += " and Remarks=@in_Remarks "; parmsList.Add(dbHelper.CreateInDbParameter("@in_Remarks", DbType.String, EmsMod.Remarks)); } if (EmsMod.PlaneGraph != null) { strWhere += " and PlaneGraph=@in_PlaneGraph "; parmsList.Add(dbHelper.CreateInDbParameter("@in_PlaneGraph", DbType.String, EmsMod.PlaneGraph)); } if (EmsMod.Creator != null) { strWhere += " and Creator=@in_Creator "; parmsList.Add(dbHelper.CreateInDbParameter("@in_Creator", DbType.String, EmsMod.Creator)); } if (EmsMod.CreateTime != null) { strWhere += " and CreateTime=@in_CreateTime "; parmsList.Add(dbHelper.CreateInDbParameter("@in_CreateTime", DbType.String, EmsMod.CreateTime)); } if (EmsMod.Editor != null) { strWhere += " and Editor=@in_Editor "; parmsList.Add(dbHelper.CreateInDbParameter("@in_Editor", DbType.String, EmsMod.Editor)); } if (EmsMod.UpdateTime != null) { strWhere += " and UpdateTime=@in_UpdateTime "; parmsList.Add(dbHelper.CreateInDbParameter("@in_UpdateTime", DbType.String, EmsMod.UpdateTime)); } if (EmsMod.IsDelete != null) { strWhere += " and IsDelete=@in_IsDelete "; parmsList.Add(dbHelper.CreateInDbParameter("@in_IsDelete", DbType.String, EmsMod.IsDelete)); } DbParameter[] parms = parmsList.ToArray();//将参数集合转换为对应的数组; DataSet ds = GetListByPage(TableName, strWhere, orderby, startIndex, endIndex, parms); List <EmsModel.Warehouse> list = GetList(ds.Tables[0]); return(list); }
public int GetListByPageCountAndSear(EmsModel.Warehouse EmsMod) { string TableName = "Warehouse"; string strWhere = ""; List <DbParameter> parmsList = new List <DbParameter>(); if (EmsMod.Name != null) { strWhere += " and Name like '%'+@in_Name+'%' "; parmsList.Add(dbHelper.CreateInDbParameter("@in_Name", DbType.String, EmsMod.Name)); } if (EmsMod.Remarks != null) { strWhere += " and Remarks=@in_Remarks "; parmsList.Add(dbHelper.CreateInDbParameter("@in_Remarks", DbType.String, EmsMod.Remarks)); } if (EmsMod.PlaneGraph != null) { strWhere += " and PlaneGraph=@in_PlaneGraph "; parmsList.Add(dbHelper.CreateInDbParameter("@in_PlaneGraph", DbType.String, EmsMod.PlaneGraph)); } if (EmsMod.Creator != null) { strWhere += " and Creator=@in_Creator "; parmsList.Add(dbHelper.CreateInDbParameter("@in_Creator", DbType.String, EmsMod.Creator)); } if (EmsMod.CreateTime != null) { strWhere += " and CreateTime=@in_CreateTime "; parmsList.Add(dbHelper.CreateInDbParameter("@in_CreateTime", DbType.String, EmsMod.CreateTime)); } if (EmsMod.Editor != null) { strWhere += " and Editor=@in_Editor "; parmsList.Add(dbHelper.CreateInDbParameter("@in_Editor", DbType.String, EmsMod.Editor)); } if (EmsMod.UpdateTime != null) { strWhere += " and UpdateTime=@in_UpdateTime "; parmsList.Add(dbHelper.CreateInDbParameter("@in_UpdateTime", DbType.String, EmsMod.UpdateTime)); } if (EmsMod.IsDelete != null) { strWhere += " and IsDelete=@in_IsDelete "; parmsList.Add(dbHelper.CreateInDbParameter("@in_IsDelete", DbType.String, EmsMod.IsDelete)); } DbParameter[] parms = parmsList.ToArray();//将参数集合转换为对应的数组; return(GetRecordCount(TableName, strWhere, parms)); }
public void GetData(HttpContext context) { string callback = context.Request["jsoncallback"]; string warehousename = context.Request["warehousename"]; EmsModel.Warehouse ware = new EmsModel.Warehouse(); if (!string.IsNullOrEmpty(warehousename)) { ware.Name = warehousename; } //序列化 System.Web.Script.Serialization.JavaScriptSerializer jss = new System.Web.Script.Serialization.JavaScriptSerializer(); EmsModel.JsonModel mod = new EmsBLL.Warehouse().GetJsonModel(ware); //输出Json HttpContext.Current.Response.Write(callback + "({\"result\":" + jss.Serialize(mod) + "})"); HttpContext.Current.Response.End(); }
/// <summary> /// 获取泛型数据列表 /// </summary> public List <EmsModel.Warehouse> GetList(EmsModel.Warehouse ware) { StringBuilder sbSql4org; DbParameter[] parms4org; sbSql4org = new StringBuilder(); sbSql4org.Append("SELECT * FROM Warehouse where IsDelete=0 "); if (!string.IsNullOrEmpty(ware.Name)) { sbSql4org.Append(" and Name like '%'+@Name+'%'"); } sbSql4org.Append(" order by CreateTime desc"); parms4org = new DbParameter[] { dbHelper.CreateInDbParameter("@Name", DbType.String, ware.Name) }; using (DbDataReader dr = dbHelper.ExecuteReader(CommandType.Text, sbSql4org.ToString(), parms4org)) { List <EmsModel.Warehouse> lst = GetList(dr); return(lst); } }
public void GetDataPage(HttpContext context) { string callback = context.Request["jsoncallback"]; //当前页 int startIndex = Convert.ToInt32(context.Request["startIndex"]); //页容量 int pageSize = Convert.ToInt32(context.Request["pageSize"]); string warehousename = context.Request["warehousename"]; EmsModel.Warehouse ware = new EmsModel.Warehouse(); if (!string.IsNullOrEmpty(warehousename)) { ware.Name = warehousename; } ware.IsDelete = 0; //序列化 System.Web.Script.Serialization.JavaScriptSerializer jss = new System.Web.Script.Serialization.JavaScriptSerializer(); EmsModel.JsonModel mod = new EmsBLL.Warehouse().GetJsonModel(ware, startIndex, pageSize); //输出Json HttpContext.Current.Response.Write(callback + "({\"result\":" + jss.Serialize(mod) + "})"); HttpContext.Current.Response.End(); }