cyf
289 lines
14 KiB
C#
289 lines
14 KiB
C#
using Lskj.Control.Model;
|
||
using System;
|
||
using System.Collections.Generic;
|
||
using System.Data;
|
||
using System.Linq;
|
||
using System.Text;
|
||
|
||
namespace Lskj.PubModuleExport.Model
|
||
{
|
||
/// <summary>
|
||
/// PubModuleExport实体类
|
||
/// </summary>
|
||
public class SysSetModel : ControlModel
|
||
{
|
||
public int Id { get; set; }
|
||
public int GroupId { get; set; }
|
||
/// <summary>
|
||
/// 方案名称(没有使用)
|
||
/// </summary>
|
||
public string GroupName { get; set; }
|
||
/// <summary>
|
||
/// 序号
|
||
/// </summary>
|
||
public int OrderId { get; set; }
|
||
/// <summary>
|
||
/// 反写规格序号
|
||
/// </summary>
|
||
public int SpecSort { get; set; }
|
||
/// <summary>
|
||
/// 反写型号序号
|
||
/// </summary>
|
||
public int ModelSort { get; set; }
|
||
/// <summary>
|
||
/// 反写综合属性序号
|
||
/// </summary>
|
||
public int ProDeSort { get; set; }
|
||
/// <summary>
|
||
/// 反写材质序号
|
||
/// </summary>
|
||
public int GradeSort { get; set; }
|
||
/// <summary>
|
||
/// 节点（没有使用）
|
||
/// </summary>
|
||
public string SpeciesId { get; set; }
|
||
/// <summary>
|
||
/// 节点名（没有使用）
|
||
/// </summary>
|
||
public string SpeciesName { get; set; }
|
||
/// <summary>
|
||
/// 参数名
|
||
/// </summary>
|
||
public string SysName { get; set; }
|
||
//(没有使用)
|
||
public int SysCount { get; set; }
|
||
//(没有使用)
|
||
public int SysInt { get; set; }
|
||
/// <summary>
|
||
/// 备注(没有使用)
|
||
/// </summary>
|
||
public string SysInfo { get; set; }
|
||
//禁用标识 (没有使用)
|
||
public int Ban { get; set; }
|
||
/// <summary>
|
||
/// 类型 ，1仅限选择，2仅限输入
|
||
/// 1,下拉框控件
|
||
///2,文本框
|
||
///3,多选框控件
|
||
///4,备注框
|
||
///5,下拉备注框(把下拉框中的值添加到备注框中)
|
||
///6,文本（标签）
|
||
///7,复选框
|
||
///9,日期框
|
||
/// </summary>
|
||
public string Item { get; set; }
|
||
//(没有使用)
|
||
public string XZ1 { get; set; }
|
||
/// <summary>
|
||
/// 反写字段
|
||
/// </summary>
|
||
public string DbName { get; set; }
|
||
//(没有使用)
|
||
public int? DbNameCount { get; set; }
|
||
/// <summary>
|
||
/// 是否反写规格
|
||
/// </summary>
|
||
public int? SpecDbName { get; set; }
|
||
/// <summary>
|
||
/// 是否反写型号
|
||
/// </summary>
|
||
public int? ModelDbName { get; set; }
|
||
/// <summary>
|
||
/// 是否反写综合属性
|
||
/// </summary>
|
||
public int? ZhSxdbName { get; set; }
|
||
/// <summary>
|
||
/// 是否反写材质
|
||
/// </summary>
|
||
public int? CzdbName { get; set; }
|
||
/// <summary>
|
||
/// 反写规格型号类型
|
||
/// </summary>
|
||
public string FxType { get; set; }
|
||
/// <summary>
|
||
/// 反写字段类型
|
||
/// </summary>
|
||
public string FxTypeDB { get; set; }
|
||
/// <summary>
|
||
/// 数据源来源类型
|
||
/// </summary>
|
||
public string DataSourceType { get; set; }
|
||
/// <summary>
|
||
/// 数据源来源sql
|
||
/// </summary>
|
||
public string DataSourceSql { get; set; }
|
||
/// <summary>
|
||
/// 生成BOM标识 (没有使用)
|
||
/// </summary>
|
||
public int? BomTig { get; set; }
|
||
/// <summary>
|
||
/// 连接符
|
||
/// </summary>
|
||
public string ConnectorStr { get; set; }
|
||
/// <summary>
|
||
/// 默认编码（默认值，直接赋配置值）
|
||
/// </summary>
|
||
public string DefaultID { get; set; }
|
||
/// <summary>
|
||
/// 默认名称（默认值，可以配置sql，先在上方控件中替换参数，把最后执行的值赋值）
|
||
/// </summary>
|
||
public string DefaultName { get; set; }
|
||
/// <summary>
|
||
/// 必填标识
|
||
/// </summary>
|
||
public int? MustTig { get; set; }
|
||
/// <summary>
|
||
/// 关联字段
|
||
/// </summary>
|
||
public string UnionFields { get; set; }
|
||
/// <summary>
|
||
/// 关联值
|
||
/// </summary>
|
||
/// <value>The union values.</value>
|
||
public string UnionValues { get; set; }
|
||
/// <summary>
|
||
/// 禁编
|
||
/// </summary>
|
||
/// <value>The union values.</value>
|
||
public bool ProhibitEdited { get; set; }
|
||
/// <summary>
|
||
/// 排序字段（如果是默认的数据源sql，就拼接到最后select b.midno as id,b.sysnamelist as sysnamelist,b.bak as bak from p_productsyssettab a join p_productsyslisttab b on a.id = b.mid where mid = '{控件id}' order by b.{排序字段}）
|
||
/// </summary>
|
||
/// <value>The union values.</value>
|
||
public string OrderField { get; set; }
|
||
/// <summary>
|
||
/// 日期格式
|
||
/// </summary>
|
||
public string DataFormat { get; set; }
|
||
/// <summary>
|
||
/// 必填条件（根据条件设置控件是否为必填，如a改变后，判断所有条件中有{a}的控件，然后改变必填状态）
|
||
/// </summary>
|
||
public string RequiredCond { get; set; }
|
||
|
||
/// <summary>
|
||
/// 连接符（后方）（没用）
|
||
/// </summary>
|
||
public string EndConnectorStr { get; set; }
|
||
|
||
|
||
/// <summary>
|
||
/// 反写类型（反写规格）
|
||
/// </summary>
|
||
public string FxTypeGg { get; set; }
|
||
/// <summary>
|
||
/// 反写类型（反写型号）
|
||
/// </summary>
|
||
public string FxTypeXh { get; set; }
|
||
/// <summary>
|
||
/// 反写类型（反写综合属性）
|
||
/// </summary>
|
||
public string FxTypeZhsx { get; set; }
|
||
/// <summary>
|
||
/// 反写类型（反写材质）
|
||
/// </summary>
|
||
public string FxTypeCz { get; set; }
|
||
|
||
|
||
/// <summary>
|
||
/// 前连接符 （反写规格）
|
||
/// </summary>
|
||
public string ConnectorStrGg { get; set; }
|
||
// <summary>
|
||
/// 后连接符 （反写规格）
|
||
/// </summary>
|
||
public string EndConnectorStrGg { get; set; }
|
||
/// <summary>
|
||
/// 前连接符 （反写型号）
|
||
/// </summary>
|
||
public string ConnectorStrXh { get; set; }
|
||
// <summary>
|
||
/// 后连接符 （反写型号）
|
||
/// </summary>
|
||
public string EndConnectorStrXh { get; set; }
|
||
/// <summary>
|
||
/// 前连接符 （反写综合属性）
|
||
/// </summary>
|
||
public string ConnectorStrZhsx { get; set; }
|
||
// <summary>
|
||
/// 后连接符 （反写综合属性）
|
||
/// </summary>
|
||
public string EndConnectorStrZhsx { get; set; }
|
||
/// <summary>
|
||
/// 前连接符 （反写材质）
|
||
/// </summary>
|
||
public string ConnectorStrCz { get; set; }
|
||
// <summary>
|
||
/// 后连接符 （反写材质）
|
||
/// </summary>
|
||
public string EndConnectorStrCz { get; set; }
|
||
|
||
|
||
public SysSetModel(DataRow rowItem)
|
||
{
|
||
this.Id = rowItem.Table.Columns.Contains("id") && int.TryParse(rowItem["id"] + "", out int id) ? id : 0;
|
||
this.GroupId = rowItem.Table.Columns.Contains("Groupid") && int.TryParse(rowItem["Groupid"] + "", out int groupId) ? groupId : 0;
|
||
this.GroupName = rowItem.Table.Columns.Contains("GroupName") ? rowItem["GroupName"] + "" : "";
|
||
this.OrderId = rowItem.Table.Columns.Contains("orderid") && int.TryParse(rowItem["orderid"] + "", out int orderid) ? orderid : 0;
|
||
this.SpecSort = rowItem.Table.Columns.Contains("SpecSort") && int.TryParse(rowItem["SpecSort"] + "", out int specSort) ? specSort : 0;
|
||
this.ModelSort = rowItem.Table.Columns.Contains("ModelSort") && int.TryParse(rowItem["ModelSort"] + "", out int modelSort) ? modelSort : 0;
|
||
this.ProDeSort = rowItem.Table.Columns.Contains("ProDeSort") && int.TryParse(rowItem["ProDeSort"] + "", out int proDeSort) ? proDeSort : 0;
|
||
this.GradeSort = rowItem.Table.Columns.Contains("GradeSort") && int.TryParse(rowItem["GradeSort"] + "", out int gradeSort) ? gradeSort : 0;
|
||
this.SpeciesId = rowItem.Table.Columns.Contains("speciesid") ? rowItem["speciesid"] + "" : "";
|
||
this.SpeciesName = rowItem.Table.Columns.Contains("speciesname") ? rowItem["speciesname"] + "" : "";
|
||
this.SysName = rowItem.Table.Columns.Contains("sysname") ? rowItem["sysname"] + "" : "";
|
||
this.SysCount = rowItem.Table.Columns.Contains("syscount") && int.TryParse(rowItem["syscount"] + "", out int syscount) ? syscount : 0;
|
||
this.SysInt = rowItem.Table.Columns.Contains("sysint") && int.TryParse(rowItem["sysint"] + "", out int sysint) ? sysint : 0;
|
||
this.SysInfo = rowItem.Table.Columns.Contains("sysinfo") ? rowItem["sysinfo"] + "" : "";
|
||
this.Ban = rowItem.Table.Columns.Contains("ban") && int.TryParse(rowItem["ban"] + "", out int ban) ? ban : 0;
|
||
this.Item = rowItem.Table.Columns.Contains("Item") ? rowItem["Item"] + "" : "";
|
||
this.XZ1 = rowItem.Table.Columns.Contains("XZ1") ? rowItem["XZ1"] + "" : "";
|
||
this.DbName = rowItem.Table.Columns.Contains("dbname") ? rowItem["dbname"] + "" : "";
|
||
this.DbNameCount = rowItem.Table.Columns.Contains("dbnameCount") ? rowItem["dbnameCount"] == DBNull.Value ? (int?)null : Convert.ToInt32(rowItem["dbnameCount"] + "") : 0;
|
||
this.SpecDbName = rowItem.Table.Columns.Contains("specdbname") ? rowItem["specdbname"] == DBNull.Value ? (int?)null : Convert.ToInt32(rowItem["specdbname"] + "") : 0;
|
||
this.ModelDbName = rowItem.Table.Columns.Contains("modeldbname") ? rowItem["modeldbname"] == DBNull.Value ? (int?)null : Convert.ToInt32(rowItem["modeldbname"] + "") : 0;
|
||
this.ZhSxdbName = rowItem.Table.Columns.Contains("ZhSxdbName") ? rowItem["ZhSxdbName"] == DBNull.Value ? (int?)null : Convert.ToInt32(rowItem["ZhSxdbName"] + "") : 0;
|
||
this.CzdbName = rowItem.Table.Columns.Contains("CzdbName") ? rowItem["CzdbName"] == DBNull.Value ? (int?)null : Convert.ToInt32(rowItem["CzdbName"] + "") : 0;
|
||
this.FxType = rowItem.Table.Columns.Contains("FxType") ? rowItem["FxType"] + "" : "";
|
||
this.FxTypeDB = rowItem.Table.Columns.Contains("FxTypeDB") ? rowItem["FxTypeDB"] + "" : "";
|
||
this.DataSourceType = rowItem.Table.Columns.Contains("DataSourceType") ? rowItem["DataSourceType"] + "" : "";
|
||
this.DataSourceSql = rowItem.Table.Columns.Contains("DataSourceSql") ? rowItem["DataSourceSql"] + "" : "";
|
||
this.BomTig = rowItem.Table.Columns.Contains("BomTig") ? rowItem["BomTig"] == DBNull.Value ? (int?)null : Convert.ToInt32(rowItem["BomTig"] + "") : 0;
|
||
|
||
this.ConnectorStr = rowItem.Table.Columns.Contains("ConnectorStr") ? rowItem["ConnectorStr"] + "" : "";
|
||
this.EndConnectorStr = rowItem.Table.Columns.Contains("EndConnectorStr") ? rowItem["EndConnectorStr"] + "" : "";
|
||
|
||
this.DefaultID = rowItem.Table.Columns.Contains("defaultID") ? rowItem["defaultID"] + "" : "";
|
||
this.DefaultName = rowItem.Table.Columns.Contains("defaultName") ? rowItem["defaultName"] + "" : "";
|
||
this.MustTig = rowItem.Table.Columns.Contains("musttig") ? rowItem["musttig"] == DBNull.Value ? (int?)null : Convert.ToInt32(rowItem["musttig"] + "") : 0;
|
||
this.UnionFields = rowItem.Table.Columns.Contains("RelevanceField") ? rowItem["RelevanceField"] + "" : "";
|
||
this.UnionValues = rowItem.Table.Columns.Contains("RelevanceValue") ? rowItem["RelevanceValue"] + "" : "";
|
||
this.ProhibitEdited = rowItem.Table.Columns.Contains("ProhibitEdited") ? "1".Equals(rowItem["ProhibitEdited"] + "") : false;
|
||
this.LookUpFieldsWidth = rowItem.Table.Columns.Contains("LookUpFieldsWidth") ? rowItem["LookUpFieldsWidth"] + "" : "";
|
||
this.LookUpWidth = 0;
|
||
this.OrderField = rowItem.Table.Columns.Contains("lsidx_id") ? rowItem["lsidx_id"] + "" : "";
|
||
this.DataFormat = rowItem.Table.Columns.Contains("DataFormat") ? rowItem["DataFormat"] + "" : "";
|
||
this.RequiredCond = rowItem.Table.Columns.Contains("RequiredCond") ? rowItem["RequiredCond"] + "" : "";
|
||
this.DisableCond = rowItem.Table.Columns.Contains("DisableCond") ? rowItem["DisableCond"] + "" : "";
|
||
|
||
|
||
this.FxTypeGg = rowItem.Table.Columns.Contains("FxTypeGg") && !string.IsNullOrEmpty(rowItem["FxTypeGg"] + "") ? rowItem["FxTypeGg"] + "" : this.FxType;
|
||
this.FxTypeXh = rowItem.Table.Columns.Contains("FxTypeXh") && !string.IsNullOrEmpty(rowItem["FxTypeXh"] + "") ? rowItem["FxTypeXh"] + "" : this.FxType;
|
||
this.FxTypeZhsx = rowItem.Table.Columns.Contains("FxTypeZhsx") && !string.IsNullOrEmpty(rowItem["FxTypeZhsx"] + "") ? rowItem["FxTypeZhsx"] + "" : this.FxType;
|
||
this.FxTypeCz = rowItem.Table.Columns.Contains("FxTypeCz") && !string.IsNullOrEmpty(rowItem["FxTypeCz"] + "") ? rowItem["FxTypeCz"] + "" : this.FxType;
|
||
|
||
this.ConnectorStrGg = rowItem.Table.Columns.Contains("ConnectorStrGg") && !string.IsNullOrEmpty(rowItem["ConnectorStrGg"] + "") ? rowItem["ConnectorStrGg"] + "" : "";
|
||
this.EndConnectorStrGg = rowItem.Table.Columns.Contains("EndConnectorStrGg") && !string.IsNullOrEmpty(rowItem["EndConnectorStrGg"] + "") ? rowItem["EndConnectorStrGg"] + "" : "";
|
||
|
||
this.ConnectorStrXh = rowItem.Table.Columns.Contains("ConnectorStrXh") && !string.IsNullOrEmpty(rowItem["ConnectorStrXh"] + "") ? rowItem["ConnectorStrXh"] + "" : "";
|
||
this.EndConnectorStrXh = rowItem.Table.Columns.Contains("EndConnectorStrXh") && !string.IsNullOrEmpty(rowItem["EndConnectorStrXh"] + "") ? rowItem["EndConnectorStrXh"] + "" : "";
|
||
|
||
this.ConnectorStrZhsx = rowItem.Table.Columns.Contains("ConnectorStrZhsx") && !string.IsNullOrEmpty(rowItem["ConnectorStrZhsx"] + "") ? rowItem["ConnectorStrZhsx"] + "" : "";
|
||
this.EndConnectorStrZhsx = rowItem.Table.Columns.Contains("EndConnectorStrZhsx") && !string.IsNullOrEmpty(rowItem["EndConnectorStrZhsx"] + "") ? rowItem["EndConnectorStrZhsx"] + "" : "";
|
||
|
||
this.ConnectorStrCz = rowItem.Table.Columns.Contains("ConnectorStrCz") && !string.IsNullOrEmpty(rowItem["ConnectorStrCz"] + "") ? rowItem["ConnectorStrCz"] + "" : "";
|
||
this.EndConnectorStrCz = rowItem.Table.Columns.Contains("EndConnectorStrCz") && !string.IsNullOrEmpty(rowItem["EndConnectorStrCz"] + "") ? rowItem["EndConnectorStrCz"] + "" : "";
|
||
|
||
}
|
||
}
|
||
}
|