/// <summary> /// 得到一个对象实体 /// </summary> public Student.Model.BRBAC_USER DataRowToModel(DataRow row) { Student.Model.BRBAC_USER model = new Student.Model.BRBAC_USER(); if (row != null) { if (row["USER_ID"] != null && row["USER_ID"].ToString() != "") { model.USER_ID = decimal.Parse(row["USER_ID"].ToString()); } if (row["USER_CDE"] != null) { model.USER_CDE = row["USER_CDE"].ToString(); } if (row["USER_NAME"] != null) { model.USER_NAME = row["USER_NAME"].ToString(); } if (row["USER_PWD"] != null) { model.USER_PWD = row["USER_PWD"].ToString(); } if (row["LAST_LOGIN_TIME"] != null && row["LAST_LOGIN_TIME"].ToString() != "") { model.LAST_LOGIN_TIME = DateTime.Parse(row["LAST_LOGIN_TIME"].ToString()); } if (row["AUTH_MENU"] != null) { model.AUTH_MENU = row["AUTH_MENU"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public decimal Add(Student.Model.BRBAC_USER model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BRBAC_USER("); strSql.Append("USER_CDE,USER_NAME,USER_PWD,LAST_LOGIN_TIME,AUTH_MENU)"); strSql.Append(" values ("); strSql.Append("@USER_CDE,@USER_NAME,@USER_PWD,@LAST_LOGIN_TIME,@AUTH_MENU)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@USER_CDE", SqlDbType.VarChar, 30), new SqlParameter("@USER_NAME", SqlDbType.VarChar, 50), new SqlParameter("@USER_PWD", SqlDbType.VarChar, 50), new SqlParameter("@LAST_LOGIN_TIME", SqlDbType.DateTime), new SqlParameter("@AUTH_MENU", SqlDbType.VarChar, 1000) }; parameters[0].Value = model.USER_CDE; parameters[1].Value = model.USER_NAME; parameters[2].Value = model.USER_PWD; parameters[3].Value = model.LAST_LOGIN_TIME; parameters[4].Value = model.AUTH_MENU; object obj = SqlHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToDecimal(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Student.Model.BRBAC_USER model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BRBAC_USER set "); strSql.Append("USER_CDE=@USER_CDE,"); strSql.Append("USER_NAME=@USER_NAME,"); strSql.Append("USER_PWD=@USER_PWD,"); strSql.Append("LAST_LOGIN_TIME=@LAST_LOGIN_TIME,"); strSql.Append("AUTH_MENU=@AUTH_MENU"); strSql.Append(" where USER_ID=@USER_ID"); SqlParameter[] parameters = { new SqlParameter("@USER_CDE", SqlDbType.VarChar, 30), new SqlParameter("@USER_NAME", SqlDbType.VarChar, 50), new SqlParameter("@USER_PWD", SqlDbType.VarChar, 50), new SqlParameter("@LAST_LOGIN_TIME", SqlDbType.DateTime), new SqlParameter("@AUTH_MENU", SqlDbType.VarChar, 1000), new SqlParameter("@USER_ID", SqlDbType.Decimal, 9) }; parameters[0].Value = model.USER_CDE; parameters[1].Value = model.USER_NAME; parameters[2].Value = model.USER_PWD; parameters[3].Value = model.LAST_LOGIN_TIME; parameters[4].Value = model.AUTH_MENU; parameters[5].Value = model.USER_ID; int rows = SqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Student.Model.BRBAC_USER GetModel(decimal USER_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 USER_ID,USER_CDE,USER_NAME,USER_PWD,LAST_LOGIN_TIME,AUTH_MENU from BRBAC_USER "); strSql.Append(" where USER_ID=@USER_ID"); SqlParameter[] parameters = { new SqlParameter("@USER_ID", SqlDbType.Decimal) }; parameters[0].Value = USER_ID; Student.Model.BRBAC_USER model = new Student.Model.BRBAC_USER(); DataSet ds = SqlHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }