public void AddInventoryPlan(HttpContext context)
{
string callback = context.Request["jsoncallback"];
string name = context.Request["name"];
int result;
if (new EmsBLL.InventoryPlan().IsNameExists(name))
{
result = -1;
}
else
{
string useridcard = context.Request["useridcard"];
EmsModel.InventoryPlan plan = new EmsModel.InventoryPlan();
plan.Name = name;
plan.InventoryNo = context.Request["invno"];
plan.InventoryTime = Convert.ToDateTime(context.Request["invtime"]);
plan.Type = Convert.ToByte(context.Request["type"]);
plan.Creator = useridcard;
plan.CreateTime = DateTime.Now;
plan.Status = 0;
plan.IsGenerate = 0;
plan.IsDelete = 0;
result = new EmsBLL.InventoryPlan().Add(plan);
}
//输出Json
HttpContext.Current.Response.Write(callback + "({\"result\":" + result + "})");
HttpContext.Current.Response.End();
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private EmsModel.InventoryPlan GetEmsModel(DbDataReader dr)
{
EmsModel.InventoryPlan EmsModel = new EmsModel.InventoryPlan();
DbDataReaderToModel(EmsModel, dr);
return(EmsModel);
}
public int GetListByPageCountAndSear(EmsModel.InventoryPlan EmsMod)
{
string TableName = "InventoryPlan";
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.InventoryNo != null)
{
strWhere += " and InventoryNo=@in_InventoryNo "; parmsList.Add(dbHelper.CreateInDbParameter("@in_InventoryNo", DbType.String, EmsMod.InventoryNo));
}
if (EmsMod.InventoryTime != null)
{
strWhere += " and InventoryTime=@in_InventoryTime "; parmsList.Add(dbHelper.CreateInDbParameter("@in_InventoryTime", DbType.String, EmsMod.InventoryTime));
}
if (EmsMod.Type != null)
{
strWhere += " and Type=@in_Type "; parmsList.Add(dbHelper.CreateInDbParameter("@in_Type", DbType.String, EmsMod.Type));
}
if (EmsMod.Status != null)
{
strWhere += " and Status=@in_Status "; parmsList.Add(dbHelper.CreateInDbParameter("@in_Status", DbType.String, EmsMod.Status));
}
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));
}
if (EmsMod.IsGenerate != null)
{
strWhere += " and IsGenerate=@in_IsGenerate "; parmsList.Add(dbHelper.CreateInDbParameter("@in_IsGenerate", DbType.String, EmsMod.IsGenerate));
}
DbParameter[] parms = parmsList.ToArray();//将参数集合转换为对应的数组;
return(GetRecordCount(TableName, strWhere, parms));
}
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 name = context.Request["name"];
EmsModel.InventoryPlan plan = new EmsModel.InventoryPlan();
if (!string.IsNullOrEmpty(name))
{
plan.Name = name;
}
plan.IsDelete = 0;
//序列化
System.Web.Script.Serialization.JavaScriptSerializer jss = new System.Web.Script.Serialization.JavaScriptSerializer();
EmsModel.JsonModel mod = new EmsBLL.InventoryPlan().GetJsonModel(plan, startIndex, pageSize);
//输出Json
HttpContext.Current.Response.Write(callback + "({\"result\":" + jss.Serialize(mod) + "})");
HttpContext.Current.Response.End();
}
///<summary>
///获取泛型数据列表 分页
/// </summary>
public List <EmsModel.InventoryPlan> GetListByPageAndSear(EmsModel.InventoryPlan EmsMod, int startIndex, int endIndex)
{
//表名
string TableName = "InventoryPlan";
//条件
string strWhere = "";
//排序
string orderby = "";
//参数
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.InventoryNo != null)
{
strWhere += " and InventoryNo=@in_InventoryNo "; parmsList.Add(dbHelper.CreateInDbParameter("@in_InventoryNo", DbType.String, EmsMod.InventoryNo));
}
if (EmsMod.InventoryTime != null)
{
strWhere += " and InventoryTime=@in_InventoryTime "; parmsList.Add(dbHelper.CreateInDbParameter("@in_InventoryTime", DbType.String, EmsMod.InventoryTime));
}
if (EmsMod.Type != null)
{
strWhere += " and Type=@in_Type "; parmsList.Add(dbHelper.CreateInDbParameter("@in_Type", DbType.String, EmsMod.Type));
}
if (EmsMod.Status != null)
{
strWhere += " and Status=@in_Status "; parmsList.Add(dbHelper.CreateInDbParameter("@in_Status", DbType.String, EmsMod.Status));
}
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));
}
if (EmsMod.IsGenerate != null)
{
strWhere += " and IsGenerate=@in_IsGenerate "; parmsList.Add(dbHelper.CreateInDbParameter("@in_IsGenerate", DbType.String, EmsMod.IsGenerate));
}
DbParameter[] parms = parmsList.ToArray();//将参数集合转换为对应的数组;
DataSet ds = GetListByPage(TableName, strWhere, orderby, startIndex, endIndex, parms);
List <EmsModel.InventoryPlan> list = GetList(ds.Tables[0]);
return(list);
}
