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