/// <summary>
        /// IIC文件更新
        /// </summary>
        /// <param name="intImpID">导入ID</param>
        /// <returns></returns>
        public bool IICDataUpdate(long intImpID, int intFlag)
        {
            OracleConnection  cn             = new OracleConnection(System.Configuration.ConfigurationManager.ConnectionStrings["OraConnStringDJ"].ConnectionString);
            DataTable         dtSystemConfig = new DataTable();
            string            strOra         = "select * from tbl00_system_config";
            OracleDataAdapter dap            = new OracleDataAdapter();
            OracleCommand     cmd            = new OracleCommand();

            cmd.CommandType   = CommandType.Text;
            cmd.CommandText   = strOra;
            cmd.Connection    = cn;
            dap.SelectCommand = cmd;
            dap.Fill(dtSystemConfig);

            UtilityDBDJ utility = new UtilityDBDJ();

            try
            {
                if (cn.State != ConnectionState.Open)
                {
                    cn.Open();
                }
                UtilityDBDJ.CreateErrorLog("开始执行存储过程!");
                utility.OperatorStore(cmd, intImpID, intImpID, dtSystemConfig, intFlag);
                UtilityDBDJ.CreateErrorLog("完成执行存储过程!");
            }
            catch
            {
                return(false);
            }
            finally
            {
                cmd.Dispose();
                if (cn.State != ConnectionState.Closed)
                {
                    cn.Close();
                }
                if (cn != null)
                {
                    cn.Dispose();
                }
            }
            return(true);
        }
        private void ReadIIC(IDictionary <string, Model.DecisionProjectObjDJ> ts, Model.DetectRecordObjDJ detectRecordObj, DataTable dtUnitAreaConfig, DataTable dtSystemConfig, int intDataID, int intRecordID, int intTaskID, int intPlanID, string strIICPath, string strFileName, string strImpDes)
        {
            string strIICFullPath = GetIICDirection(dtSystemConfig) + strIICPath + "\\" + strFileName;

            using (OleDbConnection oleCn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strIICFullPath + ";Persist Security Info=True"))
            {
                oleCn.Open();
                OleDbCommand    cmd = new OleDbCommand("select * from fix_defects", oleCn);
                OleDbDataReader myRed;
                bool            bFxIsExists = true;
                try
                {
                    myRed = cmd.ExecuteReader();
                }
                catch
                {
                    bFxIsExists = false;
                }
                string strSQLForDefects = string.Empty;
                string strSQLForTQI     = string.Empty;
                if (!bFxIsExists)
                {
                    strSQLForDefects = "select * from defects where valid <> 'N' and severity is not null";
                    strSQLForTQI     = "TRANSFORM max([tqivalue]) SELECT [FROMPOST],round((round([basepost],3)-[FROMPOST])*1000,0) as [FROMMINOR] FROM tqi GROUP BY [FROMPOST],round((round([basepost],3)-[FROMPOST])*1000,0) PIVOT [tqimetricname]";
                }
                else
                {
                    //new表存在的情况
                    strSQLForDefects = "select * from fix_defects where  valid <> 'N' and severity is not null and maxval2=-200";
                    //strSQLForTQI = "TRANSFORM max([tqivalue]) SELECT [FROMPOST],[FROMMINOR] FROM fix_tqi GROUP BY [FROMPOST],[FROMMINOR] PIVOT [tqimetricname]";
                    strSQLForTQI = "select * FROM fix_tqi";
                }

                DataTable        dtDefectsData = new DataTable("defects");
                OleDbDataAdapter dapt          = new OleDbDataAdapter();
                dapt.SelectCommand             = new OleDbCommand();
                dapt.SelectCommand.Connection  = oleCn;
                dapt.SelectCommand.CommandText = strSQLForDefects;
                dapt.Fill(dtDefectsData);

                DataTable dtTQIData = new DataTable("tqi");
                dapt.SelectCommand.CommandText = strSQLForTQI;
                dapt.Fill(dtTQIData);

                UtilityDBDJ utility = new UtilityDBDJ();
                //if (!bFxIsExists)
                //{ strImpDes="TQI无效,-1009";}
                int intImpID = utility.OperatorImpLog(intDataID, intRecordID, strFileName, strIICPath, strImpDes);

                OracleConnection cn = new OracleConnection(System.Configuration.ConfigurationManager.ConnectionStrings["OraConnStringDJ"].ConnectionString);
                cn.Open();
                //OracleTransaction transaction = cn.BeginTransaction();
                OracleCommand cmdInner = new OracleCommand();
                cmdInner.CommandType = CommandType.Text;
                cmdInner.Connection  = cn;
                //cmdInner.Transaction = transaction;
                try
                {
                    UtilityDBDJ.CreateErrorLog("开始导入TQI数据!");
                    utility.OperatorTQI(cmdInner, detectRecordObj, dtUnitAreaConfig, dtTQIData, bFxIsExists, intImpID, intRecordID, intTaskID, intPlanID);
                    UtilityDBDJ.CreateErrorLog("完成导入TQI数据!");
                    UtilityDBDJ.CreateErrorLog("开始导入号为:" + intImpID.ToString() + "的文件");
                    utility.OperatorDefects(cmdInner, ts, detectRecordObj, dtUnitAreaConfig, dtDefectsData, intImpID, intRecordID, intTaskID, intPlanID);
                    UtilityDBDJ.CreateErrorLog("完成导入号为:" + intImpID.ToString() + "的文件");
                    UtilityDBDJ.CreateErrorLog("开始执行存储过程!");
                    utility.OperatorStore(cmdInner, intImpID, intRecordID, dtSystemConfig, 1);
                    utility.OperatorStore(cmdInner, intImpID, intRecordID, dtSystemConfig, 0);
                    UtilityDBDJ.CreateErrorLog("完成执行存储过程!");
                    //transaction.Commit();
                    utility.SetDetectDataManage(intDataID);
                }
                catch (Exception e)
                {
                    //transaction.Rollback();
                    utility.SetImpLog(e.Message.ToString(), intImpID);
                }
                finally
                {
                    cmdInner.Dispose();
                    if (cn.State != ConnectionState.Closed)
                    {
                        cn.Close();
                    }
                    if (cn != null)
                    {
                        cn.Dispose();
                    }
                }
            }
        }
        /// <summary>
        /// 晃车数据导入
        /// </summary>
        /// <param name="intSType">0:世恒数据;1:三岭数据;</param>
        /// <param name="strFileName">导入的文件名</param>
        /// <returns></returns>
        public bool HCDataImp(int intSType, string strFileName)
        {
            bool returnValue = true;

            #region 晃车数据导入
            string  strOra = string.Empty;
            DataSet ds     = null;
            try
            {
                ds = ReadExcel(strFileName);
            }
            catch (Exception)
            {
                returnValue = false;
            }
            IDictionary <string, string> tsLine    = null;
            IDictionary <string, string> tsLineDir = null;
            if (ds != null && ds.Tables[0].Rows.Count > 0)
            {
                using (OracleConnection cn = new OracleConnection(System.Configuration.ConfigurationManager.ConnectionStrings["OraConnStringDJ"].ConnectionString))
                {
                    #region using体
                    long intImpID = long.Parse(DateTime.Now.ToString("yyyyMMddHHmmss"));
                    try
                    {
                        OracleCommand cmd = new OracleCommand();
                        cmd.CommandType = CommandType.Text;
                        cmd.Connection  = cn;

                        cn.Open();
                        #region 获取字典表数据
                        cmd.CommandText = "select ID,NAME from tbl00_dic_line_dir where NAME in ('上','下','单')";
                        OracleDataReader red = cmd.ExecuteReader();
                        tsLineDir = new Dictionary <string, string>();
                        while (red.Read())
                        {
                            tsLineDir.Add(red["NAME"].ToString(), red["ID"].ToString());
                        }
                        if (!red.IsClosed)
                        {
                            red.Close();
                        }

                        //线别
                        cmd.CommandText = "select ID,Line_Code,Line_Name,PWMIS_CODE from tbl00_dic_line";
                        red             = cmd.ExecuteReader();
                        tsLine          = new Dictionary <string, string>();
                        while (red.Read())
                        {
                            tsLine.Add(red["Line_Name"].ToString(), red["Line_Code"].ToString());
                        }
                        if (!red.IsClosed)
                        {
                            red.Close();
                        }
                        #endregion

                        #region 参数定义
                        strOra = "call p_tbl00_detect_data_hcy";
                        string   strParamters = string.Empty;
                        string   strShuiJia, strShuiJiaLevel, strChuiJia, strChuiJiaLevel;
                        string   strDate, strTime, strExceptionType = string.Empty;
                        string   strLineID, strLineDir, strDetectTrainID, strTrainNum;
                        float    fSpeed = 0F, fMile = 0F;
                        float    fDecisionValue    = 0F; //值
                        int      intExceptionLevel = 0;  //偏差等级
                        int      intDecisionID     = 0;  //评判项目序号
                        DateTime dt = new DateTime();
                        #endregion

                        //世恒数据
                        if (intSType == 0)
                        {
                            for (int i = 1; i < ds.Tables[0].Rows.Count; i++)
                            {
                                #region 遍历数据
                                strShuiJia      = "";
                                strShuiJiaLevel = "";
                                strChuiJia      = "";
                                strChuiJiaLevel = "";
                                strShuiJia      = ds.Tables[0].Rows[i][4].ToString();
                                strShuiJiaLevel = ds.Tables[0].Rows[i][5].ToString();
                                strChuiJia      = ds.Tables[0].Rows[i][6].ToString();
                                strChuiJiaLevel = ds.Tables[0].Rows[i][7].ToString();

                                string strLine = ds.Tables[0].Rows[i][0].ToString();//线名
                                strLineID = SwitchLineID(tsLine, strLine);
                                if (string.IsNullOrEmpty(strLineID))
                                {
                                    continue;
                                }
                                strLineDir = ds.Tables[0].Rows[i][1].ToString();//行别
                                strLineDir = SwitchLineDir(tsLineDir, strLineDir);

                                fMile            = float.Parse(ds.Tables[0].Rows[i][2].ToString()); //里程
                                fSpeed           = float.Parse(ds.Tables[0].Rows[i][3].ToString()); //速度
                                strDate          = ds.Tables[0].Rows[i][8].ToString();              //日期
                                strDate          = strDate.Insert(4, "-");
                                strDate          = strDate.Insert(7, "-");
                                strTime          = ds.Tables[0].Rows[i][9].ToString();//时间
                                strTime          = strTime.Insert(2, ":");
                                strTime          = strTime.Insert(5, ":");
                                strDate          = strDate + " " + strTime;
                                strDetectTrainID = ds.Tables[0].Rows[i][10].ToString(); //机车号
                                strTrainNum      = ds.Tables[0].Rows[i][11].ToString(); //车次
                                //获取
                                dt = DateTime.Parse(strDate);
                                if (dt.Hour >= 16)
                                {
                                    dt = dt.AddDays(1);
                                }

                                //string strGq = ds.Tables[0].Rows[i][12].ToString();//工区;
                                //string strLgq = ds.Tables[0].Rows[i][13].ToString();//领工区;
                                //string strGwdID = ds.Tables[0].Rows[i][14].ToString();//工务段;
                                //string strBureauID = ds.Tables[0].Rows[i][15].ToString();//路局;
                                //strBureauID = SwitchBureau(tsBureau, strBureauID);
                                //strGwdID = SwitchGwd(tsGwd, strGwdID);
                                string strDC = ds.Tables[0].Rows[i][16].ToString() == "假" ? "0" : "1"; //道岔;
                                string strDK = ds.Tables[0].Rows[i][17].ToString() == "假" ? "0" : "1"; //道口;
                                string strQX = ds.Tables[0].Rows[i][18].ToString() == "假" ? "0" : "1"; //曲线;
                                string strQL = ds.Tables[0].Rows[i][19].ToString() == "假" ? "0" : "1"; //桥梁;
                                string strHD = ds.Tables[0].Rows[i][20].ToString() == "假" ? "0" : "1"; //涵洞;
                                string strSD = ds.Tables[0].Rows[i][21].ToString() == "假" ? "0" : "1"; //隧道;
                                string strCX = ds.Tables[0].Rows[i][22].ToString() == "假" ? "0" : "1"; //侧向;
                                string strCL = ds.Tables[0].Rows[i][23].ToString() == "假" ? "0" : "1"; //长链;

                                //(id, impid, stype, linecode, linedir, detectdate, trainnumber, traintype, detecttrain, mile, speed, decisionid, decisionlevel,
                                //decisionvalue, linelabel, bureaucode, pwsectionid, /*pwplantid, pwteamid,*/ dc, dk, qx, ql, hd, sd, cx, cl)
                                #region 导入
                                if (!string.IsNullOrEmpty(strShuiJia.Trim()) && !string.IsNullOrEmpty(strShuiJiaLevel.Trim()))
                                {
                                    intDecisionID     = 303;
                                    fDecisionValue    = float.Parse(strShuiJia);
                                    intExceptionLevel = int.Parse(strShuiJiaLevel);
                                    if (intExceptionLevel < 2)
                                    {
                                    }
                                    else
                                    {
                                        int iValue = -1;
                                        switch (intExceptionLevel)
                                        {
                                        case 2:
                                            iValue = -1;
                                            break;

                                        default:
                                            iValue = 1;
                                            break;
                                        }
                                        strParamters = "(" + intImpID + "," + intSType + ",'" + strLineID + "','" + strLineDir + "','" + strDate +
                                                       "','" + strDetectTrainID + "','','" + strTrainNum + "'," + fMile + "," + fSpeed +
                                                       "," + intDecisionID + "," + intExceptionLevel + "," + fDecisionValue + ",''," +
                                                       "'" + strDC + "','" + strDK + "','" +
                                                       strQX + "','" + strQL + "','" + strHD + "','" + strSD +
                                                       "','" + strCX + "','" + strCL + "',to_date('" + dt.ToString("yyyy-MM-dd") + "','yyyy-MM-dd hh24:mi:ss')," + iValue.ToString() + ")";
                                        cmd.CommandText = strOra + strParamters;
                                        cmd.ExecuteNonQuery();
                                    }
                                }
                                if (!string.IsNullOrEmpty(strChuiJia.Trim()) && !string.IsNullOrEmpty(strChuiJiaLevel.Trim()))
                                {
                                    intDecisionID     = 304;
                                    fDecisionValue    = float.Parse(strChuiJia);
                                    intExceptionLevel = int.Parse(strChuiJiaLevel);
                                    if (intExceptionLevel < 2)
                                    {
                                    }
                                    else
                                    {
                                        int iValue = -1;
                                        switch (intExceptionLevel)
                                        {
                                        case 2:
                                            iValue = -1;
                                            break;

                                        default:
                                            iValue = 1;
                                            break;
                                        }
                                        strParamters = "(" + intImpID + "," + intSType + ",'" + strLineID + "','" + strLineDir + "','" + strDate +
                                                       "','" + strDetectTrainID + "','','" + strTrainNum + "'," + fMile + "," + fSpeed +
                                                       "," + intDecisionID + "," + intExceptionLevel + "," + fDecisionValue + ",''," +
                                                       "'" + strDC + "','" + strDK + "','" + strQX + "','" + strQL +
                                                       "','" + strHD + "','" + strSD + "','" + strCX + "','" +
                                                       strCL + "',to_date('" + dt.ToString("yyyy-MM-dd") + "','yyyy-MM-dd hh24:mi:ss')," + iValue.ToString() + ")";
                                        cmd.CommandText = strOra + strParamters;
                                        cmd.ExecuteNonQuery();
                                    }
                                }
                                #endregion
                                #endregion
                            }
                        }
                        else
                        {
                            //三岭数据
                            for (int i = 2; i < ds.Tables[0].Rows.Count; i++)
                            {
                                #region 遍历数据
                                strShuiJia      = "";
                                strShuiJiaLevel = "";
                                strChuiJia      = "";
                                strChuiJiaLevel = "";
                                //string strGwdID = ds.Tables[0].Rows[i][1].ToString();//工务段;
                                //if (strGwdID.Contains("工务段"))
                                //    strGwdID = SwitchGwd(tsGwd, strGwdID.Substring(strGwdID.Length - 3));
                                //else
                                //    strGwdID = SwitchGwd(tsGwd, strGwdID.Substring(strGwdID.Length - 2));
                                //string strBureauID = "13";
                                string strLine = ds.Tables[0].Rows[i][2].ToString();//线名
                                if (string.IsNullOrEmpty(strLine))
                                {
                                    continue;
                                }
                                if (strLine.Substring(strLine.Length - 1, 1) == "线")
                                {
                                    strLine = strLine.Substring(0, strLine.Length - 1);
                                }
                                strLineID   = SwitchLineID(tsLine, strLine);
                                strLineDir  = ds.Tables[0].Rows[i][3].ToString();                   //行别
                                strLineDir  = SwitchLineDir(tsLineDir, strLineDir.Substring(0, strLine.Length - 1));
                                strTrainNum = ds.Tables[0].Rows[i][5].ToString();                   //车次
                                fMile       = float.Parse(ds.Tables[0].Rows[i][6].ToString());      //里程
                                string strTrainType = ds.Tables[0].Rows[i][7].ToString();           //车型
                                strDetectTrainID = ds.Tables[0].Rows[i][8].ToString();              //机车号
                                fSpeed           = float.Parse(ds.Tables[0].Rows[i][9].ToString()); //速度
                                strShuiJia       = ds.Tables[0].Rows[i][12].ToString();             //水加
                                strShuiJiaLevel  = ds.Tables[0].Rows[i][13].ToString();             //水加等级
                                strChuiJia       = ds.Tables[0].Rows[i][10].ToString();             //垂加
                                strChuiJiaLevel  = ds.Tables[0].Rows[i][11].ToString();             //垂加等级
                                strDate          = ds.Tables[0].Rows[i][14].ToString();             //日期
                                dt = DateTime.Parse(strDate);
                                if (dt.Hour >= 16)
                                {
                                    dt = dt.AddDays(1);
                                }
                                string strLabel = ds.Tables[0].Rows[i][16].ToString();//标记
                                #region 导入
                                if (!string.IsNullOrEmpty(strShuiJia.Trim()) && !string.IsNullOrEmpty(strShuiJiaLevel.Trim()))
                                {
                                    intDecisionID     = 303;
                                    fDecisionValue    = float.Parse(strShuiJia);
                                    intExceptionLevel = int.Parse(strShuiJiaLevel);
                                    if (intExceptionLevel < 2)
                                    {
                                    }
                                    else
                                    {
                                        int iValue = -1;
                                        switch (intExceptionLevel)
                                        {
                                        case 2:
                                            iValue = -1;
                                            break;

                                        default:
                                            iValue = 1;
                                            break;
                                        }
                                        strParamters = "(" + intImpID + "," + intSType + ",'" + strLineID + "','" + strLineDir + "','" + strDate +
                                                       "','" + strDetectTrainID + "','" + strTrainType + "','" + strTrainNum + "'," + fMile + "," + fSpeed +
                                                       "," + intDecisionID + "," + intExceptionLevel + "," +
                                                       fDecisionValue + ",'','','','','','','','','',to_date('" + dt.ToString("yyyy-MM-dd") + "','yyyy-MM-dd hh24:mi:ss')," + iValue.ToString() + ")";
                                        cmd.CommandText = strOra + strParamters;
                                        cmd.ExecuteNonQuery();
                                    }
                                }
                                if (!string.IsNullOrEmpty(strChuiJia.Trim()) && !string.IsNullOrEmpty(strChuiJiaLevel.Trim()))
                                {
                                    intDecisionID     = 304;
                                    fDecisionValue    = float.Parse(strChuiJia);
                                    intExceptionLevel = int.Parse(strChuiJiaLevel);
                                    if (intExceptionLevel < 2)
                                    {
                                    }
                                    else
                                    {
                                        int iValue = -1;
                                        switch (intExceptionLevel)
                                        {
                                        case 2:
                                            iValue = -1;
                                            break;

                                        default:
                                            iValue = 1;
                                            break;
                                        }
                                        strParamters = "(" + intImpID + "," + intSType + ",'" + strLineID + "','" + strLineDir + "','" + strDate +
                                                       "','" + strDetectTrainID + "','" + strTrainType + "','" + strTrainNum + "'," + fMile + "," + fSpeed +
                                                       "," + intDecisionID + "," + intExceptionLevel + "," + fDecisionValue +
                                                       ",'','','','','','','','','',to_date('" + dt.ToString("yyyy-MM-dd") + "','yyyy-MM-dd hh24:mi:ss')," + iValue.ToString() + ")";
                                        cmd.CommandText = strOra + strParamters;
                                        cmd.ExecuteNonQuery();
                                    }
                                }
                                #endregion
                                #endregion
                            }
                        }
                        try
                        {
                            cmd.CommandText = "call P_TBL00_DETECT_HCY_UNIT(" + intImpID + ")";
                            cmd.ExecuteNonQuery();
                        }
                        catch (Exception e)
                        {
                            UtilityDBDJ.CreateErrorLog("导入晃车数据发生错误!" + e.Message.ToString());
                            returnValue = false;
                        }
                        try
                        {
                            cmd.CommandText = "call P_TBL00_DETECT_HCY_ITEMR3(" + intImpID + ")";
                            cmd.ExecuteNonQuery();
                        }
                        catch (Exception e)
                        {
                            UtilityDBDJ.CreateErrorLog("导入晃车数据发生错误!" + e.Message.ToString());
                            returnValue = false;
                        }
                        try
                        {
                            cmd.CommandText = "call p_Tbl00_Dic_Trainnumber(0)";
                            cmd.ExecuteNonQuery();
                        }
                        catch (Exception e)
                        {
                            UtilityDBDJ.CreateErrorLog("导入晃车数据发生错误!" + e.Message.ToString());
                            returnValue = false;
                        }
                    }
                    catch (Exception e)
                    {
                        UtilityDBDJ.CreateErrorLog("导入晃车数据发生错误!" + e.Message.ToString());
                        UtilityDBDJ utility = new UtilityDBDJ();
                        utility.SetHcDataRollback(intImpID);
                        returnValue = false;
                    }
                    finally
                    {
                        if (cn.State != ConnectionState.Closed)
                        {
                            cn.Close();
                        }
                        if (cn != null)
                        {
                            cn.Dispose();
                        }
                    }
                    #endregion
                }
            }
            return(returnValue);

            #endregion
        }
Exemplo n.º 4
0
        public void OperatorStore(OracleCommand cmd, long intImpID, long intRecordID, DataTable dtToBegin, int intFlag)
        {
            try
            {
                #region 执行存储过程体
                if (intFlag == 1)
                {
                    #region 基础台帐与管界速度级
                    this.strOra     = "call p_Tbl00_d_Exception_u_base(" + intImpID + ")";
                    cmd.CommandText = this.strOra;
                    try
                    {
                        cmd.ExecuteNonQuery();
                    }
                    catch (Exception)
                    {
                    }
                    this.strOra     = "call P_TBL00_D_EXCEPTION_U(" + intImpID + ")";
                    cmd.CommandText = this.strOra;
                    try
                    {
                        cmd.ExecuteNonQuery();
                    }
                    catch (Exception)
                    {
                    }
                    #endregion
                }
                else
                {
                    this.strOra     = "call P_TBL00_DETECT_EXCEPTION_Main(" + intImpID + "," + GetToBegin(dtToBegin) + ")";
                    cmd.CommandText = this.strOra;
                    try
                    {
                        cmd.ExecuteNonQuery();
                    }
                    catch (Exception)
                    {
                    }

                    //UtilityDB.CreateErrorLog("开始执行汇总存储过程!");
                    //this.strOra = "call P_TBL00_S_DETECT_E(" + intImpID + ")";
                    //cmd.CommandText = this.strOra;
                    //try
                    //{
                    //    cmd.ExecuteNonQuery();
                    //}
                    //catch (Exception)
                    //{
                    //}
                    //UtilityDB.CreateErrorLog("完成执行汇总存储过程!");

                    UtilityDBDJ.CreateErrorLog("开始执行KM数据更新!");
                    this.strOra     = "call p_Tbl00_Dectect_E_KM(" + intImpID + ")";
                    cmd.CommandText = this.strOra;
                    try
                    {
                        cmd.ExecuteNonQuery();
                    }
                    catch (Exception)
                    {
                    }
                    UtilityDBDJ.CreateErrorLog("完成执行KM数据更新!");
                    //
                    UtilityDBDJ.CreateErrorLog("执行各种情况为空!");
                    this.strOra     = "update tbl02_01pw_exception_gj t set t.valid=0 where t.standard is null and t.batchimpseq=" + intImpID;
                    cmd.CommandText = this.strOra;
                    try
                    {
                        cmd.ExecuteNonQuery();
                    }
                    catch (Exception)
                    {
                    }
                    UtilityDBDJ.CreateErrorLog("执行各种情况为空!");
                    //
                    UtilityDBDJ.CreateErrorLog("开始执行长天数据更新!1");
                    this.strOra     = "call wxjc_dev.static_unit_gj.STATIC_UNIT_EXCEPTION_GJ(" + intImpID + ")";
                    cmd.CommandText = this.strOra;
                    try
                    {
                        cmd.ExecuteNonQuery();
                    }
                    catch (Exception)
                    {
                    }
                    UtilityDBDJ.CreateErrorLog("完成执行长天数据更新!1");
                    UtilityDBDJ.CreateErrorLog("开始执行长天数据更新!2");
                    this.strOra     = "call wxjc_dev.static_unit_gj.STATIC_UNIT_TQI_GJ(" + intImpID + ")";
                    cmd.CommandText = this.strOra;
                    try
                    {
                        cmd.ExecuteNonQuery();
                    }
                    catch (Exception)
                    {
                    }
                    UtilityDBDJ.CreateErrorLog("完成执行长天数据更新!2");
                    UtilityDBDJ.CreateErrorLog("开始执行长天数据更新!3");
                    this.strOra     = "call wxjc_dev.static_unit_gj.STATIC_UNIT_KM_GJ(" + intImpID + ")";
                    cmd.CommandText = this.strOra;
                    try
                    {
                        cmd.ExecuteNonQuery();
                    }
                    catch (Exception)
                    {
                    }
                    UtilityDBDJ.CreateErrorLog("完成执行长天数据更新!3");
                    UtilityDBDJ.CreateErrorLog("开始执行长天数据更新!4");
                    this.strOra     = "call wxjc_dev.SUMM_DEPARTMENT_GJ.INDEX_TYPE_0_GJ(" + intImpID + ")";
                    cmd.CommandText = this.strOra;
                    try
                    {
                        cmd.ExecuteNonQuery();
                    }
                    catch (Exception)
                    {
                    }
                    UtilityDBDJ.CreateErrorLog("完成执行长天数据更新!4");
                    UtilityDBDJ.CreateErrorLog("开始执行长天数据更新!5");
                    this.strOra     = "call wxjc_dev.SUMM_DEPARTMENT_GJ.INDEX_TYPE_2_GJ(" + intImpID + ")";
                    cmd.CommandText = this.strOra;
                    try
                    {
                        cmd.ExecuteNonQuery();
                    }
                    catch (Exception)
                    {
                    }
                    UtilityDBDJ.CreateErrorLog("完成执行长天数据更新!5");
                    UtilityDBDJ.CreateErrorLog("开始执行长天数据更新!6");
                    this.strOra     = "call wxjc_dev.SUMM_DEPARTMENT_GJ.INDEX_TYPE_11_GJ(" + intImpID + ")";
                    cmd.CommandText = this.strOra;
                    try
                    {
                        cmd.ExecuteNonQuery();
                    }
                    catch (Exception)
                    {
                    }
                    UtilityDBDJ.CreateErrorLog("完成执行长天数据更新!6");
                    UtilityDBDJ.CreateErrorLog("开始执行长天数据更新!7");
                    this.strOra     = "call wxjc_dev.SUMM_DEPARTMENT_GJ.INDEX_TYPE_3_GJ(" + intImpID + ")";
                    cmd.CommandText = this.strOra;
                    try
                    {
                        cmd.ExecuteNonQuery();
                    }
                    catch (Exception)
                    {
                    }
                    UtilityDBDJ.CreateErrorLog("完成执行长天数据更新!7");
                    UtilityDBDJ.CreateErrorLog("开始执行长天数据更新!8");
                    this.strOra     = "call wxjc_dev.SUMM_DEPARTMENT_GJ.INDEX_TYPE_13_GJ(" + intImpID + ")";
                    cmd.CommandText = this.strOra;
                    try
                    {
                        cmd.ExecuteNonQuery();
                    }
                    catch (Exception)
                    {
                    }
                    UtilityDBDJ.CreateErrorLog("完成执行长天数据更新!8");
                }
                #endregion
            }
            catch
            {
                //throw new Exception(e.Message.ToString());
            }
        }
Exemplo n.º 5
0
 public void OperatorStore(OracleCommand cmd, long intImpID, long intRecordID, DataTable dtToBegin, int intFlag)
 {
     try
     {
         #region 执行存储过程体
         if (intFlag == 1)
         {
             #region 基础台帐与管界速度级
             this.strOra     = "call P_TBL00_D_EXCEPTION_U(" + intImpID + ")";
             cmd.CommandText = this.strOra;
             try
             {
                 cmd.ExecuteNonQuery();
             }
             catch (Exception)
             {
             }
             #endregion
         }
         else
         {
             this.strOra     = "call P_TBL00_DETECT_EXCEPTION_Main(" + intImpID + "," + GetToBegin(dtToBegin) + ")";
             cmd.CommandText = this.strOra;
             try
             {
                 cmd.ExecuteNonQuery();
             }
             catch (Exception)
             {
             }
             //
             UtilityDBDJ.CreateErrorLog("执行各种情况为空!");
             this.strOra     = "update tbl02_01pw_exception_gj t set t.valid=0 where t.standard is null and t.batchimpseq=" + intImpID;
             cmd.CommandText = this.strOra;
             try
             {
                 cmd.ExecuteNonQuery();
             }
             catch (Exception)
             {
             }
             UtilityDBDJ.CreateErrorLog("执行各种情况为空!");
             UtilityDBDJ.CreateErrorLog("执行各种情况为空!");
             this.strOra     = "update tbl02_06pw_tqi t set t.valid=0 where t.standard is null and t.batchimpseq=" + intImpID;
             cmd.CommandText = this.strOra;
             try
             {
                 cmd.ExecuteNonQuery();
             }
             catch (Exception)
             {
             }
             UtilityDBDJ.CreateErrorLog("执行各种情况为空!");
             UtilityDBDJ.CreateErrorLog("开始执行长天数据更新!1");
             this.strOra     = "call wxjc_dev.STATIC_TKY(" + intImpID + ")";
             cmd.CommandText = this.strOra;
             try
             {
                 cmd.ExecuteNonQuery();
             }
             catch (Exception)
             {
             }
             UtilityDBDJ.CreateErrorLog("完成执行长天数据更新!1");
         }
         #endregion
     }
     catch
     {
         //throw new Exception(e.Message.ToString());
     }
 }