public bool Update(Model.JurisdictionModel model)
{
StringBuilder strSQL = new StringBuilder();
strSQL.Append("update Jurisdiction set JueisName=@JueisName,RoleIds=@RoleIds where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@JueisName", SqlDbType.VarChar, 20),
new SqlParameter("@RoleIds", SqlDbType.VarChar, 20),
new SqlParameter("@id", SqlDbType.Int)
};
parameters[0].Value = model.JueisName;
parameters[1].Value = model.RoleIds;
parameters[2].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSQL.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 将行数据转换成对象
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public Model.JurisdictionModel DataRowToModel(DataRow dr)
{
Model.JurisdictionModel model = new Model.JurisdictionModel();
if (dr != null)
{
model.Id = Convert.ToInt32(dr["Id"].ToString());
model.JueisName = dr["JueisName"].ToString();
model.RoleIds = dr["RoleIds"].ToString();
}
return(model);
}
/// <summary>
/// 根据ID获取对象;
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public Model.JurisdictionModel GetModel(int Id)
{
StringBuilder strSQL = new StringBuilder();
strSQL.Append("select id,JueisName,RoleIds from Jurisdiction");
strSQL.Append(" where id=@id");
SqlParameter[] parameter =
{
new SqlParameter("@id", SqlDbType.Int)
};
parameter[0].Value = Id;
DataSet ds = DbHelperSQL.Query(strSQL.ToString(), parameter);
Model.JurisdictionModel tempModel = new Model.JurisdictionModel();
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow item in ds.Tables[0].Rows)
{
tempModel = DataRowToModel(item);
}
}
return(tempModel);
}
/// <summary>
/// 新增方法
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(Model.JurisdictionModel model)
{
StringBuilder strSQL = new StringBuilder();
strSQL.Append("insert into Jurisdiction (JueisName,RoleIds)");
strSQL.Append("values (@JueisName,@RoleIds)");
SqlParameter[] parameters =
{
new SqlParameter("@JueisName", SqlDbType.VarChar, 50),
new SqlParameter("@RoleIds", SqlDbType.VarChar, 200)
};
parameters[0].Value = model.JueisName;
parameters[1].Value = model.RoleIds;
int row = Maticsoft.DBUtility.DbHelperSQL.ExecuteSql(strSQL.ToString(), parameters);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
