/// <summary> /// 更新一条数据 /// </summary> public int Update(Model.U_Admin model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update U_Admin set "); strSql.Append("UserName=@UserName,"); strSql.Append("UserPwd=@UserPwd,"); strSql.Append("Realname=@Realname,"); strSql.Append("RolesId=@RolesId,"); strSql.Append("LastLoginTime=@LastLoginTime,"); strSql.Append("Enable=@Enable,"); strSql.Append("Created=@Created"); strSql.Append(" where UserId=@UserId"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.VarChar, 20), new SqlParameter("@UserPwd", SqlDbType.Char, 16), new SqlParameter("@Realname", SqlDbType.NVarChar, 20), new SqlParameter("@RolesId", SqlDbType.Int, 4), new SqlParameter("@LastLoginTime", SqlDbType.DateTime), new SqlParameter("@Enable", SqlDbType.Bit, 1), new SqlParameter("@Created", SqlDbType.DateTime), new SqlParameter("@UserId", SqlDbType.BigInt, 8) }; parameters[0].Value = model.UserName; parameters[1].Value = model.UserPwd; parameters[2].Value = model.Realname; parameters[3].Value = model.RolesId; parameters[4].Value = model.LastLoginTime; parameters[5].Value = model.Enable; parameters[6].Value = model.Created; parameters[7].Value = model.UserId; return(DBUtility.SqlHelper.ExecuteNonQuery(ConnString.connWrite, CommandType.Text, strSql.ToString(), parameters)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.U_Admin model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into U_Admin("); strSql.Append("UserName,UserPwd,Realname,RolesId,LastLoginTime,Enable,Created)"); strSql.Append(" values ("); strSql.Append("@UserName,@UserPwd,@Realname,@RolesId,@LastLoginTime,@Enable,@Created)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.VarChar, 20), new SqlParameter("@UserPwd", SqlDbType.Char, 16), new SqlParameter("@Realname", SqlDbType.NVarChar, 20), new SqlParameter("@RolesId", SqlDbType.Int, 4), new SqlParameter("@LastLoginTime", SqlDbType.DateTime), new SqlParameter("@Enable", SqlDbType.Bit, 1), new SqlParameter("@Created", SqlDbType.DateTime) }; parameters[0].Value = model.UserName; parameters[1].Value = model.UserPwd; parameters[2].Value = model.Realname; parameters[3].Value = model.RolesId; parameters[4].Value = model.LastLoginTime; parameters[5].Value = model.Enable; parameters[6].Value = model.Created; return(DBUtility.SqlHelper.ExecuteNonQuery(ConnString.connWrite, CommandType.Text, strSql.ToString(), parameters)); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.U_Admin GetModel(long UserId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 UserId,UserName,UserPwd,Realname,RolesId,LastLoginTime,Enable,Created from U_Admin "); strSql.Append(" where UserId=@UserId"); SqlParameter[] parameters = { new SqlParameter("@UserId", SqlDbType.BigInt) }; parameters[0].Value = UserId; Model.U_Admin model = new Model.U_Admin(); DataSet ds = DBUtility.SqlHelper.ExecuteDataSet(ConnString.connReadonly, CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["UserId"] != null && ds.Tables[0].Rows[0]["UserId"].ToString() != "") { model.UserId = long.Parse(ds.Tables[0].Rows[0]["UserId"].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]["UserPwd"] != null && ds.Tables[0].Rows[0]["UserPwd"].ToString() != "") { model.UserPwd = ds.Tables[0].Rows[0]["UserPwd"].ToString(); } if (ds.Tables[0].Rows[0]["Realname"] != null && ds.Tables[0].Rows[0]["Realname"].ToString() != "") { model.Realname = ds.Tables[0].Rows[0]["Realname"].ToString(); } if (ds.Tables[0].Rows[0]["RolesId"] != null && ds.Tables[0].Rows[0]["RolesId"].ToString() != "") { model.RolesId = int.Parse(ds.Tables[0].Rows[0]["RolesId"].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]["Enable"] != null && ds.Tables[0].Rows[0]["Enable"].ToString() != "") { if ((ds.Tables[0].Rows[0]["Enable"].ToString() == "1") || (ds.Tables[0].Rows[0]["Enable"].ToString().ToLower() == "true")) { model.Enable = true; } else { model.Enable = false; } } if (ds.Tables[0].Rows[0]["Created"] != null && ds.Tables[0].Rows[0]["Created"].ToString() != "") { model.Created = DateTime.Parse(ds.Tables[0].Rows[0]["Created"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.U_Admin GetModel(long UserId) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 UserId,UserName,UserPwd,Realname,RolesId,LastLoginTime,Enable,Created from U_Admin "); strSql.Append(" where UserId=@UserId"); SqlParameter[] parameters = { new SqlParameter("@UserId", SqlDbType.BigInt) }; parameters[0].Value = UserId; Model.U_Admin model=new Model.U_Admin(); DataSet ds= DBUtility.SqlHelper.ExecuteDataSet(ConnString.connReadonly, CommandType.Text, strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["UserId"]!=null && ds.Tables[0].Rows[0]["UserId"].ToString()!="") { model.UserId=long.Parse(ds.Tables[0].Rows[0]["UserId"].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]["UserPwd"]!=null && ds.Tables[0].Rows[0]["UserPwd"].ToString()!="") { model.UserPwd=ds.Tables[0].Rows[0]["UserPwd"].ToString(); } if(ds.Tables[0].Rows[0]["Realname"]!=null && ds.Tables[0].Rows[0]["Realname"].ToString()!="") { model.Realname=ds.Tables[0].Rows[0]["Realname"].ToString(); } if(ds.Tables[0].Rows[0]["RolesId"]!=null && ds.Tables[0].Rows[0]["RolesId"].ToString()!="") { model.RolesId=int.Parse(ds.Tables[0].Rows[0]["RolesId"].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]["Enable"]!=null && ds.Tables[0].Rows[0]["Enable"].ToString()!="") { if((ds.Tables[0].Rows[0]["Enable"].ToString()=="1")||(ds.Tables[0].Rows[0]["Enable"].ToString().ToLower()=="true")) { model.Enable=true; } else { model.Enable=false; } } if(ds.Tables[0].Rows[0]["Created"]!=null && ds.Tables[0].Rows[0]["Created"].ToString()!="") { model.Created=DateTime.Parse(ds.Tables[0].Rows[0]["Created"].ToString()); } return model; } else { return null; } }