예제 #1
0
        /// <summary>
        /// APP账号信息查询
        /// </summary>
        /// <param name="Data_Tag">查询标记,表示是否全部接收数据;0为全部接收,1为接收未上传数据</param>
        /// <param name="Error">错误号</param>
        /// <param name="ErrorMessage">错误信息</param>
        /// <param name="AccountModel">APP账号信息</param>
        public void SelectAccount(int Data_Tag, out int Error, out string ErrorMessage, out List <AccountModel> AccountModel)
        {
            Error        = 0;
            ErrorMessage = "";
            AccountModel = new List <DSTP_DAL.AccountModel>();
            string SQLString = "select Account_ID,Account_Name,Account_Password,Account_Time,Name,TEL,Company,Account_Picture,Account_Permission,Last_Operate_Date,Last_Operate_Type,Account_IsUse from Account ";

            SQLString += " where Account_Permission <> 2 ";
            if (Data_Tag == 1)
            {
                SQLString += " and Sign=1 ";
            }
            else if (Data_Tag == 0)
            {
                SQLString += " and 1=1 ";
            }

            try
            {
                DataTable dt = MySQLHelper.ExecuteDataTable(SQLString);

                if (dt.Rows.Count == 0)
                {
                    Error        = 0;
                    ErrorMessage = "未查询到信息";
                }
                else
                {
                    AccountModel = ModelConvertHelper <AccountModel> .ConvertToModel(dt);

                    Error        = 0;
                    ErrorMessage = "";
                }
            }
            catch (Exception ex)
            {
                Error        = 1;
                ErrorMessage = "数据处理异常,重新尝试";
            }
        }
예제 #2
0
        /// <summary>
        /// 工程日志上传
        /// </summary>
        /// <param name="RTU_No">RTU编号</param>
        /// <param name="Construction_Well_ID">井号</param>
        /// <param name="Start_Date">施工开始时间</param>
        /// <param name="Start_Time">施工时间</param>
        /// <param name="End_Time">施工时间</param>
        /// <param name="Data_Tag">查询标记,表示是否全部接收数据;0为全部接收,1为接收未上传数据</param>
        /// <param name="Error">错误号</param>
        /// <param name="ErrorMessage">错误信息</param>
        /// <param name="ListLog">返回查询到的工程日志数据</param>
        public void SelectProject_Log(int RTU_No, string Construction_Well_ID, DateTime Start_Date, DateTime Start_Time, DateTime End_Time, int Data_Tag, out int Error, out string ErrorMessage, out List <Project_LogModels> ListLog)
        {
            Error        = 0;
            ErrorMessage = "";
            ListLog      = new List <Project_LogModels>();
            //先看看是不是按照工程信息查询工程日志,是则查出工程信息ID,以Start_Date是否为最小日期为标识
            string Project_ID = "";

            if (Start_Date != DateTime.MinValue)
            {
                Project_ID = SelProject_ID(Start_Date, RTU_No, Construction_Well_ID);
            }

            //将Start_Time以及End_Time格式标准化
            if (Start_Time == End_Time && Start_Time == DateTime.MinValue)
            {
                Start_Time = DateTime.MinValue;
                End_Time   = DateTime.MaxValue;
            }
            if (Start_Time == End_Time)
            {
                End_Time = End_Time.AddDays(1);
            }

            string SQLString = "select ";

            SQLString += "Project_Log_ID,Project_ID,Construction_Time,Pressure,Displacement,Displacement_Acc,Slug_Name,Formula,Events,Last_Operate_Type,Last_Operate_Date ";
            SQLString += "from Project_Log where ";
            if (Project_ID != "")
            {
                SQLString += "Project_ID=@Project_ID and ";
            }
            SQLString += "Construction_Time >= @Start_Time and Construction_Time <= @End_Time and ";
            if (Data_Tag == 1)
            {
                SQLString += " Sign=1 ";
            }
            else if (Data_Tag == 0)
            {
                SQLString += " 1=1 ";
            }

            SQLString += " UNION ALL ";

            SQLString += "select ";
            SQLString += "Project_Log_ID,Project_ID,Construction_Time,Pressure,Displacement,Displacement_Acc,Slug_Name,Formula,Events,Last_Operate_Type,Last_Operate_Date ";
            SQLString += "from project_log_history where ";
            if (Project_ID != "")
            {
                SQLString += "Project_ID=@Project_ID and ";
            }
            SQLString += "Construction_Time >= @Start_Time and Construction_Time <= @End_Time and ";
            if (Data_Tag == 1)
            {
                SQLString += " Sign=1 ";
            }
            else if (Data_Tag == 0)
            {
                SQLString += " 1=1 ";
            }
            MySqlParameter[] comParamerer = new MySqlParameter[]
            {
                new MySqlParameter("@Project_ID", Project_ID),
                new MySqlParameter("@Start_Time", Start_Time),
                new MySqlParameter("@End_Time", End_Time)
            };
            try
            {
                DataTable dt = MySQLHelper.ExecuteDataTable(SQLString, comParamerer);

                if (dt.Rows.Count == 0)
                {
                    Error        = 0;
                    ErrorMessage = "未查询到信息";
                }
                else
                {
                    ListLog = ModelConvertHelper <Project_LogModels> .ConvertToModel(dt);

                    Error        = 0;
                    ErrorMessage = "";
                }
            }
            catch (Exception ex)
            {
                Error        = 1;
                ErrorMessage = "数据处理异常,重新尝试";
            }
        }
예제 #3
0
        /// <summary>
        /// RTU图片上传
        /// </summary>
        /// <param name="RTU_No">RTU编号</param>
        /// <param name="Start_Time">检测时间</param>
        /// <param name="End_Time">检测时间</param>
        /// <param name="Data_Tag">查询标记,表示是否全部接收数据;0为全部接收,1为接收未上传数据</param>
        /// <param name="Error">错误号</param>
        /// <param name="ErrorMessage">错误信息</param>
        /// <param name="ListRtuData">返回查询到的RTU图片</param>
        public void SelRtuPic(int RTU_No, DateTime Start_Time, DateTime End_Time, int Data_Tag, out int Error, out string ErrorMessage, out List <RtuPicModel> ListRtuPic)
        {
            Error        = 0;
            ErrorMessage = "";
            ListRtuPic   = new List <RtuPicModel>();

            //先将时间标准化
            if (Start_Time == End_Time && Start_Time == DateTime.MinValue)
            {
                Start_Time = DateTime.MinValue;
                End_Time   = DateTime.MaxValue;
            }
            if (Start_Time == End_Time)
            {
                End_Time = End_Time.AddDays(1);
            }

            string SQLString = "select ";

            SQLString += "RTU_Pic_ID,";
            SQLString += "Pic_Name,";
            SQLString += "RTU_No,";
            SQLString += "RTU_Pic_Address,";
            SQLString += "Detect_Time,";
            SQLString += "Upload_Time ";
            SQLString += "from RTU_Pic where ";
            if (RTU_No != 0)
            {
                SQLString += "RTU_No=@RTU_No and ";
            }
            SQLString += "Detect_Time >= @Start_Time and Detect_Time <= @End_Time and ";
            if (Data_Tag == 1)
            {
                SQLString += " Sign=1 ";
            }
            else if (Data_Tag == 0)
            {
                SQLString += " 1=1 ";
            }

            SQLString += " UNION ALL ";

            SQLString += "select ";
            SQLString += "RTU_Pic_ID,";
            SQLString += "Pic_Name,";
            SQLString += "RTU_No,";
            SQLString += "RTU_Pic_Address,";
            SQLString += "Detect_Time,";
            SQLString += "Upload_Time ";
            SQLString += "from rtu_pic_history where ";


            if (RTU_No != 0)
            {
                SQLString += "RTU_No=@RTU_No and ";
            }
            SQLString += "Detect_Time >= @Start_Time and Detect_Time <= @End_Time and ";
            if (Data_Tag == 1)
            {
                SQLString += " Sign=1 ";
            }
            else if (Data_Tag == 0)
            {
                SQLString += " 1=1 ";
            }
            MySqlParameter[] comParamerer = new MySqlParameter[]
            {
                new MySqlParameter("@RTU_No", RTU_No),
                new MySqlParameter("@Start_Time", Start_Time),
                new MySqlParameter("@End_Time", End_Time)
            };
            try
            {
                DataTable dt = MySQLHelper.ExecuteDataTable(SQLString, comParamerer);

                if (dt.Rows.Count == 0)
                {
                    Error        = 0;
                    ErrorMessage = "未查询到信息";
                }
                else
                {
                    ListRtuPic = ModelConvertHelper <RtuPicModel> .ConvertToModel(dt);

                    Error        = 0;
                    ErrorMessage = "";
                }
            }
            catch (Exception ex)
            {
                Error        = 1;
                ErrorMessage = "数据处理异常,重新尝试";
            }
        }
예제 #4
0
        /// <summary>
        /// 工程信息查询
        /// </summary>
        /// <param name="RTU_No">RTU编号</param>
        /// <param name="Construction_Well_ID">井号</param>
        /// <param name="Start_Time">施工开始时间</param>
        /// <param name="End_Time">施工结束时间</param>
        /// <param name="Data_Tag">查询标记,表示是否全部接收数据;0为全部接收,1为接收未上传数据</param>
        /// <param name="Error">错误号</param>
        /// <param name="ErrorMessage">错误信息</param>
        /// <param name="ProjectModel">返回工程信息数据</param>
        public void SelectProject(int RTU_No, string Construction_Well_ID, DateTime Start_Time, DateTime End_Time, int Data_Tag, out int Error, out string ErrorMessage, out List <ProjectModel> ProjectModel)
        {
            Error        = 0;
            ErrorMessage = "";
            ProjectModel = new List <DSTP_DAL.ProjectModel>();
            string SQLString = "select ";

            SQLString += "Project_ID,Account_ID,Start_Date,";
            SQLString += "Jar_Shape,Jar_Size,Jar_Volume,";
            SQLString += "RTU_No,Construction_Name,Construction_Well_ID,Oil_Factory,Area,Place,Company_Name,";
            SQLString += "Team_Leader_Name,Team_Leader_Tel,Team_Leader_Picture,";
            SQLString += "Team_Worker_Name,Team_Worker_Tel,Team_Worker_Picture,";
            SQLString += "Con_Begin_Pic1,Con_Begin_Pic2,Con_Begin_Pic3,Con_Begin_Pic4,Con_Begin_Pic5,Con_Begin_Pic6,Con_Begin_Pic7,Con_Begin_Pic8,Con_Begin_Pic9,";
            SQLString += "Con_Begin_OilPressure,Con_Begin_CasingPressure,Con_Begin_Dayinflow,Con_Begin_IsSeparate,Con_Begin_SepPresure,";
            SQLString += "End_Date,";
            SQLString += "Con_End_OilPressure,Con_End_CasingPressure,Con_End_Dayinflow,CasPre_Cause,Con_End_Pic1,";
            SQLString += "Last_Operate_Type,Last_Operate_Date ";
            SQLString += "from Project where ";
            if (RTU_No != 0)
            {
                SQLString += "RTU_No=@RTU_No and ";
            }
            if (Construction_Well_ID != "" && Construction_Well_ID != null)
            {
                SQLString += "Construction_Well_ID=@Construction_Well_ID and ";
            }
            if (Start_Time == End_Time && Start_Time == DateTime.MinValue)
            {
                Start_Time = DateTime.MinValue;
                End_Time   = DateTime.MaxValue;
            }
            if (Start_Time == End_Time)
            {
                End_Time = End_Time.AddDays(1);
            }
            SQLString += "Start_Date >= @Start_Time and Start_Date <= @End_Time and ";
            if (Data_Tag == 1)
            {
                SQLString += " Sign=1 ";
            }
            else if (Data_Tag == 0)
            {
                SQLString += " 1=1 ";
            }

            SQLString += " UNION ALL ";

            SQLString += "select ";
            SQLString += "Project_ID,Account_ID,Start_Date,";
            SQLString += "Jar_Shape,Jar_Size,Jar_Volume,";
            SQLString += "RTU_No,Construction_Name,Construction_Well_ID,Oil_Factory,Area,Place,Company_Name,";
            SQLString += "Team_Leader_Name,Team_Leader_Tel,Team_Leader_Picture,";
            SQLString += "Team_Worker_Name,Team_Worker_Tel,Team_Worker_Picture,";
            SQLString += "Con_Begin_Pic1,Con_Begin_Pic2,Con_Begin_Pic3,Con_Begin_Pic4,Con_Begin_Pic5,Con_Begin_Pic6,Con_Begin_Pic7,Con_Begin_Pic8,Con_Begin_Pic9,";
            SQLString += "Con_Begin_OilPressure,Con_Begin_CasingPressure,Con_Begin_Dayinflow,Con_Begin_IsSeparate,Con_Begin_SepPresure,";
            SQLString += "End_Date,";
            SQLString += "Con_End_OilPressure,Con_End_CasingPressure,Con_End_Dayinflow,CasPre_Cause,Con_End_Pic1,";
            SQLString += "Last_Operate_Type,Last_Operate_Date ";
            SQLString += "from project_history where ";
            if (RTU_No != 0)
            {
                SQLString += "RTU_No=@RTU_No and ";
            }
            if (Construction_Well_ID != "" && Construction_Well_ID != null)
            {
                SQLString += "Construction_Well_ID=@Construction_Well_ID and ";
            }
            if (Start_Time == End_Time && Start_Time == DateTime.MinValue)
            {
                Start_Time = DateTime.MinValue;
                End_Time   = DateTime.MaxValue;
            }
            if (Start_Time == End_Time)
            {
                End_Time = End_Time.AddDays(1);
            }
            SQLString += "Start_Date >= @Start_Time and Start_Date <= @End_Time and ";
            if (Data_Tag == 1)
            {
                SQLString += " Sign=1 ";
            }
            else if (Data_Tag == 0)
            {
                SQLString += " 1=1 ";
            }
            MySqlParameter[] comParamerer = new MySqlParameter[]
            {
                new MySqlParameter("@RTU_No", RTU_No),
                new MySqlParameter("@Construction_Well_ID", Construction_Well_ID),
                new MySqlParameter("@Start_Time", Start_Time),
                new MySqlParameter("@End_Time", End_Time)
            };
            try
            {
                DataTable dt = MySQLHelper.ExecuteDataTable(SQLString, comParamerer);

                if (dt.Rows.Count == 0)
                {
                    Error        = 0;
                    ErrorMessage = "未查询到信息";
                }
                else
                {
                    ProjectModel = ModelConvertHelper <ProjectModel> .ConvertToModel(dt);

                    Error        = 0;
                    ErrorMessage = "";
                }
            }
            catch (Exception ex)
            {
                Error        = 1;
                ErrorMessage = "数据处理异常,重新尝试";
            }
        }