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