예제 #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            //起始时间
            var startTime = Request.Params["StartTime"];
            //终止时间
            var endTime = Request.Params["EndTime"];
            //行ID
            var id = Request.Params["ID"];
            //startTime = "2015-01-01";
            //endTime = "2015-07-09";
            //id = "1";
            int rowNum = Convert.ToInt16(id) - 1;

            Dictionary <string, string> info = new Dictionary <string, string>();

            try
            {
                if (startTime == null || endTime == null || id == null)
                {
                    info.Add("参数StartTime,EndTime,ID不能为nul!", "举例:http://218.92.115.55/wlkg/Service/Supervise/Business/GetFreightBuinessDetail.aspx?StartTime=2015-01-01&EndTime=2015-07-09&ID=1");
                    Json = JsonConvert.SerializeObject(info);
                    return;
                }

                startTime = startTime + " 00:00:00";
                endTime   = endTime + " 00:00:00";

                GetData.AuthHeader head = new GetData.AuthHeader();
                head.UserName = "******";
                head.PassWord = "******";

                GetData.WebServiceSoapClient fileDeal = new GetData.WebServiceSoapClient();
                var dt = fileDeal.GetYWByTime_HYGS(head, startTime, endTime);
                if (dt.Rows.Count == 0)
                {
                    info.Add("IsGet", "NO");
                    info.Add("Message", "ID错误!");
                    Json = JsonConvert.SerializeObject(info);
                    return;
                }

                string[] nameArray = { "抵锚", "靠泊",  "报关",   "海关放行", "报检",  "国检放行", "卸船开始", "卸船结束",
                                       "离港", "完船",  "发运结束", "进出口",  "内外贸", "船名",   "航次",   "提单号", "客户名称","货名",
                                       "部门", "操作员", "时间" };
                //排序字符串
                string order = string.Empty;
                order = nameArray[0] + "+" + nameArray[1] + "+" + nameArray[2] + "+" + nameArray[3] + "+" + nameArray[4] + "+" + nameArray[5] + "+" + nameArray[6] + "+" +
                        nameArray[7] + "+" + nameArray[8] + "+" + nameArray[9] + "+" + nameArray[10] + "+" + nameArray[11] + "+" + nameArray[12] + "+" +
                        nameArray[13] + "+" + nameArray[14] + "+" + nameArray[15] + "+" + nameArray[16] + "+" + nameArray[17] + "+" + nameArray[18] + "+" +
                        nameArray[19] + "+" + nameArray[20];

                const string FINISH = "已完成";
                const string WAIT   = "待办";
                info.Add(nameArray[0], dt.Rows[rowNum]["ArrivedAnchorTime"].ToString() == "1" ? FINISH : WAIT);
                info.Add(nameArray[1], dt.Rows[rowNum]["Berthingtime"].ToString() == "1" ? FINISH : WAIT);
                info.Add(nameArray[2], dt.Rows[rowNum]["CustomClearanceTime"].ToString() == "1" ? FINISH : WAIT);
                info.Add(nameArray[3], dt.Rows[rowNum]["CustomFinalClearanceTime"].ToString() == "1" ? FINISH : WAIT);
                info.Add(nameArray[4], dt.Rows[rowNum]["CIQInspectionTime"].ToString() == "1" ? FINISH : WAIT);
                info.Add(nameArray[5], dt.Rows[rowNum]["CIQInspectionReleaseTime"].ToString() == "1" ? FINISH : WAIT);
                info.Add(nameArray[6], dt.Rows[rowNum]["UnloadingTime_B"].ToString() == "1" ? FINISH : WAIT);
                info.Add(nameArray[7], dt.Rows[rowNum]["UnloadingTime_E"].ToString() == "1" ? FINISH : WAIT);
                info.Add(nameArray[8], dt.Rows[rowNum]["EtaSailingTime"].ToString() == "1" ? FINISH : WAIT);
                info.Add(nameArray[9], dt.Rows[rowNum]["FinshVesselTime"].ToString() == "1" ? FINISH : WAIT);
                info.Add(nameArray[10], dt.Rows[rowNum]["DeliveryEndTime"].ToString() == "1" ? FINISH : WAIT);
                info.Add(nameArray[11], dt.Rows[rowNum]["IEMark"].ToString());
                info.Add(nameArray[12], dt.Rows[rowNum]["TradeType"].ToString());
                info.Add(nameArray[13], dt.Rows[rowNum]["ChiVessel"].ToString());
                info.Add(nameArray[14], dt.Rows[rowNum]["Voyage"].ToString());
                info.Add(nameArray[15], dt.Rows[rowNum]["Blno"].ToString());
                info.Add(nameArray[16], dt.Rows[rowNum]["ClientNameS"].ToString());
                info.Add(nameArray[17], dt.Rows[rowNum]["CargoName"].ToString());
                info.Add(nameArray[18], dt.Rows[rowNum]["DeptName"].ToString());
                info.Add(nameArray[19], dt.Rows[rowNum]["Operator"].ToString());
                info.Add(nameArray[20], dt.Rows[rowNum]["DTime"].ToString());
                info.Add("Order", order);

                Json = JsonConvert.SerializeObject(info);
            }
            catch (Exception ex)
            {
                info.Add("IsGet", "NO");
                info.Add("Message", "服务器异常:" + ex.Message);
                Json = JsonConvert.SerializeObject(info);
            }
        }
예제 #2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            //起始时间
            var startTime = Request.Params["StartTime"];
            //终止时间
            var endTime = Request.Params["EndTime"];
            //startTime = "2015-06-07 00:00:00";
            //endTime = "2015-07-09 00:00:00";

            Dictionary <string, Array> info = new Dictionary <string, Array>();

            try
            {
                if (startTime == null || endTime == null)
                {
                    string[] arry0 = new string[1];
                    arry0[0] = "举例:http://218.92.115.55/wlkg/Service/Supervise/Business/GetShippingBuiness.aspx?StartTime=2015-01-01&EndTime=2015-07-09";
                    info.Add("参数StartTime,EndTime不能为nul!", arry0);
                    Json = JsonConvert.SerializeObject(info);
                    return;
                }

                startTime = startTime + " 00:00:00";
                endTime   = endTime + " 00:00:00";

                GetData.AuthHeader head = new GetData.AuthHeader();
                head.UserName = "******";
                head.PassWord = "******";

                GetData.WebServiceSoapClient fileDeal = new GetData.WebServiceSoapClient();
                var dt = fileDeal.GetYWByTime_CWGS(head, startTime, endTime);
                if (dt.Rows.Count == 0)
                {
                    string[] arry0 = new string[1];
                    arry0[0] = "NO";
                    info.Add("IsGet", arry0);
                    string[] arry1 = new string[1];
                    arry1[0] = "暂无数据!";
                    info.Add("Message", arry1);
                    Json = JsonConvert.SerializeObject(info);
                    return;
                }

                string[,] ary = new string[dt.Rows.Count, 6];
                for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
                {
                    ary[iRow, 0] = (iRow + 1).ToString();
                    ary[iRow, 1] = Convert.ToString(dt.Rows[iRow]["TradeType"]);
                    ary[iRow, 2] = Convert.ToString(dt.Rows[iRow]["ChiVessel"]);
                    ary[iRow, 3] = Convert.ToString(dt.Rows[iRow]["Voyage"]);
                    ary[iRow, 4] = Convert.ToString(dt.Rows[iRow]["Blno"]);
                    ary[iRow, 5] = Convert.ToString(dt.Rows[iRow]["ClientNameS"]);
                }

                string[] arry2 = new string[1];
                arry2[0] = "Yes";
                info.Add("IsGet", arry2);
                info.Add("ShippingBuiness", ary);
                Json = JsonConvert.SerializeObject(info);
            }
            catch (Exception ex)
            {
                string[] arry0 = new string[1];
                arry0[0] = "NO";
                info.Add("IsGet", arry0);
                string[] arry1 = new string[1];
                arry1[0] = "服务器异常:" + ex.Message;
                info.Add("Message", arry1);
                Json = JsonConvert.SerializeObject(info);
            }
        }
예제 #3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            //起始时间
            var startTime = Request.Params["StartTime"];
            //终止时间
            var endTime = Request.Params["EndTime"];
            //行ID
            var id = Request.Params["ID"];
            //startTime = "2015-06-11";
            //endTime = "2015-07-09";
            //id = "1";
            int rowNum = Convert.ToInt16(id) - 1;

            Dictionary <string, string> info = new Dictionary <string, string>();

            try
            {
                if (startTime == null || endTime == null || id == null)
                {
                    info.Add("参数StartTime,EndTime,ID不能为nul!", "举例:http://218.92.115.55/wlkg/Service/Supervise/Finance/GetShippingFinanceDetail.aspx?StartTime=2015-01-01&EndTime=2015-07-09&ID=1");
                    Json = JsonConvert.SerializeObject(info);
                    return;
                }

                startTime = startTime + " 00:00:00";
                endTime   = endTime + " 00:00:00";

                GetData.AuthHeader head = new GetData.AuthHeader();
                head.UserName = "******";
                head.PassWord = "******";

                GetData.WebServiceSoapClient fileDeal = new GetData.WebServiceSoapClient();
                var dt = fileDeal.GetPayReceiveBillByTime_CWGS(head, startTime, endTime);
                if (dt.Rows.Count == 0)
                {
                    info.Add("IsGet", "NO");
                    info.Add("Message", "暂无数据!");
                    Json = JsonConvert.SerializeObject(info);
                    return;
                }

                info.Add("进出口", dt.Rows[rowNum]["IEMark"].ToString());
                info.Add("内外贸", dt.Rows[rowNum]["TradeType"].ToString());
                info.Add("船名", dt.Rows[rowNum]["ChiVessel"].ToString());
                info.Add("航次", dt.Rows[rowNum]["Voyage"].ToString());
                info.Add("提单号", dt.Rows[rowNum]["Blno"].ToString());
                info.Add("客户名称", dt.Rows[rowNum]["ClientNameS"].ToString());
                info.Add("箱型箱量", dt.Rows[rowNum]["CtnNum"].ToString());
                info.Add("应付人民币总额", dt.Rows[rowNum]["PayRMBAmounts"].ToString());
                info.Add("应收人民币总额", dt.Rows[rowNum]["ReceiveRMBAmounts"].ToString());
                info.Add("部门", dt.Rows[rowNum]["DTime"].ToString());
                info.Add("时间", dt.Rows[rowNum]["DeptName"].ToString());

                Json = JsonConvert.SerializeObject(info);
            }
            catch (Exception ex)
            {
                info.Add("IsGet", "NO");
                info.Add("Message", "服务器异常:" + ex.Message);
                Json = JsonConvert.SerializeObject(info);
            }
        }