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