/// <summary> /// 得到一个对象实体 /// </summary> public abc.Model.Model.Role DataRowToModel(DataRow row) { abc.Model.Model.Role model=new abc.Model.Model.Role(); if (row != null) { if(row["RoleId"]!=null && row["RoleId"].ToString()!="") { model.RoleId=int.Parse(row["RoleId"].ToString()); } if(row["RoleName"]!=null) { model.RoleName=row["RoleName"].ToString(); } } return model; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(abc.Model.Model.Role model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Role("); strSql.Append("RoleName)"); strSql.Append(" values ("); strSql.Append("SQL2012RoleName)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("SQL2012RoleName", SqlDbType.VarChar,255)}; parameters[0].Value = model.RoleName; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 得到一个对象实体 /// </summary> public abc.Model.Model.Role GetModel(int RoleId) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 RoleId,RoleName from Role "); strSql.Append(" where RoleId=SQL2012RoleId"); SqlParameter[] parameters = { new SqlParameter("SQL2012RoleId", SqlDbType.Int,4) }; parameters[0].Value = RoleId; abc.Model.Model.Role model=new abc.Model.Model.Role(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(abc.Model.Model.Role model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update Role set "); #warning 系统发现缺少更新的字段,请手工确认如此更新是否正确! strSql.Append("RoleId=SQL2012RoleId,"); strSql.Append("RoleName=SQL2012RoleName"); strSql.Append(" where RoleId=SQL2012RoleId"); SqlParameter[] parameters = { new SqlParameter("SQL2012RoleId", SqlDbType.Int,4), new SqlParameter("SQL2012RoleName", SqlDbType.VarChar,255)}; parameters[0].Value = model.RoleId; parameters[1].Value = model.RoleName; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }