コード例 #1
0
ファイル: ObjectType.cs プロジェクト: vunb/CoreServicesNew
        public ObjectType GetByID(int objectTypeID)
        {
            ObjectType result         = null;
            var        findobjectType = ReadOnlyRecord <LObjectType> .FetchByID(objectTypeID);

            if (findobjectType != null)
            {
                result = new ObjectType(findobjectType);
            }

            return(result);
        }
コード例 #2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        string lotNumber = base.Request.QueryString["mo"].ToString();

        this.lotNo = lotNumber;
        DataTable fsMoInfo = new DAL().GetFsMoInfo(lotNumber);
        string    str2     = fsMoInfo.Rows[0]["ORDER_QTY"].ToString();
        string    str3     = fsMoInfo.Rows[0]["ITEM"].ToString();

        this.lblMo.Text   = lotNumber;
        this.lblAssy.Text = str3;
        this.lblQty.Text  = str2;
        DataTable fsInspectionInfo = new DAL().GetFsInspectionInfo(lotNumber);

        fsInspectionInfo.Rows[0]["ASSY_CATG"].ToString();
        if (fsInspectionInfo.Rows[0]["ASSY_CATG"].ToString().Trim() == "")
        {
            this.lblAssyCatg.Text = "U - " + ReadOnlyRecord <AssemblyCategoryCode> .FetchByID("U").AssyDesc;
        }
        else
        {
            this.lblAssyCatg.Text = fsInspectionInfo.Rows[0]["ASSY_CATG"].ToString().Trim() + " - "
                                    + ReadOnlyRecord <AssemblyCategoryCode> .FetchByID(fsInspectionInfo.Rows[0]["ASSY_CATG"].ToString().Trim()).AssyDesc;
        }
        bool flag = fsInspectionInfo.Rows[0]["BOARD"].ToString().Trim() == "BD";

        if (!flag)
        {
            //flag = fsInspectionInfo.Rows[0]["BOARD"].ToString().Trim() == "BIP";
            //flag = fsInspectionInfo.Rows[0]["BOARD"].ToString().Trim() == "BYR";
        }
        switch (fsInspectionInfo.Rows[0]["ASSY_CATG"].ToString().Trim())
        {
        case "H":
            if (flag)
            {
                this.isirCatg = 1;
            }
            else
            {
                this.isirCatg = 2;
            }
            break;

        case "B":
            this.isirCatg = 3;
            break;

        case "A":
            this.isirCatg = 2;
            break;

        case "M":
            this.isirCatg = 4;
            break;
        }
        switch (this.isirCatg)
        {
        case 1:
            this.wcId = 0x29;
            break;

        case 2:
            this.wcId = 0x2c;
            break;

        case 3:
            this.wcId = 0x2f;
            break;

        case 4:
            this.wcId = 13;
            break;
        }
        if (this.RadioButtonList1.SelectedValue == "True")
        {
            this.srcEmployees.SelectCommand = "SELECT ET_EMPLOYEES.EMP_NO, ET_EMPLOYEES.EMP_NO + ' - ' + EMP_NAME FROM\r\n                                                ET_EMPLOYEES,ET_ISIR_APPROVALS \r\n                                                WHERE \r\n                                                ET_ISIR_APPROVALS.EMP_NO = ET_EMPLOYEES.EMP_NO \r\n                                                AND\r\n                                                ISIR_CENTER_ID = " + this.isirCatg.ToString() + " AND(EMP_TERM_DTE IS NULL\r\n                                                OR LTRIM(RTRIM(CONVERT(VARCHAR(10),EMP_TERM_DTE))) = '')\r\n                                                ORDER BY EMP_NAME DESC";
        }
        else if (this.RadioButtonList1.SelectedValue == "False")
        {
            this.srcEmployees.SelectCommand = "SELECT EMP_NO, EMP_NO + ' - ' + EMP_NAME FROM\r\n                                                    ET_EMPLOYEES,ET_EMP_TRAINING_LEVELS \r\n                                                    WHERE \r\n                                                    ET_EMP_LVL_EMP_ID = EMP_NO\r\n                                                    AND\r\n                                                    ET_EMP_LVL_WC_ID = " + this.wcId + "\r\n                                                     AND\r\n                                                    EMP_TERM_DTE IS NULL\r\n                                                    OR LTRIM(RTRIM(CONVERT(VARCHAR(10),EMP_TERM_DTE))) = ''\r\n                                                    ORDER BY EMP_NAME DESC";
        }
        this.DropDownList4.DataBind();
    }