示例#1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                //焦炭行情
                IBaseService service = ServiceFactory.getService(15);
                var          dt      = service.executeForDataTable();
                var          arry0   = new Leo.Data.Table(dt).ToArray();
                //有色矿资讯
                service = ServiceFactory.getService(16);
                dt      = service.executeForDataTable();
                var arry1 = new Leo.Data.Table(dt).ToArray();
                //有色矿供求
                service = ServiceFactory.getService(17);
                dt      = service.executeForDataTable();
                var arry2 = new Leo.Data.Table(dt).ToArray();

                var arrys = new Array[3];
                arrys[0] = arry0;
                arrys[1] = arry1;
                arrys[2] = arry2;

                Json = Request.QueryString.Get("callback") + "(" + JsonConvert.SerializeObject(arrys) + ")";
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(C6_Trade3), ex);
            }
        }
示例#2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                var userCode = Request.Params["userCode"];
                //userCode = "227";
                //获取货代ID
                IBaseService service = ServiceFactory.getService(54);
                service.setParams(new String[] { userCode });
                var    dt         = service.executeForDataTable();
                var    arryId     = new Leo.Data.Table(dt).ToArray();
                var    clientCode = arryId.GetValue(0) as string[];
                string Code_HD    = clientCode[0];

                //我的费用结算
                service = ServiceFactory.getService(58);
                service.setParams(new String[] { Code_HD });
                dt = service.executeForDataTable();
                var arry0 = new Leo.Data.Table(dt).ToArray();

                var arrys = new Array[1];
                arrys[0] = arry0;

                Json = Request.QueryString.Get("callback") + "(" + JsonConvert.SerializeObject(arrys) + ")";
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(wdhyw3), ex);
            }
        }
示例#3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                string sql =
                    string.Format(@"select a.username,a.vehiclenum,a.vehiclelen,a.vehicletype,a.tons,b.mdd_province,b.mdd_city,to_char(b.releasetime,'YYYY-MM-DD HH24:MI:SS'),b.sfd_province,b.sfd_city 
                                    from TB_SPH_USER_AUTH a,TB_SPH_VEHICLE_EMPTY b  
                                    where b.mark_repeal='{0}' and a.code_user=b.code_user and a.roletype='{1}' and rownum<='{2}' 
                                    order by b.releasetime desc",
                                  "0", "1", "50");
                var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathWlxgx).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }

                var arrys = new Leo.Data.Table(dt).ToArray();
                Json = JsonConvert.SerializeObject(arrys);
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(OnlineVehicles), ex);
            }
        }
示例#4
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                //仓储资讯
                IBaseService service = ServiceFactory.getService(22);
                var          dt      = service.executeForDataTable();
                var          arry0   = new Leo.Data.Table(dt).ToArray();
                //园区仓储
                service = ServiceFactory.getService(23);
                dt      = service.executeForDataTable();
                var arry1 = new Leo.Data.Table(dt).ToArray();
                //待储货源
                service = ServiceFactory.getService(24);
                dt      = service.executeForDataTable();
                var arry2 = new Leo.Data.Table(dt).ToArray();
                //来港确报
                service = ServiceFactory.getService(25);
                dt      = service.executeForDataTable();
                var arry3 = new Leo.Data.Table(dt).ToArray();

                var arrys = new Array[4];
                arrys[0] = arry0;
                arrys[1] = arry1;
                arrys[2] = arry2;
                arrys[3] = arry3;

                Json = Request.QueryString.Get("callback") + "(" + JsonConvert.SerializeObject(arrys) + ")";
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(C2_Ship), ex);
            }
        }
示例#5
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                //公路资讯
                IBaseService service = ServiceFactory.getService(0);
                var          dt      = service.executeForDataTable();
                var          arry0   = new Leo.Data.Table(dt).ToArray();
                //已放行车辆
                service = ServiceFactory.getService(1);
                dt      = service.executeForDataTable();
                var arry1 = new Leo.Data.Table(dt).ToArray();
                //网上车源
                service = ServiceFactory.getService(2);
                dt      = service.executeForDataTable();
                var arry2 = new Leo.Data.Table(dt).ToArray();
                //司机信息
                service = ServiceFactory.getService(3);
                dt      = service.executeForDataTable();
                var arry3 = new Leo.Data.Table(dt).ToArray();

                var arrys = new Array[4];
                arrys[0] = arry0;
                arrys[1] = arry1;
                arrys[2] = arry2;
                arrys[3] = arry3;
                Json     = Request.QueryString.Get("callback") + "(" + JsonConvert.SerializeObject(arrys) + ")";
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(C4_Highway), ex);
            }
        }
示例#6
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                //铁路资讯
                IBaseService service = ServiceFactory.getService(36);
                var          dt      = service.executeForDataTable();
                var          arry0   = new Leo.Data.Table(dt).ToArray();
                //来港火车确保
                service = ServiceFactory.getService(37);
                dt      = service.executeForDataTable();
                var arry1 = new Leo.Data.Table(dt).ToArray();
                //码头卸车计划
                service = ServiceFactory.getService(38);
                dt      = service.executeForDataTable();
                var arry2 = new Leo.Data.Table(dt).ToArray();
                //码头装车计划
                service = ServiceFactory.getService(39);
                dt      = service.executeForDataTable();
                var arry3 = new Leo.Data.Table(dt).ToArray();

                var arrys = new Array[4];
                arrys[0] = arry0;
                arrys[1] = arry1;
                arrys[2] = arry2;
                arrys[3] = arry3;

                Json = Request.QueryString.Get("callback") + "(" + JsonConvert.SerializeObject(arrys) + ")";
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(C3_Railway), ex);
            }
        }
示例#7
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                var message  = Request.Params["message"];
                var str      = message.Split(' ');
                var sqlId    = str[0];
                var userCode = str[1];
                //获取船代ID
                IBaseService service = ServiceFactory.getService(54);
                service.setParams(new String[] { userCode });
                var    dt         = service.executeForDataTable();
                var    arryId     = new Leo.Data.Table(dt).ToArray();
                var    clientCode = arryId.GetValue(0) as string[];
                string Code_HD    = clientCode[0];

                var rownum = "360";

                service = ServiceFactory.getService(Convert.ToInt16(sqlId));
                service.setParams(new String[] { Code_HD, rownum });
                dt = service.executeForDataTable();
                var arry = new Leo.Data.Table(dt).ToArray();

                Json = Request.QueryString.Get("callback") + "(" + JsonConvert.SerializeObject(arry) + ")";
                //Json = JsonConvert.SerializeObject(arry);
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(More_Table_yewushixiang), ex);
            }
        }
示例#8
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                var userId = Request.Params["userId"];

                if (userId == null)
                {
                    Json = " 为空!";
                    return;
                }

                var sql = string.Format("select PHONE,MOBILE,EMAIL from tb_sys_userinfo t where t.CODE_USER='******'", userId);
                var dt  = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathIports).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    Json = 0 + "," + 0 + "," + 0;
                    return;
                }
                else
                {
                    Json = dt.Rows[0]["PHONE"].ToString() + "," + dt.Rows[0]["MOBILE"].ToString() + "," + dt.Rows[0]["EMAIL"].ToString();
                }
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(GetPersonDetailData), ex);
                Json = "Error";
            }
        }
示例#9
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                //var sqlId = Request.Params["sqlId"];
                var rownum = "360";

                //灌河国际确报船
                IBaseService service = ServiceFactory.getService(7);
                service.setParams(new String[] { rownum });
                var dt    = service.executeForDataTable();
                var arry0 = new Leo.Data.Table(dt).ToArray();
                //新云台确报船
                service = ServiceFactory.getService(8);
                service.setParams(new String[] { rownum });
                dt = service.executeForDataTable();
                var arry1 = new Leo.Data.Table(dt).ToArray();

                var arrys = new Array[2];
                arrys[0] = arry0;
                arrys[1] = arry1;

                Json = Request.QueryString.Get("callback") + "(" + JsonConvert.SerializeObject(arrys) + ")";
                //Json = JsonConvert.SerializeObject(arry);
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(More_Table_neiheboweichuan), ex);
            }
        }
示例#10
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                //矿石专区
                IBaseService service = ServiceFactory.getService(146);
                var          dt      = service.executeForDataTable();
                var          arry0   = new Leo.Data.Table(dt).ToArray();
                //煤炭专区
                service = ServiceFactory.getService(147);
                dt      = service.executeForDataTable();
                var arry1 = new Leo.Data.Table(dt).ToArray();

                var arrys = new Array[2];
                arrys[0] = arry0;
                arrys[1] = arry1;

                //Json = Request.QueryString.Get("callback") + "(" + JsonConvert.SerializeObject(arrys) + ")";

                Json = JsonConvert.SerializeObject(arrys);
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(index4), ex);
            }
        }
示例#11
0
        protected void Page_Load(object sender, EventArgs e)
        {
            var bindId = Request.Params["BindId"];

            //bindId = "369949";

            try
            {
                var strSql =
                    string.Format(@"select spmc,sl,ddzt,to_char(cjsj, 'yyyy/mm/dd hh24:mi:ss') as cjsj 
                                    from BO_TX_DDMX 
                                    where cgdid='{0}'
                                    order by cjsj desc",
                                  bindId);
                var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathAws).ExecuteTable(strSql);
                if (dt.Rows.Count <= 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }

                var arrays = new Leo.Data.Table(dt).ToArray();
                Json = Request.QueryString.Get("callback") + "(" + JsonConvert.SerializeObject(arrays) + ")";
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(GetPurchasingOrderDetail), ex);
            }
        }
示例#12
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                var arry0 = new Leo.Data.Table(ServiceFactory.getService(133).executeForDataTable()).ToArray();  //本地新闻
                var arry1 = new Leo.Data.Table(ServiceFactory.getService(138).executeForDataTable()).ToArray();  //海运新闻
                var arry2 = new Leo.Data.Table(ServiceFactory.getService(134).executeForDataTable()).ToArray();  //经济发展
                var arry3 = new Leo.Data.Table(ServiceFactory.getService(137).executeForDataTable()).ToArray();  //招商引资
                var arry4 = new Leo.Data.Table(ServiceFactory.getService(135).executeForDataTable()).ToArray();  //物流贸易
                var arry5 = new Leo.Data.Table(ServiceFactory.getService(136).executeForDataTable()).ToArray();  //文化活动

                var arrys = new Array[6];
                arrys[0] = arry0;
                arrys[1] = arry1;
                arrys[2] = arry2;
                arrys[3] = arry3;
                arrys[4] = arry4;
                arrys[5] = arry5;

                Json = Request.QueryString.Get("callback") + "(" + JsonConvert.SerializeObject(arrys) + ")";
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(lygnews), ex);
            }
        }
示例#13
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                var message = Request.Params["message"];
                var str     = message.Split(' ');
                var tableId = str[0];
                var dataId  = str[1];

                //数据项
                var arry0 = TableItemTool.GetTableItemSet(Convert.ToInt16(tableId));
                //数据
                IBaseService service = ServiceFactory.getService(Convert.ToInt16(tableId) + 150);
                service.setParams(new String[] { dataId });
                var dt    = service.executeForDataTable();
                var arry1 = new Leo.Data.Table(dt).ToArray();

                var arrys = new Array[2];
                arrys[0] = arry0;
                arrys[1] = arry1;

                //Json = Request.QueryString.Get("callback") + "(" + JsonConvert.SerializeObject(arrys) + ")";
                Json = JsonConvert.SerializeObject(arrys);
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(Detail_Table), ex);
            }
        }
示例#14
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                var message  = Request.Params["message"];
                var str      = message.ToString().Split(' ');
                var userCode = str[0];
                var minRow   = str[1];
                var maxRow   = str[2];
                //var minRow = "1";
                //var maxRow = "15";

                var sql =
                    string.Format(
                        "select CODE_CLIENT_HD,CODE_CLIENT_CD,CODE_DEPARTMENT from VW_IPT_USER where code_user ={0}", userCode);
                var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = "Error";
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var Code_CD = dt.Rows[0]["CODE_CLIENT_CD"] as string;
                //Code_CD = "9";

                sql =
                    string.Format(
                        "select count(p_id) as sum from ywcplan");
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathBases).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }

                sql =
                    string.Format(
                        "select p_id,cbdl,chi_vessel,dqbw,bwwz,pc,pilotage  from(select * from (select p_id,cbdl,chi_vessel,dqbw,bwwz,pc,pilotage,plandate from ywcplan order by PLANDATE asc) where rownum<='{0}' order by PLANDATE desc) where rownum<='{1}'",
                        Convert.ToInt32(dt.Rows[0]["sum"]) - Convert.ToInt32(minRow) + 1, Convert.ToInt32(maxRow) - Convert.ToInt32(minRow) + 1);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathBases).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var arrys = new Leo.Data.Table(dt).ToArray();
                Json = JsonConvert.SerializeObject(arrys);
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(More_Table_boweichuanbo), ex);
            }
        }
示例#15
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                var message  = Request.Params["message"];
                var str      = message.ToString().Split(' ');
                var userCode = str[0];
                var taskNo   = str[1];
                var minRow   = str[2];
                var maxRow   = str[3];

                var sql =
                    string.Format(
                        "select CODE_COMPANY from vw_ipt_user t where t.code_user={0}", userCode);
                var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = "Error";
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var companyCode = dt.Rows[0]["CODE_COMPANY"] as string;

                sql =
                    string.Format(
                        "select count(id) as sum  from V_CONSIGN_VEHICLE_XLQ_PASS where CODE_DEPARTMENT ='{0}' and CGNO like '%{1}%'", companyCode, taskNo);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }

                sql =
                    string.Format(
                        "select ID,TASKNO,CARGO,VEHICLE,DRIVERNAME,DRIVERPHONE,VESSEL,PREPTIME,SUBMITERNAME,SUBMITTIME,to_char(AUDITTIME,'yy-mm-dd') from(select * from (select ID,TASKNO,CARGO,VEHICLE,DRIVERNAME,DRIVERPHONE,VESSEL,PREPTIME,SUBMITERNAME,SUBMITTIME,AUDITTIME from V_CONSIGN_VEHICLE_XLQ_PASS where CODE_DEPARTMENT ='{0}' and CGNO like '%{1}%' order by AUDITTIME asc) where rownum<='{2}' order by AUDITTIME desc) where rownum<='{3}'",
                        //ID,TASKNO,CARGO,VEHICLE,DRIVERNAME,DRIVERPHONE,VESSEL,PREPTIME,SUBMITERNAME,SUBMITTIME,AUDITTIME
                        //ID,任务号,货名,车号,司机,联系手机,船名,预到时间,申报人,申报时间,放行时间
                        companyCode, taskNo, Convert.ToInt32(dt.Rows[0]["sum"]) - Convert.ToInt32(minRow) + 1, Convert.ToInt32(maxRow) - Convert.ToInt32(minRow) + 1);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var arrys = new Leo.Data.Table(dt).ToArray();
                Json = JsonConvert.SerializeObject(arrys);
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(VehicleDeclaration), ex);
            }
        }
示例#16
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                var message  = Request.Params["message"];
                var str      = message.ToString().Split(' ');
                var userCode = str[0];
                var minRow   = str[1];
                var maxRow   = str[2];
                //var minRow = "1";
                //var maxRow = "15";

                var sql =
                    string.Format(
                        "select CODE_CLIENT_HD,CODE_CLIENT_CD,CODE_DEPARTMENT from VW_IPT_USER where code_user ={0}", userCode);
                var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = "Error";
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var Code_CD = dt.Rows[0]["CODE_CLIENT_CD"] as string;
                //Code_CD = "9";

                sql =
                    string.Format(
                        "select  count(ship_id) as sum from view_sship_tan where agent = '{0}' and ship_statu=2 or ship_statu=4 or ship_statu=5 or ship_statu=3 or ship_statu=6", Code_CD);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathBases).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }

                sql =
                    string.Format(
                        "select ship_id,name,chi_vessel,BERTHNO,BERTH_POSITION,DepartMent,SHIPSTATUS,dqyd,BerTH_time from(select * from (select ship_id,name,chi_vessel,BERTHNO,BERTH_POSITION,DepartMent,SHIPSTATUS,dqyd,BerTH_time from view_sship_tan where agent = '{0}' and ship_statu=2 or ship_statu=4 or ship_statu=5 or ship_statu=3 or ship_statu=6 order by BerTH_time asc) where rownum<='{1}' order by BerTH_time desc) where rownum<='{2}'",
                        Code_CD, Convert.ToInt32(dt.Rows[0]["sum"]) - Convert.ToInt32(minRow) + 1, Convert.ToInt32(maxRow) - Convert.ToInt32(minRow) + 1);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathBases).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var arrys = new Leo.Data.Table(dt).ToArray();
                Json = JsonConvert.SerializeObject(arrys);
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(More_Table_boweichuanbo), ex);
            }
        }
示例#17
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                var message      = Request.Params["message"];
                var str          = message.ToString().Split(' ');
                var companyCode  = str[0];
                var userCode     = str[1];
                var completeMark = str[2];
                var minRow       = str[3];
                var maxRow       = str[4];;

                var sql =
                    string.Format(
                        "select CODE_CLIENT_HD from vw_ipt_user t where t.code_user={0}", userCode);
                var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = "Error";
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var clientCode = dt.Rows[0]["CODE_CLIENT_HD"] as string;

                sql =
                    string.Format(
                        "select count(code_client) as sum  from  vw_web_consign_query where code_department='{0}' and code_client='{1}' and  complete_mark = '{2}'", companyCode, clientCode, completeMark);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }

                sql =
                    string.Format(
                        "select  CGNO,bino,OPERATETYPE,CODE_CLIENT,CLIENT,shipname,code_department,DEPARTMENT,PLANAMOUNT,PLANWEIGHT,PLANVOLUME,to_char( createtime,'yy-MM-dd'),TASKNO,BLNO,sign_mark,sign_mark1,complete_mark,complete_mark1,mark_dc,mark_dc1,mark_hy, mark_hy1 from(select * from (select CGNO,bino,OPERATETYPE,CODE_CLIENT,CLIENT,shipname,code_department,DEPARTMENT,PLANAMOUNT,PLANWEIGHT,PLANVOLUME,CREATETIME,TASKNO,BLNO,sign_mark, case sign_mark when '0' then '' when '1' then '√' end as sign_mark1,complete_mark,case complete_mark when '0' then '' when '1' then '√' end as complete_mark1,mark_dc,case mark_dc when '0' then '' when '1' then '√' end as mark_dc1,mark_hy,case mark_hy when '0' then '' when '1' then '√' end as mark_hy1  from  vw_web_consign_query where code_department='{0}' and code_client='{1}' and  complete_mark = '{2}' order by createtime asc) where rownum<='{3}' order by createtime desc) where rownum<='{4}'",
                        companyCode, clientCode, completeMark, Convert.ToInt16(dt.Rows[0]["sum"]) - Convert.ToInt16(minRow) + 1, Convert.ToInt16(maxRow) - Convert.ToInt16(minRow) + 1);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var arrys = new Leo.Data.Table(dt).ToArray();
                Json = JsonConvert.SerializeObject(arrys);
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(GoodsBill), ex);
            }
        }
示例#18
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                var message  = Request.Params["message"];
                var str      = message.ToString().Split(' ');
                var userCode = str[0];
                var minRow   = str[1];
                var maxRow   = str[2];
                //var minRow = "1";
                //var maxRow = "15";

                var sql =
                    string.Format(
                        "select CODE_CLIENT_HD,CODE_CLIENT_CD,CODE_DEPARTMENT from VW_IPT_USER where code_user ={0}", userCode);
                var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = "Error";
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var Code_D = dt.Rows[0]["CODE_DEPARTMENT"] as string;

                sql =
                    string.Format(
                        "select count(RBNO) as sum from jszx_fp t where CODE_CLIENT='{0}' ", Code_D);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHmw).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }

                sql =
                    string.Format(
                        "SELECT RBNO,to_char(CREATETIME,'yyyy-mm-dd') as CREATETIME,FYLX,RBDISPLAY,TOTAL from(select * from (select RBNO,CREATETIME,FYLX,RBDISPLAY,TOTAL from jszx_fp t where CODE_CLIENT='{0}'  order by CREATETIME asc) where rownum<='{1}' order by CREATETIME desc) where rownum<='{2}'",
                        Code_D, Convert.ToInt32(dt.Rows[0]["sum"]) - Convert.ToInt32(minRow) + 1, Convert.ToInt32(maxRow) - Convert.ToInt32(minRow) + 1);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHmw).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var arrys = new Leo.Data.Table(dt).ToArray();
                Json = JsonConvert.SerializeObject(arrys);
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(More_Table_boweichuanbo), ex);
            }
        }
示例#19
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                var message    = Request.Params["message"];
                var str        = message.ToString().Split(' ');
                var userCode   = str[0];
                var mark_audit = str[1];
                var minRow     = str[2];
                var maxRow     = str[3];

                var sql =
                    string.Format(
                        "select CODE_CLIENT_HD from vw_ipt_user t where t.code_user={0}", userCode);
                var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = "Error";
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var clientCode = dt.Rows[0]["CODE_CLIENT_HD"] as string;

                sql =
                    string.Format(
                        "select count(code_client) as sum from harbor.vw_bc_bconsign where  code_client='{0}' and mark_audit ='{1}'", clientCode, mark_audit);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }


                sql =
                    string.Format(
                        "select bcno,chi_vessel,voyage,jobtype,department,from_port,to_port, mark_audit, to_char( createtime,'yy-MM-dd') from(select * from (select bcno,chi_vessel,voyage,jobtype,department,from_port,to_port,case mark_audit when '1' then '已审核' when '0' then '未审核' end as mark_audit, createtime  from harbor.vw_bc_bconsign where code_client='{0}'  and mark_audit = '{1}' order by createtime asc) where rownum<='{2}' order by createtime desc) where rownum<='{3}'",
                        clientCode, mark_audit, Convert.ToInt16(dt.Rows[0]["sum"]) - Convert.ToInt16(minRow) + 1, Convert.ToInt16(maxRow) - Convert.ToInt16(minRow) + 1);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var arrys = new Leo.Data.Table(dt).ToArray();
                Json = JsonConvert.SerializeObject(arrys);
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(GoodsBill), ex);
            }
        }
示例#20
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                var message      = Request.Params["message"];
                var str          = message.ToString().Split(' ');
                var companyCode  = str[0];
                var userCode     = str[1];
                var completeMark = str[2];
                var minRow       = str[3];
                var maxRow       = str[4];

                var sql =
                    string.Format(
                        "select CODE_CLIENT_HD from vw_ipt_user t where t.code_user={0}", userCode);
                var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = "Error";
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var clientCode = dt.Rows[0]["CODE_CLIENT_HD"] as string;

                sql =
                    string.Format(
                        "select count(code_client) as sum from vw_qyf_goodsbillnet where code_department='{0}' and code_client='{1}' and complete_mark ='{2}'", companyCode, clientCode, completeMark);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }

                sql =
                    string.Format(
                        "select Gbno, Cargo, Pack , Measure, Inout  , Trade  , ShipName , PieceWeight, to_char( createtime,'yy-MM-dd') , Mark , sign,COMPLETE_MARK from(select * from (select Gbno, Cargo, Pack , Measure, Inout  , Trade  , ShipName , PieceWeight, createtime , Mark , case sign_mark when '0' then '' when '1' then '√' end as sign,COMPLETE_MARK from vw_qyf_goodsbillnet where code_department='{0}' and code_client='{1}' and complete_mark ='{2}' order by createtime asc) where rownum<='{3}' order by createtime desc) where rownum<='{4}'",
                        companyCode, clientCode, completeMark, Convert.ToInt16(dt.Rows[0]["sum"]) - Convert.ToInt16(minRow) + 1, Convert.ToInt16(maxRow) - Convert.ToInt16(minRow) + 1);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var arrys = new Leo.Data.Table(dt).ToArray();
                Json = JsonConvert.SerializeObject(arrys);
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(GoodsBill), ex);
            }
        }
示例#21
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                var message = Request.Params["message"];
                var str     = message.ToString().Split(' ');
                //var str1 = str[1].ToString().Split(' ');
                var companyCode = str[0];
                var userCode    = str[1];
                var minRow      = str[2];
                var maxRow      = str[3];

                var sql =
                    string.Format(
                        "select CODE_CLIENT_HD from vw_ipt_user t where t.code_user={0}", userCode);
                var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = "Error";
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var clientCode = dt.Rows[0]["CODE_CLIENT_HD"] as string;

                sql =
                    string.Format(
                        "select count(code_client) as sum from vw_stockin_web where code_department='{0}' and code_client='{1}' ", companyCode, clientCode);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }

                sql =
                    string.Format(
                        "select id,department,OperateType,cargo,inout,amount,weight,pieceweight,to_char( signdate,'yy-MM-dd') from(select * from (select id,department,OperateType,cargo,inout,amount,weight,pieceweight,signdate from vw_stockin_web where code_department='{0}' and code_client='{1}' order by signdate asc) where rownum<='{2}' order by signdate desc) where rownum<='{3}'",
                        companyCode, clientCode, Convert.ToInt16(dt.Rows[0]["sum"]) - Convert.ToInt16(minRow) + 1, Convert.ToInt16(maxRow) - Convert.ToInt16(minRow) + 1);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var arrys = new Leo.Data.Table(dt).ToArray();
                Json = JsonConvert.SerializeObject(arrys);
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(GoodsBill), ex);
            }
        }
示例#22
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                var message  = Request.Params["message"];
                var str      = message.ToString().Split(' ');
                var userCode = str[0];
                var minRow   = str[1];
                var maxRow   = str[2];
                //var minRow = "1";
                //var maxRow = "15";

                var sql =
                    string.Format(
                        "select CODE_CLIENT_HD,CODE_CLIENT_CD,CODE_DEPARTMENT from VW_IPT_USER where code_user ={0}", userCode);
                var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = "Error";
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var Code_HD = dt.Rows[0]["CODE_CLIENT_HD"] as string;

                sql =
                    string.Format(
                        "select count(IVNO) as sum from tb_pro_invoice a,tb_code_department c where a.code_client='{0}' and a.code_department=c.code_department ", Code_HD);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }

                sql =
                    string.Format(
                        "select IVNO,to_char(signdate,'yyyy-mm-dd') signdate,VOYAGE,replace(department,'分公司','') department,total from(select * from (select IVNO,a.signdate,a.VOYAGE,c.department,a.total from tb_pro_invoice a,tb_code_department c where a.code_client='{0}' and a.code_department=c.code_department order by a.signdate asc) where rownum<='{1}' order by signdate desc) where rownum<='{2}'",
                        Code_HD, Convert.ToInt32(dt.Rows[0]["sum"]) - Convert.ToInt32(minRow) + 1, Convert.ToInt32(maxRow) - Convert.ToInt32(minRow) + 1);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var arrys = new Leo.Data.Table(dt).ToArray();
                Json = JsonConvert.SerializeObject(arrys);
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(More_Table_boweichuanbo), ex);
            }
        }
示例#23
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                var message      = Request.Params["message"];
                var str          = message.ToString().Split(' ');
                var userCode     = str[0];
                var completeMark = str[1];
                var minRow       = str[2];
                var maxRow       = str[3];

                var sql =
                    string.Format(
                        "select CODE_CLIENT_HD from vw_ipt_user t where t.code_user={0}", userCode);
                var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = "Error";
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var clientCode = dt.Rows[0]["CODE_CLIENT_HD"] as string;

                sql =
                    string.Format(
                        "select count(CODE_AGENT) as sum from v_consign_plan_xlq where AUDIT_MARK='{0}' and CODE_AGENT='{1}'", completeMark, clientCode);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }

                sql =
                    string.Format(
                        "select plan_no,taskno,GBNO,gbdisplay,plan_amount,PLAN_WEIGHT,PLAN_VEH_NUM,fact_VEH_NUM,balance1,balance2,CLIENT,username,auditorname,CODE_STORAGE,CODE_BOOTH,to_char( OPERTIME,'yy-MM-dd') from(select * from (select plan_no,taskno,GBNO,gbdisplay,plan_amount,PLAN_WEIGHT,PLAN_VEH_NUM,fact_VEH_NUM,balance1,balance2,CLIENT,username,auditorname,CODE_STORAGE,CODE_BOOTH,OPERTIME from v_consign_plan_xlq where AUDIT_MARK='{0}' and CODE_AGENT='{1}' order by OPERTIME asc) where rownum<='{2}' order by OPERTIME desc) where rownum<='{3}'",
                        completeMark, clientCode, Convert.ToInt16(dt.Rows[0]["sum"]) - Convert.ToInt16(minRow) + 1, Convert.ToInt16(maxRow) - Convert.ToInt16(minRow) + 1);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var arrys = new Leo.Data.Table(dt).ToArray();
                Json = JsonConvert.SerializeObject(arrys);
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(NewLandBridgeWorkPlan), ex);
            }
        }
示例#24
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                var number = Request.Params["number"];
                int a      = 0;
                int b      = 0;
                int c      = 0;
                int x      = 0;
                int y      = 0;
                int z      = 0;
                switch (number)
                {
                case "1": a = 59; b = 66; c = 73; x = 87; y = 80; z = 94; break;     //兰州

                case "2": a = 60; b = 67; c = 74; x = 88; y = 81; z = 95; break;     //山西

                case "3": a = 61; b = 68; c = 75; x = 89; y = 82; z = 96; break;     //西安

                case "4": a = 62; b = 69; c = 76; x = 90; y = 83; z = 97; break;     //新疆

                case "5": a = 63; b = 70; c = 77; x = 91; y = 84; z = 98; break;     //郑州

                case "6": a = 64; b = 71; c = 78; x = 92; y = 85; z = 99; break;     //银川

                case "7": a = 65; b = 72; c = 79; x = 93; y = 86; z = 100; break;    //西宁
                }

                //国际煤焦资讯
                var arry0 = new Leo.Data.Table(ServiceFactory.getService(a).executeForDataTable()).ToArray();  //本地新闻
                var arry1 = new Leo.Data.Table(ServiceFactory.getService(b).executeForDataTable()).ToArray();  //经济发展
                var arry2 = new Leo.Data.Table(ServiceFactory.getService(c).executeForDataTable()).ToArray();  //物流贸易
                var arry3 = new Leo.Data.Table(ServiceFactory.getService(x).executeForDataTable()).ToArray();  //招商引资
                var arry4 = new Leo.Data.Table(ServiceFactory.getService(y).executeForDataTable()).ToArray();  //文化活动
                var arry5 = new Leo.Data.Table(ServiceFactory.getService(z).executeForDataTable()).ToArray();  //地方风情


                var arrys = new Array[6];
                arrys[0] = arry0;
                arrys[1] = arry1;
                arrys[2] = arry2;
                arrys[3] = arry3;
                arrys[4] = arry4;
                arrys[5] = arry5;


                Json = Request.QueryString.Get("callback") + "(" + JsonConvert.SerializeObject(arrys) + ")";
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(locnews), ex);
            }
        }
示例#25
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                var message  = Request.Params["message"];
                var str      = message.ToString().Split(' ');
                var userCode = str[0];
                var minRow   = str[1];
                var maxRow   = str[2];

                var sql =
                    string.Format(
                        "select CODE_CLIENT_CD from vw_ipt_user t where t.code_user={0}", userCode);
                var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = "Error";
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var clientCode = dt.Rows[0]["CODE_CLIENT_CD"] as string;
                //clientCode = "9";

                sql =
                    string.Format(
                        "select count(ship_id) as sum  from view_sship_tan where agent='{0}' and SHIP_STATU = 7", clientCode);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathBases).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }

                sql =
                    string.Format(
                        "select ship_id,chi_vessel,to_char( yjdg,'yy-MM-dd'),zhmc,zhsl,xhmc,xhsl,S_declare,shipstatus,ys from(select * from (select ship_id,chi_vessel,yjdg,zhmc,zhsl,xhmc,xhsl,S_declare,shipstatus,ys from view_sship_tan where  agent='{0}' and (SHIP_STATU = 7) order by S_declare asc) where rownum<='{1}' order by S_declare desc) where rownum<='{2}'",
                        clientCode, Convert.ToInt16(dt.Rows[0]["sum"]) - Convert.ToInt16(minRow) + 1, Convert.ToInt16(maxRow) - Convert.ToInt16(minRow) + 1);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathBases).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var arrys = new Leo.Data.Table(dt).ToArray();
                Json = JsonConvert.SerializeObject(arrys);
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(ForeShip), ex);
            }
        }
示例#26
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                var message  = Request.Params["message"];
                var str      = message.ToString().Split(' ');
                var userCode = str[0];
                var minRow   = str[1];
                var maxRow   = str[2];

                var sql =
                    string.Format(
                        "select CODE_CLIENT_CD from vw_ipt_user t where t.code_user={0}", userCode);
                var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = "Error";
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var clientCode = dt.Rows[0]["CODE_CLIENT_CD"] as string;
                //clientCode = "9";
                sql =
                    string.Format(
                        "select count(agent) as sum from ddmis.viewtxgpinfo where agent = '{0}' ", clientCode);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }

                sql =
                    string.Format(
                        "select id,chi_vessel,to_char( sta_time,'yy-MM-dd'),end_time,fht,sht,fzs,money,INVOICENUM, name,fkdw from(select * from (select id,chi_vessel,sta_time,end_time,fht,sht,fzs,money,INVOICENUM, name,fkdw from ddmis.viewtxgpinfo where agent = '{0}'  order by sta_time asc) where rownum<='{1}' order by sta_time desc) where rownum<='{2}'",
                        clientCode, Convert.ToInt32(dt.Rows[0]["sum"]) - Convert.ToInt32(minRow) + 1, Convert.ToInt32(maxRow) - Convert.ToInt32(minRow) + 1);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var arrys = new Leo.Data.Table(dt).ToArray();
                Json = JsonConvert.SerializeObject(arrys);
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(PilotageFee), ex);
            }
        }
示例#27
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                var message  = Request.Params["message"];
                var str      = message.ToString().Split(' ');
                var userCode = str[0];
                var minRow   = str[1];
                var maxRow   = str[2];

                var sql =
                    string.Format(
                        "select CODE_CLIENT_CD from vw_ipt_user t where t.code_user={0}", userCode);
                var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = "Error";
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var clientCode = dt.Rows[0]["CODE_CLIENT_CD"] as string;
                //clientCode = "9";
                sql =
                    string.Format(
                        "select count(viewworkbill.agent) as sum from inhual.viewworkbill,inhual.invoice  where viewworkbill.sid=invoice.sid and viewworkbill.agent = '{0}'", clientCode);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }

                sql =
                    string.Format(
                        "select  invoicenum,chi_vessel,ton_net,fcode,amount,to_char( invoicedate,'yy-MM-dd'),fk,fkdjh,fkdw from(select * from (select viewworkbill.CHI_VESSEL,viewworkbill.FCODE,invoice.invoicenum,ton_net,amount,invoicedate,invoice.fkdw,invoice.sid,case when invoice.fk='0' then '否' when invoice.fk='1' then '是' end as fk,case when invoice.fkdjh='00000' then  '  ' else invoice.fkdjh end as fkdjh from inhual.viewworkbill,inhual.invoice  where viewworkbill.sid=invoice.sid and viewworkbill.agent = '{0}' order by invoicedate ASC ) where rownum<='{1}' order by invoicedate desc) where rownum<='{2}'",
                        clientCode, Convert.ToInt32(dt.Rows[0]["sum"]) - Convert.ToInt32(minRow) + 1, Convert.ToInt32(maxRow) - Convert.ToInt32(minRow) + 1);
                dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sql);
                if (dt.Rows.Count == 0)
                {
                    var arry = 0;
                    Json = JsonConvert.SerializeObject(arry);
                    return;
                }
                var arrys = new Leo.Data.Table(dt).ToArray();
                Json = JsonConvert.SerializeObject(arrys);
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(PilotageFee), ex);
            }
        }
示例#28
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                var number = Request.Params["number"];
                //number = "1";
                int a = 0;
                int b = 0;
                int c = 0;
                int d = 0;
                switch (number)
                {
                case "0": a = 101; b = 109; c = 117; d = 125; break;     //韩国航线

                case "1": a = 102; b = 110; c = 118; d = 126; break;     //日本航线

                case "2": a = 103; b = 111; c = 119; d = 127; break;     //内支航线

                case "3": a = 104; b = 112; c = 120; d = 128; break;     //美洲航线

                case "4": a = 105; b = 113; c = 121; d = 129; break;     //欧洲航线

                case "5": a = 106; b = 114; c = 122; d = 130; break;     //中东航线

                case "6": a = 107; b = 115; c = 123; d = 131; break;     //非洲航线

                case "7": a = 108; b = 116; c = 124; d = 132; break;     //东南亚航线
                }

                var arry0 = new Leo.Data.Table(ServiceFactory.getService(a).executeForDataTable()).ToArray();  //整箱船期
                var arry1 = new Leo.Data.Table(ServiceFactory.getService(b).executeForDataTable()).ToArray();  //杂散船期
                var arry2 = new Leo.Data.Table(ServiceFactory.getService(c).executeForDataTable()).ToArray();  //整箱运价
                var arry3 = new Leo.Data.Table(ServiceFactory.getService(d).executeForDataTable()).ToArray();  //杂散运价



                var arrys = new Array[4];
                arrys[0] = arry0;
                arrys[1] = arry1;
                arrys[2] = arry2;
                arrys[3] = arry3;


                //Json = JsonConvert.SerializeObject(arrys);
                Json = Request.QueryString.Get("callback") + "(" + JsonConvert.SerializeObject(arrys) + ")";
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(ships), ex);
            }
        }
示例#29
0
 protected void Page_Load(object sender, EventArgs e)
 {
     try
     {
         var    messId    = Request.Params["messId"];
         string sqlString = string.Format("select substr(message, 1,30),to_char(time,'YYYY-MM-dd HH24:mi:ss'),message from tb_hmw_messagepush where messId={0}", messId);
         var    dt        = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sqlString);
         var    arry      = new Leo.Data.Table(dt).ToArray();
         //Json = Request.QueryString.Get("callback") + "(" + JsonConvert.SerializeObject(arry) + ")";
         Json = JsonConvert.SerializeObject(arry);
     }
     catch (Exception ex)
     {
         LogTool.WriteLog(typeof(Detail_Message), ex);
     }
 }
示例#30
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                var    newsId    = Request.Params["newsId"];
                string sqlString = string.Format("Select TOPIC,SOURCE,POST_TIME,MESSAGE MESSAGE From hmw.NEWS_TOPIC Where id= {0}", newsId);
                var    dt        = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sqlString);
                var    arry      = new Leo.Data.Table(dt).ToArray();

                //Json = Request.QueryString.Get("callback") + "(" + JsonConvert.SerializeObject(arry) + ")";
                Json = JsonConvert.SerializeObject(arry);
            }
            catch (Exception ex)
            {
                LogTool.WriteLog(typeof(Detail_News2), ex);
            }
        }