/// <summary>
/// 获取实体信息
/// </summary>
/// <param name="row">数据行</param>
/// <returns></returns>
public static WfSupportGroupLevelEntity GetEntity(DataRow row)
{
WfSupportGroupLevelEntity entity = new WfSupportGroupLevelEntity();
if (row["GUID"] != DBNull.Value)
entity.GUID = Guid.Parse(row["GUID"].ToString());
entity.BusinessType = row["BusinessType"].ToString();
entity.GroupTypeName = row["GroupTypeName"].ToString();
if (row["GroupLevel"] != DBNull.Value)
entity.GroupLevel = Convert.ToInt32(row["GroupLevel"]);
return entity;
}
/// <summary>
/// 增加支持组级别
/// </summary>
/// <param name="wfSupportGroupLevel">支持组级别对象实体</param>
public static bool Add(WfSupportGroupLevelEntity entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into WF_SupportGroupLevel (");
strSql.Append(" GUID, BusinessType, GroupTypeName, GroupLevel)");
strSql.Append(" values ( ");
strSql.Append("@GUID, @BusinessType, @GroupTypeName, @GroupLevel)");
SqlParameter[] parameters = {
new SqlParameter("@GUID", SqlDbType.UniqueIdentifier),
new SqlParameter("@BusinessType", SqlDbType.NVarChar),
new SqlParameter("@GroupTypeName", SqlDbType.NVarChar),
new SqlParameter("@GroupLevel", SqlDbType.Int)
};
int i = 0;
parameters[i++].Value = entity.GUID;
parameters[i++].Value = entity.BusinessType;
parameters[i++].Value = entity.GroupTypeName;
parameters[i++].Value = entity.GroupLevel;
return DataHelper.ExecuteNoneQuery(strSql.ToString(), parameters) > 0;
}
/// <summary>
/// 更新支持组级别
/// </summary>
/// <param name="wF_SupportGroupLevel">支持组级别</param>
/// <returns>bool</returns>
public static bool Update(WfSupportGroupLevelEntity entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update WF_SupportGroupLevel set ");
strSql.Append("GUID = @GUID, ");
strSql.Append("BusinessType = @BusinessType, ");
strSql.Append("GroupTypeName = @GroupTypeName, ");
strSql.Append("GroupLevel = @GroupLevel");
strSql.Append(" where ");
strSql.Append(" GUID = @GUID ");
SqlParameter[] parameters = {
new SqlParameter("@GUID", SqlDbType.UniqueIdentifier),
new SqlParameter("@BusinessType", SqlDbType.NVarChar),
new SqlParameter("@GroupTypeName", SqlDbType.NVarChar),
new SqlParameter("@GroupLevel", SqlDbType.Int)
};
int i = 0;
parameters[i++].Value = entity.GUID;
parameters[i++].Value = entity.BusinessType;
parameters[i++].Value = entity.GroupTypeName;
parameters[i++].Value = entity.GroupLevel;
return DataHelper.ExecuteNoneQuery(strSql.ToString(), parameters) > 0;
}
