/// <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; }