Пример #1
0
        public List <FPDetail> GetFPDetailListByFPZL(DateTime dateTime_0, DateTime dateTime_1, string string_1)
        {
            List <FPDetail> list = new List <FPDetail>();

            try
            {
                Dictionary <string, object> parameter = new Dictionary <string, object>();
                DateTime time = Convert.ToDateTime(dateTime_1.AddDays(1.0).ToShortDateString());
                parameter.Add("QSRQ", dateTime_0);
                parameter.Add("ZZRQ", time);
                parameter.Add("FPZL", string_1);
                foreach (object obj2 in this.ibaseDAO_0.querySQL("aisino.fwkp.bsgl.selectXxfpByDateFPZL", parameter))
                {
                    FPDetail item = this.method_2(obj2);
                    list.Add(item);
                }
            }
            catch (BaseException exception)
            {
                ExceptionHandler.HandleError(exception);
            }
            catch (Exception)
            {
            }
            return(list);
        }
Пример #2
0
        public List <FPDetail> GetFPDetailListByFPZL(int int_0, string string_1, string string_2)
        {
            List <FPDetail>             list      = new List <FPDetail>();
            Dictionary <string, object> parameter = new Dictionary <string, object>();

            parameter.Add("XFSH", string_1);
            parameter.Add("SSYF", int_0);
            parameter.Add("FPZL", string_2);
            try
            {
                foreach (object obj2 in this.ibaseDAO_0.querySQL("aisino.fwkp.bsgl.selectXxfpByMonthFPZL", parameter))
                {
                    FPDetail item = this.method_2(obj2);
                    if (!string.IsNullOrEmpty(item.SIGN))
                    {
                        list.Add(item);
                    }
                }
            }
            catch (BaseException exception)
            {
                ExceptionHandler.HandleError(exception);
            }
            catch (Exception)
            {
            }
            return(list);
        }
Пример #3
0
        private List <FPDetail> method_3(DataTable dataTable_0)
        {
            List <FPDetail> list = new List <FPDetail>();

            if (dataTable_0 != null)
            {
                try
                {
                    for (int i = 0; i < dataTable_0.Rows.Count; i++)
                    {
                        FPDetail item = new FPDetail {
                            FPType = (FPType)Enum.Parse(typeof(FPType), dataTable_0.Rows[i]["FPZL"].ToString(), true),
                            FPDM   = dataTable_0.Rows[i]["FPDM"].ToString(),
                            FPHM   = this.method_9(dataTable_0.Rows[i]["FPHM"]),
                            KPRQ   = this.method_12(dataTable_0.Rows[i]["KPRQ"]),
                            GFSH   = dataTable_0.Rows[i]["GFSH"].ToString(),
                            GFMC   = dataTable_0.Rows[i]["GFMC"].ToString(),
                            GFDZDH = dataTable_0.Rows[i]["GFDZDH"].ToString(),
                            GFYHZH = dataTable_0.Rows[i]["GFYHZH"].ToString(),
                            XFSH   = dataTable_0.Rows[i]["XFSH"].ToString(),
                            XFMC   = dataTable_0.Rows[i]["XFMC"].ToString(),
                            XFDZDH = dataTable_0.Rows[i]["XFDZDH"].ToString(),
                            XFYHZH = dataTable_0.Rows[i]["XFYHZH"].ToString(),
                            HJJE   = this.method_11(dataTable_0.Rows[i]["HJJE"])
                        };
                        if (string.IsNullOrEmpty(dataTable_0.Rows[i]["SLV"].ToString()))
                        {
                            item.SLV = 99.01f;
                        }
                        else
                        {
                            item.SLV = this.method_10(dataTable_0.Rows[i]["SLV"]);
                        }
                        item.HJSE   = this.method_11(dataTable_0.Rows[i]["HJSE"]);
                        item.HXM    = dataTable_0.Rows[i]["HXM"].ToString();
                        item.ZFBZ   = this.method_8(dataTable_0.Rows[i]["ZFBZ"]);
                        item.KPR    = dataTable_0.Rows[i]["KPR"].ToString();
                        item.BZ     = dataTable_0.Rows[i]["BZ"].ToString();
                        item.YYSBZ  = dataTable_0.Rows[i]["YYSBZ"].ToString();
                        item.QDBZ   = this.method_8(dataTable_0.Rows[i]["QDBZ"]);
                        item.CM     = dataTable_0.Rows[i]["CM"].ToString();
                        item.TYDH   = dataTable_0.Rows[i]["TYDH"].ToString();
                        item.SCCJMC = dataTable_0.Rows[i]["SCCJMC"].ToString();
                        item.XFDZ   = dataTable_0.Rows[i]["XFDZ"].ToString();
                        item.KHYHMC = dataTable_0.Rows[i]["KHYHMC"].ToString();
                        item.QYD    = dataTable_0.Rows[i]["QYD"].ToString();
                        item.ZHD    = dataTable_0.Rows[i]["ZHD"].ToString();
                        item.XHD    = dataTable_0.Rows[i]["XHD"].ToString();
                        item.JQBH   = dataTable_0.Rows[i]["JQBH"].ToString();
                        item.YYZZH  = dataTable_0.Rows[i]["YYZZH"].ToString();
                        item.MW     = dataTable_0.Rows[i]["MW"].ToString();
                        item.YSHWXX = dataTable_0.Rows[i]["YSHWXX"].ToString();
                        item.HYBM   = dataTable_0.Rows[i]["HYBM"].ToString();
                        item.SKR    = dataTable_0.Rows[i]["SKR"].ToString();
                        item.FHR    = dataTable_0.Rows[i]["FHR"].ToString();
                        item.XSBM   = dataTable_0.Rows[i]["XSBM"].ToString();
                        item.XFDH   = dataTable_0.Rows[i]["XFDH"].ToString();
                        item.KHYHZH = dataTable_0.Rows[i]["KHYHZH"].ToString();
                        item.MDD    = dataTable_0.Rows[i]["MDD"].ToString();
                        item.JYM    = dataTable_0.Rows[i]["JYM"].ToString();
                        item.SIGN   = dataTable_0.Rows[i]["SIGN"].ToString();
                        item.ZFRQ   = this.method_12(dataTable_0.Rows[i]["ZFRQ"]);
                        item.WSPZHM = dataTable_0.Rows[i]["WSPZHM"].ToString();
                        item.HZTZDH = dataTable_0.Rows[i]["HZTZDH"].ToString();
                        item.LZDMHM = dataTable_0.Rows[i]["LZDMHM"].ToString();
                        item.XSDJBH = dataTable_0.Rows[i]["XSDJBH"].ToString();
                        item.BMBBBH = dataTable_0.Rows[i]["BMBBBH"].ToString();
                        if (dataTable_0.Rows[i]["FPZL"].ToString() == "j")
                        {
                            item.SPBM = dataTable_0.Rows[i]["ZYSPMC"].ToString();
                            string str2 = dataTable_0.Rows[i]["SPSM_BM"].ToString();
                            if (str2.IndexOf("#%") > -1)
                            {
                                item.QYZBM   = str2.Substring(0, str2.IndexOf("#%"));
                                item.ZZSTSGL = str2.Substring(str2.IndexOf("#%") + 2);
                            }
                            else
                            {
                                item.QYZBM   = "";
                                item.ZZSTSGL = "";
                            }
                            string str3 = dataTable_0.Rows[i]["SKR"].ToString();
                            if (str3.IndexOf("#%") > -1)
                            {
                                item.SFYH  = str3.Substring(0, str3.IndexOf("#%"));
                                item.LSLBS = str3.Substring(str3.IndexOf("#%") + 2);
                            }
                            else
                            {
                                item.SFYH  = "";
                                item.LSLBS = "";
                            }
                        }
                        list.Add(item);
                    }
                }
                catch (Exception exception)
                {
                    throw exception;
                }
            }
            return(list);
        }
Пример #4
0
        private FPDetail method_2(object object_0)
        {
            FPDetail detail = new FPDetail();
            Dictionary <string, object> dictionary = object_0 as Dictionary <string, object>;

            if (dictionary != null)
            {
                try
                {
                    detail.FPType = (FPType)Enum.Parse(typeof(FPType), dictionary["FPZL"].ToString(), true);
                    detail.FPDM   = dictionary["FPDM"].ToString();
                    detail.FPHM   = this.method_9(dictionary["FPHM"]);
                    detail.KPRQ   = this.method_12(dictionary["KPRQ"]);
                    detail.GFSH   = dictionary["GFSH"].ToString();
                    detail.GFMC   = dictionary["GFMC"].ToString();
                    detail.GFDZDH = dictionary["GFDZDH"].ToString();
                    detail.GFYHZH = dictionary["GFYHZH"].ToString();
                    detail.XFSH   = dictionary["XFSH"].ToString();
                    detail.XFMC   = dictionary["XFMC"].ToString();
                    detail.XFDZDH = dictionary["XFDZDH"].ToString();
                    detail.XFYHZH = dictionary["XFYHZH"].ToString();
                    detail.HJJE   = this.method_11(dictionary["HJJE"]);
                    if (string.IsNullOrEmpty(dictionary["SLV"].ToString()))
                    {
                        detail.SLV = 99.01f;
                    }
                    else
                    {
                        detail.SLV = this.method_10(dictionary["SLV"]);
                    }
                    detail.HJSE   = this.method_11(dictionary["HJSE"]);
                    detail.HXM    = dictionary["HXM"].ToString();
                    detail.ZFBZ   = this.method_8(dictionary["ZFBZ"]);
                    detail.KPR    = dictionary["KPR"].ToString();
                    detail.BZ     = dictionary["BZ"].ToString();
                    detail.YYSBZ  = dictionary["YYSBZ"].ToString();
                    detail.QDBZ   = this.method_8(dictionary["QDBZ"]);
                    detail.CM     = dictionary["CM"].ToString();
                    detail.TYDH   = dictionary["TYDH"].ToString();
                    detail.SCCJMC = dictionary["SCCJMC"].ToString();
                    detail.XFDZ   = dictionary["XFDZ"].ToString();
                    detail.KHYHMC = dictionary["KHYHMC"].ToString();
                    detail.QYD    = dictionary["QYD"].ToString();
                    detail.ZHD    = dictionary["ZHD"].ToString();
                    detail.XHD    = dictionary["XHD"].ToString();
                    detail.JQBH   = dictionary["JQBH"].ToString();
                    detail.YYZZH  = dictionary["YYZZH"].ToString();
                    detail.MW     = dictionary["MW"].ToString();
                    detail.YSHWXX = dictionary["YSHWXX"].ToString();
                    detail.HYBM   = dictionary["HYBM"].ToString();
                    detail.SKR    = dictionary["SKR"].ToString();
                    detail.FHR    = dictionary["FHR"].ToString();
                    detail.XSBM   = dictionary["XSBM"].ToString();
                    detail.XFDH   = dictionary["XFDH"].ToString();
                    detail.KHYHZH = dictionary["KHYHZH"].ToString();
                    detail.MDD    = dictionary["MDD"].ToString();
                    detail.JYM    = dictionary["JYM"].ToString();
                    detail.SIGN   = dictionary["SIGN"].ToString();
                    detail.ZFRQ   = this.method_12(dictionary["ZFRQ"]);
                    detail.WSPZHM = dictionary["WSPZHM"].ToString();
                    detail.HZTZDH = dictionary["HZTZDH"].ToString();
                    detail.LZDMHM = dictionary["LZDMHM"].ToString();
                    detail.XSDJBH = dictionary["XSDJBH"].ToString();
                    detail.BMBBBH = dictionary["BMBBBH"].ToString();
                }
                catch (Exception exception)
                {
                    throw exception;
                }
            }
            return(detail);
        }