/// <summary>
/// 根据系统类型定义ID获取名称
/// </summary>
/// <param name="FieldId">系统类型定义ID</param>
/// <param name="SysFieldType">系统类型定义类型</param>
/// <returns>系统类型定义名称</returns>
public string GetFieldNameById(int FieldId, Model.SystemStructure.SysFieldType SysFieldType)
{
string strName = string.Empty;
IList <Model.SystemStructure.SysFieldBase> tmpList = GetSysField(SysFieldType);
if (tmpList == null && tmpList.Count <= 0)
{
return(strName);
}
tmpList = tmpList.Where(Item => (Item.FieldId == FieldId)).ToList();
if (tmpList == null && tmpList.Count <= 0)
{
return(strName);
}
strName = tmpList[0].FieldName;
if (tmpList != null)
{
tmpList.Clear();
}
tmpList = null;
return(strName);
}
/// <summary>
/// 真实删除客户等级
/// </summary>
/// <param name="FieldIds">客户等级编号字符串</param>
/// <param name="FieldType">客户等级类型</param>
/// <returns>true:成功 false:失败</returns>
public virtual bool Delete(string FieldIds, Model.SystemStructure.SysFieldType FieldType)
{
StringBuilder strSql = new StringBuilder(Sql_SysField_Delete + ";");
if (FieldType == Model.SystemStructure.SysFieldType.线路主题)
{
strSql.Append("Delete tbl_TourThemeControl where ThemeId in(@fields) ;");
strSql.Append("Delete tbl_RouteThemeControl where ThemeId in(@fields) ;");
}
DbCommand dc = this.SystemStore.GetSqlStringCommand(strSql.ToString());
this.SystemStore.AddInParameter(dc, "fields", DbType.String, FieldIds);
this.SystemStore.AddInParameter(dc, "FieldType", DbType.Byte, (int)FieldType);
return(DbHelper.ExecuteSqlTrans(dc, this.SystemStore) > 0 ? true : false);
}
/// <summary>
/// 修改系统类型定义(只修改名称)
/// </summary>
/// <param name="FieldName">系统类型定义名称</param>
/// <param name="FieldId">系统类型定义ID</param>
/// <param name="FieldType">系统类型定义类型</param>
/// <returns>返回受影响行数</returns>
public virtual int UpdateSysField(string FieldName, int FieldId, Model.SystemStructure.SysFieldType FieldType)
{
if (string.IsNullOrEmpty(FieldName))
{
return(0);
}
DbCommand dc = base.SystemStore.GetSqlStringCommand(Sql_SysField_Update);
base.SystemStore.AddInParameter(dc, "FieldName", DbType.String, FieldName);
base.SystemStore.AddInParameter(dc, "FieldID", DbType.Int32, FieldId);
base.SystemStore.AddInParameter(dc, "FieldType", DbType.Byte, (int)FieldType);
return(DbHelper.ExecuteSql(dc, base.SystemStore));
}
/// <summary>
/// 修改系统类型定义(只修改名称)
/// </summary>
/// <param name="FieldName">系统类型定义名称</param>
/// <param name="FieldId">系统类型定义ID</param>
/// <param name="FieldType">系统类型定义类型</param>
/// <returns>0:Error;1:Success</returns>
public int UpdateSysField(string FieldName, int FieldId, Model.SystemStructure.SysFieldType FieldType)
{
if (string.IsNullOrEmpty(FieldName))
{
return(0);
}
int Result = dal.UpdateSysField(FieldName, FieldId, FieldType);
if (Result > 0)
{
RemoveCache(FieldType);
return(1);
}
else
{
return(0);
}
}
/// <summary>
/// 真实删除客户等级
/// </summary>
/// <param name="FieldId">客户等级编号集合</param>
/// <param name="FieldType">客户等级类型</param>
/// <returns>true:成功 false:失败</returns>
public bool Delete(int[] FieldId, Model.SystemStructure.SysFieldType FieldType)
{
if (FieldId == null || FieldId.Length == 0)
{
return(false);
}
String strFields = string.Empty;
for (int i = 0; i < FieldId.Length; i++)
{
strFields += FieldId[i] + ",";
}
strFields = strFields.TrimEnd(',');
bool Result = dal.Delete(strFields, FieldType);
if (Result)
{
RemoveCache(FieldType);
}
return(Result);
}
/// <summary>
/// 获取已启用的系统类型定义集合(缓存取值)
/// </summary>
/// <param name="SysFieldType">系统类型定义类型</param>
/// <returns>系统类型定义集合</returns>
public IList <Model.SystemStructure.SysFieldBase> GetSysFieldBaseList(Model.SystemStructure.SysFieldType SysFieldType)
{
return(GetSysField(SysFieldType));
}
