using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using GThinking.N_MODEL.Page;
using System.Collections.Generic;
using GThinking.N_MISPRO.Data;

namespace GThinking.N_XLXSBJ     
{
    [TableMap(DB = "DBERP", DbTableName = "XLWBBJDANXX", Umid = 100860043, IsWorkFlow = false, IsAttach = false,

QuerySelSql = "select XLWBBJDANXX_ANLX, XLWBBJDANXX_ANXX, XLWBBJDANXX_XSSX,  "
            + " XLWBBJDANXX_WHR, XLWBBJDANXX_WHRID,XLWBBJDANXX_WHSJ from XLWBBJDANXX where 1=1 order by XLWBBJDANXX_ANLX,XLWBBJDANXX_XSSX ",

EntitySelSql = "select XLWBBJDANXX_ANLX, XLWBBJDANXX_ANXX, XLWBBJDANXX_ANXX AS old_XLWBBJDANXX_ANXX, XLWBBJDANXX_XSSX,  "
            + " XLWBBJDANXX_WHR, XLWBBJDANXX_WHRID,XLWBBJDANXX_WHSJ from XLWBBJDANXX "
            + " where XLWBBJDANXX_ANLX=:XLWBBJDANXX_ANLX and XLWBBJDANXX_ANXX=:XLWBBJDANXX_ANXX ",

UpdateSql = "update XLWBBJDANXX set XLWBBJDANXX_ANLX=:XLWBBJDANXX_ANLX, XLWBBJDANXX_ANXX=:XLWBBJDANXX_ANXX, XLWBBJDANXX_XSSX=:XLWBBJDANXX_XSSX, "
            + " XLWBBJDANXX_WHR= :XLWBBJDANXX_WHR, XLWBBJDANXX_WHRID= :XLWBBJDANXX_WHRID, XLWBBJDANXX_WHSJ= :XLWBBJDANXX_WHSJ"
            + " where XLWBBJDANXX_ANLX=:XLWBBJDANXX_ANLX and XLWBBJDANXX_ANXX=:old_XLWBBJDANXX_ANXX ",

InsertSql = "insert into XLWBBJDANXX(XLWBBJDANXX_ANLX, XLWBBJDANXX_ANXX, XLWBBJDANXX_XSSX, "
                    + " XLWBBJDANXX_WHR, XLWBBJDANXX_WHRID,XLWBBJDANXX_WHSJ) "
            + "values(:XLWBBJDANXX_ANLX, :XLWBBJDANXX_ANXX, :XLWBBJDANXX_XSSX,"
                    + " :XLWBBJDANXX_WHR, :XLWBBJDANXX_WHRID, :XLWBBJDANXX_WHSJ) ",

DeleteSql = "delete from XLWBBJDANXX where XLWBBJDANXX_ANLX=:XLWBBJDANXX_ANLX and XLWBBJDANXX_ANXX=:XLWBBJDANXX_ANXX ")]

    public class XLBJD_WBBJDANXX : EntityManager
    {
        #region 字段属性
        //关键字
        private string _XLWBBJDANXX_ANLX;
        [ColumnMap(DbField = "XLWBBJDANXX_ANLX", CtrlName = "txtANLX", Type = FieldType.HiddenField, DbTitle = "按钮类型", DefaultValue = "",
                  IsAllowNull = false, IsKey = false, Length = 2)]
        public string XLWBBJDANXX_ANLX
        {
            get { return _XLWBBJDANXX_ANLX; }
            set { _XLWBBJDANXX_ANLX = value; }
        }

        //关键字
        private string _XLWBBJDANXX_ANXX;
        [ColumnMap(DbField = "XLWBBJDANXX_ANXX", CtrlName = "cbxANXX", Type = FieldType.CBX, DbTitle = "按钮信息", DefaultValue = "",
                  IsAllowNull = false, IsKey = false, Length = 10)]
        public string XLWBBJDANXX_ANXX
        {
            get { return _XLWBBJDANXX_ANXX; }
            set { _XLWBBJDANXX_ANXX = value; }
        }

        private string _old_XLWBBJDANXX_ANXX;
        [ColumnMap(DbField = "old_XLWBBJDANXX_ANXX", CtrlName = "txtOLDANXX", Type = FieldType.HiddenField, DbTitle = "旧按钮信息", DefaultValue = "", PrintVisible = false,
           IsAllowNull = true, IsKey = false, Length = 10)]
        public string old_XLWBBJDANXX_ANXX
        {
            get { return _old_XLWBBJDANXX_ANXX; }
            set { _old_XLWBBJDANXX_ANXX = value; }
        }

        private string _XLWBBJDANXX_XSSX;
        [ColumnMap(DbField = "XLWBBJDANXX_XSSX", CtrlName = "txtXSSX", Type = FieldType.F, DbTitle = "显示顺序", DefaultValue = "",
                    IsAllowNull = true, IsKey = false, Length = 0)]
        public string XLWBBJDANXX_XSSX
        {
            get { return _XLWBBJDANXX_XSSX; }
            set { _XLWBBJDANXX_XSSX = value; }
        }

        private string _XLWBBJDANXX_WHR;
        [ColumnMap(DbField = "XLWBBJDANXX_WHR", CtrlName = "txtWHR", Type = FieldType.C, DbTitle = "维护人", DefaultValue = "",
                    IsAllowNull = true, IsKey = false, Length = 30)]
        public string XLWBBJDANXX_WHR
        {
            get { return _XLWBBJDANXX_WHR; }
            set { _XLWBBJDANXX_WHR = value; }
        }

        private string _XLWBBJDANXX_WHRID;
        [ColumnMap(DbField = "XLWBBJDANXX_WHRID", CtrlName = "txtWHRID", Type = FieldType.HiddenField, DbTitle = "维护人工号", DefaultValue = "",
                    IsAllowNull = true, IsKey = false, Length = 10)]
        public string XLWBBJDANXX_WHRID
        {
            get { return _XLWBBJDANXX_WHRID; }
            set { _XLWBBJDANXX_WHRID = value; }
        }

        private string _XLWBBJDANXX_WHSJ;
        [ColumnMap(DbField = "XLWBBJDANXX_WHSJ", CtrlName = "datWHSJ", Type = FieldType.DT, DbTitle = "维护时间", DefaultValue = "",
                    IsAllowNull = true, IsKey = false, Length = 18)]
        public string XLWBBJDANXX_WHSJ
        {
            get { return _XLWBBJDANXX_WHSJ; }
            set { _XLWBBJDANXX_WHSJ = value; }
        }
        #endregion


        public static Dictionary<string, string> TZ_ANXX(string sTZLX)
        {
            Dictionary<string, string> dic = new Dictionary<string, string>();
            dic.Clear();
            if (sTZLX.Trim().Equals("01"))
            {
                dic.Add("0", "NH-替换为N-");
                dic.Add("1", "ZR-替换为ZC-");
                dic.Add("2", "ZN-替换为ZCN-");
                dic.Add("C", "ZRN-替换为ZCN-");
                dic.Add("D", "ZRNH-替换为ZCN-");
                dic.Add("3", "WDZ-替换为WDZC-");
                dic.Add("4", "WDZN-替换为WDZCN-");
                dic.Add("8", "NH-替换为ZCN-");
                dic.Add("9", "ZRC-替换为ZC-");
                dic.Add("A", "ZRB-替换为ZB-");
                dic.Add("B", "ZRA-替换为ZA-");
                dic.Add("E", "WDZ-替换为WDZB-");
                dic.Add("F", "WDZC-替换为WDZB-");
                dic.Add("G", "N-替换为NH-");
                dic.Add("H", "ZR-A-替换为ZA-");
                dic.Add("I", "ZR-B-替换为ZB-");
                dic.Add("J", "ZR-C-替换为ZC-");
                dic.Add("K", "WD-替换为WDZC-");
                dic.Add("L", "NHA-替换为ZAN-");
                dic.Add("M", "WDZB2-替换为WDZA-");
                dic.Add("5", "去除空格");
                dic.Add("6", "去除中文");
                dic.Add("7", "型号替换");
                TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
                TSQL SQL = new TSQL(dberp);
                SQL.Clear();
                SQL.Add(" SELECT XLXHTHGZ_XH,XLXHTHGZ_THQ,XLXHTHGZ_THH FROM XLXHTHGZ WHERE 1=1 ");
                DataSet ds = dberp.OpenDataSet(SQL);
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    string skey = "N" + ds.Tables[0].Rows[i]["XLXHTHGZ_XH"].ToString().Trim();
                    string svalue = ds.Tables[0].Rows[i]["XLXHTHGZ_THQ"].ToString().Trim() + "替换为" + ds.Tables[0].Rows[i]["XLXHTHGZ_THH"].ToString().Trim();
                    dic.Add(skey, svalue);
                }
            }
            else if (sTZLX.Trim().Equals("02"))
            {
                dic.Clear();
                dic.Add("1", "去除非数值字符");
                dic.Add("2", "1*截面");
                dic.Add("3", "x/X替换为*");
                dic.Add("6", "x/X替换为×");
                dic.Add("4", "去除.0");
                dic.Add("7", "去除mm2、mm");
                dic.Add("8", "E或者PE替换为1或1*");
                dic.Add("A", "（）替换为()");
                dic.Add("B", "芯替换为*1");
                dic.Add("9", "去除空格");

            }
            return dic;
        }

        //默认展示规格调整规则
        public static Dictionary<string, string> GGTZ_MRZS()
        {
            Dictionary<string, string> dic = new Dictionary<string, string>();
            dic.Clear();
            dic.Add("1", "去除非数值字符");
            dic.Add("2", "1*截面");
            dic.Add("3", "x/X替换为*");
            dic.Add("6", "x/X替换为×");
            dic.Add("4", "去除.0");
            dic.Add("7", "去除mm2、mm");
            dic.Add("8", "E或者PE替换为1或1*");
            dic.Add("9", "去除空格");
            return dic;
        }

        //默认展示型号调整规则
        public static Dictionary<string, string> XHTZ_MRZS()
        {
            Dictionary<string, string> dic = new Dictionary<string, string>();
            dic.Clear();
            dic.Add("0", "NH-替换为N-");
            dic.Add("1", "ZR-替换为ZC-");
            dic.Add("2", "ZN-替换为ZCN-");
            dic.Add("3", "WDZ-替换为WDZC-");
            dic.Add("4", "WDZN-替换为WDZCN-");
            dic.Add("8", "NH-替换为ZCN-");
            dic.Add("9", "ZRC-替换为ZC-");
            dic.Add("A", "ZRB-替换为ZB-");
            dic.Add("B", "ZRA-替换为ZA-");
            dic.Add("C", "ZRN-替换为ZCN-");
            dic.Add("D", "ZRNH-替换为ZCN-");
            dic.Add("5", "去除空格");
            dic.Add("6", "去除中文");
            dic.Add("7", "型号替换");
            return dic;
        }

        //默认执行型号调整规则
        public static Dictionary<string, string> XHTZ_MRZX()
        {
            Dictionary<string, string> dic = new Dictionary<string, string>();
            dic.Clear();
            dic.Add("0", "NH-替换为N-");
            dic.Add("1", "ZR-替换为ZC-");
            dic.Add("2", "ZN-替换为ZCN-");
            dic.Add("3", "WDZ-替换为WDZC-");
            dic.Add("4", "WDZN-替换为WDZCN-");
            dic.Add("8", "NH-替换为ZCN-");
            dic.Add("9", "ZRC-替换为ZC-");
            dic.Add("A", "ZRB-替换为ZB-");
            dic.Add("B", "ZRA-替换为ZA-");
            dic.Add("C", "ZRN-替换为ZCN-");
            dic.Add("D", "ZRNH-替换为ZCN-");
            dic.Add("7", "型号替换");
            return dic;
        }

    }
}