/// <summary>
/// 得到一个对象实体
/// </summary>
public XHD.Model.Sys_role GetModel(int RoleID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select RoleID,Factory_Id,RoleName,RoleDscript,RoleSort,CreateID,CreateDate,UpdateID,UpdateDate from Sys_role ");
strSql.Append(" where RoleID=@RoleID limit 1");
MySqlParameter[] parameters =
{
new MySqlParameter("@RoleID", MySqlDbType.Int32, 4)
};
parameters[0].Value = RoleID;
XHD.Model.Sys_role model = new XHD.Model.Sys_role();
DataSet ds = DbHelperMySQL.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(XHD.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("CreateID=@CreateID,");
strSql.Append("CreateDate=@CreateDate,");
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.NChar, 10),
new SqlParameter("@CreateID", SqlDbType.Int, 4),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
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.CreateID;
parameters[4].Value = model.CreateDate;
parameters[5].Value = model.UpdateID;
parameters[6].Value = model.UpdateDate;
parameters[7].Value = model.RoleID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(XHD.Model.Sys_role model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Sys_role(");
strSql.Append("Factory_Id,RoleName,RoleDscript,RoleSort,CreateID,CreateDate,UpdateID,UpdateDate)");
strSql.Append(" values (");
strSql.Append("@Factory_Id,@RoleName,@RoleDscript,@RoleSort,@CreateID,@CreateDate,@UpdateID,@UpdateDate)");
strSql.Append(";select @@IDENTITY");
MySqlParameter[] parameters =
{
new MySqlParameter("@Factory_Id", MySqlDbType.VarChar, 60),
new MySqlParameter("@RoleName", MySqlDbType.VarChar, 255),
new MySqlParameter("@RoleDscript", MySqlDbType.VarChar, 255),
new MySqlParameter("@RoleSort", MySqlDbType.Int32, 4),
new MySqlParameter("@CreateID", MySqlDbType.Int32, 4),
new MySqlParameter("@CreateDate", MySqlDbType.DateTime),
new MySqlParameter("@UpdateID", MySqlDbType.Int32, 4),
new MySqlParameter("@UpdateDate", MySqlDbType.DateTime)
};
parameters[0].Value = model.Factory_Id;
parameters[1].Value = model.RoleName;
parameters[2].Value = model.RoleDscript;
parameters[3].Value = model.RoleSort;
parameters[4].Value = model.CreateID;
parameters[5].Value = model.CreateDate;
parameters[6].Value = model.UpdateID;
parameters[7].Value = model.UpdateDate;
object obj = DbHelperMySQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public XHD.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;
XHD.Model.Sys_role model=new XHD.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=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;
}
}