/// <summary> /// 增加一条数据 /// </summary> public int Add(Lebi_Administrator model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + TableName + " ("); strSql.Append(LB.DataAccess.DB.BaseUtilsInstance.ColName("UserName") + "," + LB.DataAccess.DB.BaseUtilsInstance.ColName("Password") + "," + LB.DataAccess.DB.BaseUtilsInstance.ColName("IP_Last") + "," + LB.DataAccess.DB.BaseUtilsInstance.ColName("IP_This") + "," + LB.DataAccess.DB.BaseUtilsInstance.ColName("Time_Add") + "," + LB.DataAccess.DB.BaseUtilsInstance.ColName("Time_This") + "," + LB.DataAccess.DB.BaseUtilsInstance.ColName("Time_Last") + "," + LB.DataAccess.DB.BaseUtilsInstance.ColName("Count_Login") + "," + LB.DataAccess.DB.BaseUtilsInstance.ColName("Type_id_AdminStatus") + "," + LB.DataAccess.DB.BaseUtilsInstance.ColName("Admin_Group_id") + "," + LB.DataAccess.DB.BaseUtilsInstance.ColName("RealName") + "," + LB.DataAccess.DB.BaseUtilsInstance.ColName("ModilePhone") + "," + LB.DataAccess.DB.BaseUtilsInstance.ColName("Phone") + "," + LB.DataAccess.DB.BaseUtilsInstance.ColName("Email") + "," + LB.DataAccess.DB.BaseUtilsInstance.ColName("Sex") + "," + LB.DataAccess.DB.BaseUtilsInstance.ColName("AdminType") + "," + LB.DataAccess.DB.BaseUtilsInstance.ColName("Site_ids") + "," + LB.DataAccess.DB.BaseUtilsInstance.ColName("Pro_Type_ids") + "," + LB.DataAccess.DB.BaseUtilsInstance.ColName("RandNum") + "," + LB.DataAccess.DB.BaseUtilsInstance.ColName("Avatar") + "," + LB.DataAccess.DB.BaseUtilsInstance.ColName("Project_ids") + ")"); strSql.Append(" values ("); strSql.Append("@UserName,@Password,@IP_Last,@IP_This,@Time_Add,@Time_This,@Time_Last,@Count_Login,@Type_id_AdminStatus,@Admin_Group_id,@RealName,@ModilePhone,@Phone,@Email,@Sex,@AdminType,@Site_ids,@Pro_Type_ids,@RandNum,@Avatar,@Project_ids);select @@identity;"); SqlParameter[] parameters = { new SqlParameter("@UserName", model.UserName), new SqlParameter("@Password", model.Password), new SqlParameter("@IP_Last", model.IP_Last), new SqlParameter("@IP_This", model.IP_This), new SqlParameter("@Time_Add", model.Time_Add), new SqlParameter("@Time_This", model.Time_This), new SqlParameter("@Time_Last", model.Time_Last), new SqlParameter("@Count_Login", model.Count_Login), new SqlParameter("@Type_id_AdminStatus", model.Type_id_AdminStatus), new SqlParameter("@Admin_Group_id", model.Admin_Group_id), new SqlParameter("@RealName", model.RealName), new SqlParameter("@ModilePhone", model.ModilePhone), new SqlParameter("@Phone", model.Phone), new SqlParameter("@Email", model.Email), new SqlParameter("@Sex", model.Sex), new SqlParameter("@AdminType", model.AdminType), new SqlParameter("@Site_ids", model.Site_ids), new SqlParameter("@Pro_Type_ids", model.Pro_Type_ids), new SqlParameter("@RandNum", model.RandNum), new SqlParameter("@Avatar", model.Avatar), new SqlParameter("@Project_ids", model.Project_ids) }; object obj = LB.DataAccess.DB.Instance.TextExecute(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 by where条件 /// </summary> public Lebi_Administrator GetModel(string strWhere, string strFieldShow, int seconds = 0) { if (strWhere.IndexOf("lbsql{") > 0) { SQLPara para = new SQLPara(strWhere, "", ""); return(GetModel(para, seconds)); } string strTableName = TableName; strFieldShow = strFieldShow == "" ? "*" : strFieldShow; string cachekey = ""; string cachestr = ""; if (BaseUtils.BaseUtilsInstance.MemcacheInstance != null && seconds > 0) { cachestr = "select " + strFieldShow + " " + TableName + " where " + strWhere + "|" + seconds; cachekey = LB.Tools.Utils.MD5(cachestr); var obj = LB.DataAccess.DB.Instance.GetMemchche(cachekey); if (obj != null) { return(obj as Lebi_Administrator); } } Lebi_Administrator model = null; using (IDataReader dataReader = LB.DataAccess.DB.Instance.TextExecuteReaderOne(strTableName, strFieldShow, strWhere, null)) { if (dataReader == null) { return(null); } while (dataReader.Read()) { model = ReaderBind(dataReader, strFieldShow); if (cachekey != "") { LB.DataAccess.DB.Instance.SetMemchche(cachekey, model, "Lebi_Administrator", model.id, cachestr, seconds); } return(model); } } return(null); }
/// <summary> /// 得到一个对象实体 by SQLpara /// </summary> public Lebi_Administrator GetModel(SQLPara para, int seconds = 0) { string strTableName = TableName; string strFieldShow = para.ShowField; string strWhere = para.Where; string cachestr = ""; string cachekey = ""; if (BaseUtils.BaseUtilsInstance.MemcacheInstance != null && seconds > 0) { cachestr = "select " + strFieldShow + " " + TableName + " where " + para.Where + "|" + para.ValueString + "|" + seconds; cachekey = LB.Tools.Utils.MD5(cachestr); var obj = LB.DataAccess.DB.Instance.GetMemchche(cachekey); if (obj != null) { return(obj as Lebi_Administrator); } } Lebi_Administrator model = null; using (IDataReader dataReader = LB.DataAccess.DB.Instance.TextExecuteReaderOne(strTableName, strFieldShow, strWhere, para.Para)) { if (dataReader == null) { return(null); } while (dataReader.Read()) { model = ReaderBind(dataReader, strFieldShow); if (cachekey != "") { LB.DataAccess.DB.Instance.SetMemchche(cachekey, model, "Lebi_Administrator", model.id, cachestr, seconds); } return(model); } } return(null); }
/// <summary> /// 更新一条数据 /// </summary> public static void Update(Lebi_Administrator model) { D_Lebi_Administrator.Instance.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public static int Add(Lebi_Administrator model) { return(D_Lebi_Administrator.Instance.Add(model)); }
/// <summary> /// 安全方式绑定表单数据 /// </summary> public static Lebi_Administrator SafeBindForm(Lebi_Administrator model) { return(D_Lebi_Administrator.Instance.SafeBindForm(model)); }
/// <summary> /// 对象实体绑定数据 /// </summary> public Lebi_Administrator ReaderBind(IDataReader dataReader, string strFieldShow) { Lebi_Administrator model = new Lebi_Administrator(); object ojb; List <string> upcols = new List <string>(); string[] arrcols = strFieldShow.ToLower().Split(','); bool isall = false; if (strFieldShow == "*") { isall = true; } else { foreach (string c in arrcols) { upcols.Add(c); } } if (isall || upcols.Contains("id")) { ojb = dataReader["id"]; if (ojb != null && ojb != DBNull.Value) { model.id = Convert.ToInt32(ojb); } } if (isall || upcols.Contains("username")) { ojb = dataReader["UserName"]; if (ojb != null && ojb != DBNull.Value) { model.UserName = dataReader["UserName"].ToString(); } } if (isall || upcols.Contains("password")) { ojb = dataReader["Password"]; if (ojb != null && ojb != DBNull.Value) { model.Password = dataReader["Password"].ToString(); } } if (isall || upcols.Contains("ip_last")) { ojb = dataReader["IP_Last"]; if (ojb != null && ojb != DBNull.Value) { model.IP_Last = dataReader["IP_Last"].ToString(); } } if (isall || upcols.Contains("ip_this")) { ojb = dataReader["IP_This"]; if (ojb != null && ojb != DBNull.Value) { model.IP_This = dataReader["IP_This"].ToString(); } } if (isall || upcols.Contains("time_add")) { ojb = dataReader["Time_Add"]; if (ojb != null && ojb != DBNull.Value) { model.Time_Add = (DateTime)ojb; } } if (isall || upcols.Contains("time_this")) { ojb = dataReader["Time_This"]; if (ojb != null && ojb != DBNull.Value) { model.Time_This = (DateTime)ojb; } } if (isall || upcols.Contains("time_last")) { ojb = dataReader["Time_Last"]; if (ojb != null && ojb != DBNull.Value) { model.Time_Last = (DateTime)ojb; } } if (isall || upcols.Contains("count_login")) { ojb = dataReader["Count_Login"]; if (ojb != null && ojb != DBNull.Value) { model.Count_Login = Convert.ToInt32(ojb); } } if (isall || upcols.Contains("type_id_adminstatus")) { ojb = dataReader["Type_id_AdminStatus"]; if (ojb != null && ojb != DBNull.Value) { model.Type_id_AdminStatus = Convert.ToInt32(ojb); } } if (isall || upcols.Contains("admin_group_id")) { ojb = dataReader["Admin_Group_id"]; if (ojb != null && ojb != DBNull.Value) { model.Admin_Group_id = Convert.ToInt32(ojb); } } if (isall || upcols.Contains("realname")) { ojb = dataReader["RealName"]; if (ojb != null && ojb != DBNull.Value) { model.RealName = dataReader["RealName"].ToString(); } } if (isall || upcols.Contains("modilephone")) { ojb = dataReader["ModilePhone"]; if (ojb != null && ojb != DBNull.Value) { model.ModilePhone = dataReader["ModilePhone"].ToString(); } } if (isall || upcols.Contains("phone")) { ojb = dataReader["Phone"]; if (ojb != null && ojb != DBNull.Value) { model.Phone = dataReader["Phone"].ToString(); } } if (isall || upcols.Contains("email")) { ojb = dataReader["Email"]; if (ojb != null && ojb != DBNull.Value) { model.Email = dataReader["Email"].ToString(); } } if (isall || upcols.Contains("sex")) { ojb = dataReader["Sex"]; if (ojb != null && ojb != DBNull.Value) { model.Sex = dataReader["Sex"].ToString(); } } if (isall || upcols.Contains("admintype")) { ojb = dataReader["AdminType"]; if (ojb != null && ojb != DBNull.Value) { model.AdminType = dataReader["AdminType"].ToString(); } } if (isall || upcols.Contains("site_ids")) { ojb = dataReader["Site_ids"]; if (ojb != null && ojb != DBNull.Value) { model.Site_ids = dataReader["Site_ids"].ToString(); } } if (isall || upcols.Contains("pro_type_ids")) { ojb = dataReader["Pro_Type_ids"]; if (ojb != null && ojb != DBNull.Value) { model.Pro_Type_ids = dataReader["Pro_Type_ids"].ToString(); } } if (isall || upcols.Contains("randnum")) { ojb = dataReader["RandNum"]; if (ojb != null && ojb != DBNull.Value) { model.RandNum = Convert.ToInt32(ojb); } } if (isall || upcols.Contains("avatar")) { ojb = dataReader["Avatar"]; if (ojb != null && ojb != DBNull.Value) { model.Avatar = dataReader["Avatar"].ToString(); } } if (isall || upcols.Contains("project_ids")) { ojb = dataReader["Project_ids"]; if (ojb != null && ojb != DBNull.Value) { model.Project_ids = dataReader["Project_ids"].ToString(); } } return(model); }
/// <summary> /// 安全方式绑定对象表单 /// </summary> public Lebi_Administrator SafeBindForm(Lebi_Administrator model) { if (HttpContext.Current.Request["UserName"] != null) { model.UserName = LB.Tools.RequestTool.RequestSafeString("UserName"); } if (HttpContext.Current.Request["Password"] != null) { model.Password = LB.Tools.RequestTool.RequestSafeString("Password"); } if (HttpContext.Current.Request["IP_Last"] != null) { model.IP_Last = LB.Tools.RequestTool.RequestSafeString("IP_Last"); } if (HttpContext.Current.Request["IP_This"] != null) { model.IP_This = LB.Tools.RequestTool.RequestSafeString("IP_This"); } if (HttpContext.Current.Request["Time_Add"] != null) { model.Time_Add = LB.Tools.RequestTool.RequestTime("Time_Add", System.DateTime.Now); } if (HttpContext.Current.Request["Time_This"] != null) { model.Time_This = LB.Tools.RequestTool.RequestTime("Time_This", System.DateTime.Now); } if (HttpContext.Current.Request["Time_Last"] != null) { model.Time_Last = LB.Tools.RequestTool.RequestTime("Time_Last", System.DateTime.Now); } if (HttpContext.Current.Request["Count_Login"] != null) { model.Count_Login = LB.Tools.RequestTool.RequestInt("Count_Login", 0); } if (HttpContext.Current.Request["Type_id_AdminStatus"] != null) { model.Type_id_AdminStatus = LB.Tools.RequestTool.RequestInt("Type_id_AdminStatus", 0); } if (HttpContext.Current.Request["Admin_Group_id"] != null) { model.Admin_Group_id = LB.Tools.RequestTool.RequestInt("Admin_Group_id", 0); } if (HttpContext.Current.Request["RealName"] != null) { model.RealName = LB.Tools.RequestTool.RequestSafeString("RealName"); } if (HttpContext.Current.Request["ModilePhone"] != null) { model.ModilePhone = LB.Tools.RequestTool.RequestSafeString("ModilePhone"); } if (HttpContext.Current.Request["Phone"] != null) { model.Phone = LB.Tools.RequestTool.RequestSafeString("Phone"); } if (HttpContext.Current.Request["Email"] != null) { model.Email = LB.Tools.RequestTool.RequestSafeString("Email"); } if (HttpContext.Current.Request["Sex"] != null) { model.Sex = LB.Tools.RequestTool.RequestSafeString("Sex"); } if (HttpContext.Current.Request["AdminType"] != null) { model.AdminType = LB.Tools.RequestTool.RequestSafeString("AdminType"); } if (HttpContext.Current.Request["Site_ids"] != null) { model.Site_ids = LB.Tools.RequestTool.RequestSafeString("Site_ids"); } if (HttpContext.Current.Request["Pro_Type_ids"] != null) { model.Pro_Type_ids = LB.Tools.RequestTool.RequestSafeString("Pro_Type_ids"); } if (HttpContext.Current.Request["RandNum"] != null) { model.RandNum = LB.Tools.RequestTool.RequestInt("RandNum", 0); } if (HttpContext.Current.Request["Avatar"] != null) { model.Avatar = LB.Tools.RequestTool.RequestSafeString("Avatar"); } if (HttpContext.Current.Request["Project_ids"] != null) { model.Project_ids = LB.Tools.RequestTool.RequestSafeString("Project_ids"); } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Lebi_Administrator model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + TableName + " set "); List <string> cols = new List <string>(); List <string> upcols = new List <string>(); string[] arrcols = model.UpdateCols.ToLower().Split(','); foreach (string c in arrcols) { upcols.Add(c); } if (upcols.Contains("username") || model.UpdateCols == "") { cols.Add(LB.DataAccess.DB.BaseUtilsInstance.ColName("UserName") + "= @UserName"); } if (upcols.Contains("password") || model.UpdateCols == "") { cols.Add(LB.DataAccess.DB.BaseUtilsInstance.ColName("Password") + "= @Password"); } if (upcols.Contains("ip_last") || model.UpdateCols == "") { cols.Add(LB.DataAccess.DB.BaseUtilsInstance.ColName("IP_Last") + "= @IP_Last"); } if (upcols.Contains("ip_this") || model.UpdateCols == "") { cols.Add(LB.DataAccess.DB.BaseUtilsInstance.ColName("IP_This") + "= @IP_This"); } if (upcols.Contains("time_add") || model.UpdateCols == "") { cols.Add(LB.DataAccess.DB.BaseUtilsInstance.ColName("Time_Add") + "= @Time_Add"); } if (upcols.Contains("time_this") || model.UpdateCols == "") { cols.Add(LB.DataAccess.DB.BaseUtilsInstance.ColName("Time_This") + "= @Time_This"); } if (upcols.Contains("time_last") || model.UpdateCols == "") { cols.Add(LB.DataAccess.DB.BaseUtilsInstance.ColName("Time_Last") + "= @Time_Last"); } if (upcols.Contains("count_login") || model.UpdateCols == "") { cols.Add(LB.DataAccess.DB.BaseUtilsInstance.ColName("Count_Login") + "= @Count_Login"); } if (upcols.Contains("type_id_adminstatus") || model.UpdateCols == "") { cols.Add(LB.DataAccess.DB.BaseUtilsInstance.ColName("Type_id_AdminStatus") + "= @Type_id_AdminStatus"); } if (upcols.Contains("admin_group_id") || model.UpdateCols == "") { cols.Add(LB.DataAccess.DB.BaseUtilsInstance.ColName("Admin_Group_id") + "= @Admin_Group_id"); } if (upcols.Contains("realname") || model.UpdateCols == "") { cols.Add(LB.DataAccess.DB.BaseUtilsInstance.ColName("RealName") + "= @RealName"); } if (upcols.Contains("modilephone") || model.UpdateCols == "") { cols.Add(LB.DataAccess.DB.BaseUtilsInstance.ColName("ModilePhone") + "= @ModilePhone"); } if (upcols.Contains("phone") || model.UpdateCols == "") { cols.Add(LB.DataAccess.DB.BaseUtilsInstance.ColName("Phone") + "= @Phone"); } if (upcols.Contains("email") || model.UpdateCols == "") { cols.Add(LB.DataAccess.DB.BaseUtilsInstance.ColName("Email") + "= @Email"); } if (upcols.Contains("sex") || model.UpdateCols == "") { cols.Add(LB.DataAccess.DB.BaseUtilsInstance.ColName("Sex") + "= @Sex"); } if (upcols.Contains("admintype") || model.UpdateCols == "") { cols.Add(LB.DataAccess.DB.BaseUtilsInstance.ColName("AdminType") + "= @AdminType"); } if (upcols.Contains("site_ids") || model.UpdateCols == "") { cols.Add(LB.DataAccess.DB.BaseUtilsInstance.ColName("Site_ids") + "= @Site_ids"); } if (upcols.Contains("pro_type_ids") || model.UpdateCols == "") { cols.Add(LB.DataAccess.DB.BaseUtilsInstance.ColName("Pro_Type_ids") + "= @Pro_Type_ids"); } if (upcols.Contains("randnum") || model.UpdateCols == "") { cols.Add(LB.DataAccess.DB.BaseUtilsInstance.ColName("RandNum") + "= @RandNum"); } if (upcols.Contains("avatar") || model.UpdateCols == "") { cols.Add(LB.DataAccess.DB.BaseUtilsInstance.ColName("Avatar") + "= @Avatar"); } if (upcols.Contains("project_ids") || model.UpdateCols == "") { cols.Add(LB.DataAccess.DB.BaseUtilsInstance.ColName("Project_ids") + "= @Project_ids"); } strSql.Append(string.Join(",", cols)); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", model.id), new SqlParameter("@UserName", model.UserName), new SqlParameter("@Password", model.Password), new SqlParameter("@IP_Last", model.IP_Last), new SqlParameter("@IP_This", model.IP_This), new SqlParameter("@Time_Add", model.Time_Add), new SqlParameter("@Time_This", model.Time_This), new SqlParameter("@Time_Last", model.Time_Last), new SqlParameter("@Count_Login", model.Count_Login), new SqlParameter("@Type_id_AdminStatus", model.Type_id_AdminStatus), new SqlParameter("@Admin_Group_id", model.Admin_Group_id), new SqlParameter("@RealName", model.RealName), new SqlParameter("@ModilePhone", model.ModilePhone), new SqlParameter("@Phone", model.Phone), new SqlParameter("@Email", model.Email), new SqlParameter("@Sex", model.Sex), new SqlParameter("@AdminType", model.AdminType), new SqlParameter("@Site_ids", model.Site_ids), new SqlParameter("@Pro_Type_ids", model.Pro_Type_ids), new SqlParameter("@RandNum", model.RandNum), new SqlParameter("@Avatar", model.Avatar), new SqlParameter("@Project_ids", model.Project_ids) }; LB.DataAccess.DB.Instance.TextExecuteNonQuery(strSql.ToString().Replace(", where id=@id", " where id=@id"), parameters); }