/// <summary>
/// 得到一个对象实体
/// </summary>
public Garfield.Model.Sys_role GetModel(int RoleID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 RoleID,RoleName,RoleDscript,RoleSort,CreateID,CreateDate,UpdateID,UpdateDate from Sys_role ");
strSql.Append(" where RoleID=@RoleID");
SqlParameter[] parameters =
{
new SqlParameter("@RoleID", SqlDbType.Int, 4)
};
parameters[0].Value = RoleID;
Garfield.Model.Sys_role model = new Garfield.Model.Sys_role();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["RoleID"] != null && ds.Tables[0].Rows[0]["RoleID"].ToString() != "")
{
model.RoleID = int.Parse(ds.Tables[0].Rows[0]["RoleID"].ToString());
}
if (ds.Tables[0].Rows[0]["RoleName"] != null && ds.Tables[0].Rows[0]["RoleName"].ToString() != "")
{
model.RoleName = ds.Tables[0].Rows[0]["RoleName"].ToString();
}
if (ds.Tables[0].Rows[0]["RoleDscript"] != null && ds.Tables[0].Rows[0]["RoleDscript"].ToString() != "")
{
model.RoleDscript = ds.Tables[0].Rows[0]["RoleDscript"].ToString();
}
if (ds.Tables[0].Rows[0]["RoleSort"] != null && ds.Tables[0].Rows[0]["RoleSort"].ToString() != "")
{
model.RoleSort = int.Parse(ds.Tables[0].Rows[0]["RoleSort"].ToString());
}
if (ds.Tables[0].Rows[0]["CreateID"] != null && ds.Tables[0].Rows[0]["CreateID"].ToString() != "")
{
model.CreateID = int.Parse(ds.Tables[0].Rows[0]["CreateID"].ToString());
}
if (ds.Tables[0].Rows[0]["CreateDate"] != null && ds.Tables[0].Rows[0]["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString());
}
if (ds.Tables[0].Rows[0]["UpdateID"] != null && ds.Tables[0].Rows[0]["UpdateID"].ToString() != "")
{
model.UpdateID = int.Parse(ds.Tables[0].Rows[0]["UpdateID"].ToString());
}
if (ds.Tables[0].Rows[0]["UpdateDate"] != null && ds.Tables[0].Rows[0]["UpdateDate"].ToString() != "")
{
model.UpdateDate = DateTime.Parse(ds.Tables[0].Rows[0]["UpdateDate"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Garfield.Model.Sys_role model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Sys_role set ");
strSql.Append("RoleName=@RoleName,");
strSql.Append("RoleDscript=@RoleDscript,");
strSql.Append("RoleSort=@RoleSort,");
strSql.Append("UpdateID=@UpdateID,");
strSql.Append("UpdateDate=@UpdateDate");
strSql.Append(" where RoleID=@RoleID");
SqlParameter[] parameters =
{
new SqlParameter("@RoleName", SqlDbType.VarChar, 255),
new SqlParameter("@RoleDscript", SqlDbType.VarChar, 255),
new SqlParameter("@RoleSort", SqlDbType.Int, 4),
new SqlParameter("@UpdateID", SqlDbType.Int, 4),
new SqlParameter("@UpdateDate", SqlDbType.DateTime),
new SqlParameter("@RoleID", SqlDbType.Int, 4)
};
parameters[0].Value = model.RoleName;
parameters[1].Value = model.RoleDscript;
parameters[2].Value = model.RoleSort;
parameters[3].Value = model.UpdateID;
parameters[4].Value = model.UpdateDate;
parameters[5].Value = model.RoleID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Garfield.Model.Sys_role model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Sys_role(");
strSql.Append("RoleName,RoleDscript,RoleSort,CreateID,CreateDate,UpdateID,UpdateDate)");
strSql.Append(" values (");
strSql.Append("@RoleName,@RoleDscript,@RoleSort,@CreateID,@CreateDate,@UpdateID,@UpdateDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@RoleName", SqlDbType.VarChar, 255),
new SqlParameter("@RoleDscript", SqlDbType.VarChar, 255),
new SqlParameter("@RoleSort", SqlDbType.Int, 4),
new SqlParameter("@CreateID", SqlDbType.Int, 4),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@UpdateID", SqlDbType.Int, 4),
new SqlParameter("@UpdateDate", SqlDbType.DateTime)
};
parameters[0].Value = model.RoleName;
parameters[1].Value = model.RoleDscript;
parameters[2].Value = model.RoleSort;
parameters[3].Value = model.CreateID;
parameters[4].Value = model.CreateDate;
parameters[5].Value = model.UpdateID;
parameters[6].Value = model.UpdateDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
