/// <summary> /// 由一行数据得到一个实体 /// </summary> private EmsModel.Role GetEmsModel(DbDataReader dr) { EmsModel.Role EmsModel = new EmsModel.Role(); DbDataReaderToModel(EmsModel, dr); return(EmsModel); }
public void AddRole(HttpContext context) { string callback = context.Request["jsoncallback"]; string name = context.Request["name"]; int result; if (new EmsBLL.Role().IsNameExists(name)) { result = -1; } else { string useridcard = context.Request["useridcard"]; EmsModel.Role role = new EmsModel.Role(); role.Name = name; role.Creator = useridcard; role.CreateTime = DateTime.Now; role.IsDelete = 0; result = new EmsBLL.Role().Add(role); } //输出Json HttpContext.Current.Response.Write(callback + "({\"result\":" + result + "})"); HttpContext.Current.Response.End(); }
public void GetData(HttpContext context) { string callback = context.Request["jsoncallback"]; string rolename = context.Request["rolename"]; EmsModel.Role role = new EmsModel.Role(); if (!string.IsNullOrEmpty(rolename)) { role.Name = rolename; } //序列化 System.Web.Script.Serialization.JavaScriptSerializer jss = new System.Web.Script.Serialization.JavaScriptSerializer(); EmsModel.JsonModel mod = new EmsBLL.Role().GetJsonModel(role); //输出Json HttpContext.Current.Response.Write(callback + "({\"result\":" + jss.Serialize(mod) + "})"); HttpContext.Current.Response.End(); }
/// <summary> /// 获取泛型数据列表 /// </summary> public List <EmsModel.Role> GetList(EmsModel.Role role) { StringBuilder sbSql4org; DbParameter[] parms4org; sbSql4org = new StringBuilder(); sbSql4org.Append("SELECT * FROM Role where IsDelete=0 "); if (!string.IsNullOrEmpty(role.Name)) { sbSql4org.Append(" and Name like '%'+@Name+'%'"); } sbSql4org.Append(" order by CreateTime desc"); parms4org = new DbParameter[] { dbHelper.CreateInDbParameter("@Name", DbType.String, role.Name) }; using (DbDataReader dr = dbHelper.ExecuteReader(CommandType.Text, sbSql4org.ToString(), parms4org)) { List <EmsModel.Role> lst = GetList(dr); return(lst); } }