/// <summary> /// 更新一条数据 /// </summary> public bool Update(GL.Model.AdminModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update GL_Admin set "); strSql.Append("UserName=@UserName,"); strSql.Append("PassWord=@PassWord,"); strSql.Append("Sex=@Sex,"); strSql.Append("Email=@Email,"); strSql.Append("TelPhone=@TelPhone,"); //strSql.Append("AddDate=@AddDate,"); //strSql.Append("LastLoginIP=@LastLoginIP,"); //strSql.Append("LastLoginTime=@LastLoginTime,"); strSql.Append("Locked=@Locked,"); strSql.Append("ModelPower=@ModelPower"); //strSql.Append("LoginTime=@LoginTime"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.NVarChar, 50), new SqlParameter("@PassWord", SqlDbType.NVarChar, 50), new SqlParameter("@Sex", SqlDbType.Int, 4), new SqlParameter("@Email", SqlDbType.NVarChar, 50), new SqlParameter("@TelPhone", SqlDbType.NVarChar, 50), //new SqlParameter("@AddDate", SqlDbType.DateTime), //new SqlParameter("@LastLoginIP", SqlDbType.NVarChar,50), //new SqlParameter("@LastLoginTime", SqlDbType.DateTime), new SqlParameter("@Locked", SqlDbType.Int, 4), new SqlParameter("@ModelPower", SqlDbType.NVarChar, 350), //new SqlParameter("@LoginTime", SqlDbType.Int,4), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.UserName; parameters[1].Value = model.PassWord; parameters[2].Value = model.Sex; parameters[3].Value = model.Email; parameters[4].Value = model.TelPhone; //parameters[5].Value = model.AddDate; //parameters[6].Value = model.LastLoginIP; //parameters[7].Value = model.LastLoginTime; parameters[5].Value = model.Locked; parameters[6].Value = model.ModelPower; // parameters[7].Value = model.LoginTime; parameters[7].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(GL.Model.AdminModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into GL_Admin("); strSql.Append("UserName,PassWord,Sex,Email,TelPhone,AddDate,LastLoginIP,LastLoginTime,Locked,ModelPower,LoginTime)"); strSql.Append(" values ("); strSql.Append("@UserName,@PassWord,@Sex,@Email,@TelPhone,@AddDate,@LastLoginIP,@LastLoginTime,@Locked,@ModelPower,@LoginTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.NVarChar, 50), new SqlParameter("@PassWord", SqlDbType.NVarChar, 50), new SqlParameter("@Sex", SqlDbType.Int, 4), new SqlParameter("@Email", SqlDbType.NVarChar, 50), new SqlParameter("@TelPhone", SqlDbType.NVarChar, 50), new SqlParameter("@AddDate", SqlDbType.DateTime), new SqlParameter("@LastLoginIP", SqlDbType.NVarChar, 50), new SqlParameter("@LastLoginTime", SqlDbType.DateTime), new SqlParameter("@Locked", SqlDbType.Int, 4), new SqlParameter("@ModelPower", SqlDbType.NVarChar, 350), new SqlParameter("@LoginTime", SqlDbType.Int, 4) }; parameters[0].Value = model.UserName; parameters[1].Value = model.PassWord; parameters[2].Value = model.Sex; parameters[3].Value = model.Email; parameters[4].Value = model.TelPhone; parameters[5].Value = model.AddDate; parameters[6].Value = model.LastLoginIP; parameters[7].Value = model.LastLoginTime; parameters[8].Value = model.Locked; parameters[9].Value = model.ModelPower; parameters[10].Value = model.LoginTime; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 根据用户名取得实体ID,ModelPower,LoginTime,登录时用到 /// </summary> /// <param name="UserName"></param> /// <returns></returns> public GL.Model.AdminModel Getid(string UserName) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,UserName,ModelPower,LoginTime from GL_Admin "); strSql.Append(" where UserName=@UserName"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.NVarChar, 50) }; parameters[0].Value = UserName; GL.Model.AdminModel model = new GL.Model.AdminModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["ModelPower"] != null && ds.Tables[0].Rows[0]["ModelPower"].ToString() != "") { model.ModelPower = ds.Tables[0].Rows[0]["ModelPower"].ToString(); } if (ds.Tables[0].Rows[0]["LoginTime"] != null && ds.Tables[0].Rows[0]["LoginTime"].ToString() != "") { model.LoginTime = int.Parse(ds.Tables[0].Rows[0]["LoginTime"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(GL.Model.AdminModel model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(GL.Model.AdminModel model) { return(dal.Update(model)); }
/// <summary> /// 得到一个对象实体 /// </summary> public GL.Model.AdminModel GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,UserName,PassWord,Sex,Email,TelPhone,AddDate,LastLoginIP,LastLoginTime,Locked,ModelPower,LoginTime from GL_Admin "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; GL.Model.AdminModel model = new GL.Model.AdminModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["UserName"] != null && ds.Tables[0].Rows[0]["UserName"].ToString() != "") { model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString(); } if (ds.Tables[0].Rows[0]["PassWord"] != null && ds.Tables[0].Rows[0]["PassWord"].ToString() != "") { model.PassWord = ds.Tables[0].Rows[0]["PassWord"].ToString(); } if (ds.Tables[0].Rows[0]["Sex"] != null && ds.Tables[0].Rows[0]["Sex"].ToString() != "") { model.Sex = int.Parse(ds.Tables[0].Rows[0]["Sex"].ToString()); } if (ds.Tables[0].Rows[0]["Email"] != null && ds.Tables[0].Rows[0]["Email"].ToString() != "") { model.Email = ds.Tables[0].Rows[0]["Email"].ToString(); } if (ds.Tables[0].Rows[0]["TelPhone"] != null && ds.Tables[0].Rows[0]["TelPhone"].ToString() != "") { model.TelPhone = ds.Tables[0].Rows[0]["TelPhone"].ToString(); } if (ds.Tables[0].Rows[0]["AddDate"] != null && ds.Tables[0].Rows[0]["AddDate"].ToString() != "") { model.AddDate = DateTime.Parse(ds.Tables[0].Rows[0]["AddDate"].ToString()); } if (ds.Tables[0].Rows[0]["LastLoginIP"] != null && ds.Tables[0].Rows[0]["LastLoginIP"].ToString() != "") { model.LastLoginIP = ds.Tables[0].Rows[0]["LastLoginIP"].ToString(); } if (ds.Tables[0].Rows[0]["LastLoginTime"] != null && ds.Tables[0].Rows[0]["LastLoginTime"].ToString() != "") { model.LastLoginTime = DateTime.Parse(ds.Tables[0].Rows[0]["LastLoginTime"].ToString()); } if (ds.Tables[0].Rows[0]["Locked"] != null && ds.Tables[0].Rows[0]["Locked"].ToString() != "") { model.Locked = int.Parse(ds.Tables[0].Rows[0]["Locked"].ToString()); } if (ds.Tables[0].Rows[0]["ModelPower"] != null && ds.Tables[0].Rows[0]["ModelPower"].ToString() != "") { model.ModelPower = ds.Tables[0].Rows[0]["ModelPower"].ToString(); } if (ds.Tables[0].Rows[0]["LoginTime"] != null && ds.Tables[0].Rows[0]["LoginTime"].ToString() != "") { model.LoginTime = int.Parse(ds.Tables[0].Rows[0]["LoginTime"].ToString()); } return(model); } else { return(null); } }