protected void Page_Load(object sender, EventArgs e) { //委托编码 var gbno = Request.Params["Gbno"]; //货场编码 var codeStorage = Request.Params["CodeStorage"]; //货位编码 var codeBooth = Request.Params["CodeBooth"]; //gbno = "fd4c2cd4d5bb4877ad8308b60e77e16e"; try { if (gbno == null || codeStorage == null || codeBooth == null) { string warning = string.Format("参数Gbno,CodeStorage,CodeBooth不能为nul!举例:http://218.92.115.55/M_ZJG_Dzqp/Service/Stock/GetStockDetail.aspx?Gbno=190c89fd55dc45ee9260cf51a171daef&CodeStorage=20975&CodeBooth=21295"); Json = JsonConvert.SerializeObject(new DicPackage(false, null, warning).DicInfo()); return; } string strFilter = string.Format("where gbno='{0}' and code_storage='{1}' and code_booth='{2}'", gbno, codeStorage, codeBooth); string strSql = string.Format("select * from VW_HS_STOCKDORMANT {0}", strFilter); var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathJHHarbor).ExecuteTable(strSql); if (dt.Rows.Count <= 0) { Json = JsonConvert.SerializeObject(new DicPackage(false, null, "票货编码不存在!").DicInfo()); return; } string[] strNameArray = { "货主", "货物", "航次", "货代", "货场", "重量", "进场日期", "进出口", "内外贸", "唛头", "货位", "包装", "件数", "件重" }; //数组排序连接 string strOrderLink = StringTool.ArrayToString(strNameArray); Dictionary <string, object> info = new Dictionary <string, object>(); info.Add(strNameArray[0], Convert.ToString(dt.Rows[0]["cargoowner"])); info.Add(strNameArray[1], Convert.ToString(dt.Rows[0]["cargo"])); info.Add(strNameArray[2], Convert.ToString(dt.Rows[0]["vgdisplay"])); info.Add(strNameArray[3], Convert.ToString(dt.Rows[0]["client"])); info.Add(strNameArray[4], Convert.ToString(dt.Rows[0]["storage"])); info.Add(strNameArray[5], Convert.ToString(dt.Rows[0]["weight"])); info.Add(strNameArray[6], Convert.ToString(dt.Rows[0]["first_indate"])); info.Add(strNameArray[7], Convert.ToString(dt.Rows[0]["inout"])); info.Add(strNameArray[8], Convert.ToString(dt.Rows[0]["trade"])); info.Add(strNameArray[9], Convert.ToString(dt.Rows[0]["mark"])); info.Add(strNameArray[10], Convert.ToString(dt.Rows[0]["booth"])); info.Add(strNameArray[11], Convert.ToString(dt.Rows[0]["pack"])); info.Add(strNameArray[12], Convert.ToString(dt.Rows[0]["amount"])); info.Add(strNameArray[13], Convert.ToString(dt.Rows[0]["pieceweight"])); info.Add("Order", strOrderLink); Json = JsonConvert.SerializeObject(new DicPackage(true, info, null).DicInfo()); } catch (Exception ex) { Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}:获取数据发生异常。{1}", ex.Source, ex.Message)).DicInfo()); } }
protected void Page_Load(object sender, EventArgs e) { //委托编码 var cgno = Request.Params["Cgno"]; //cgno = "48d31ca70ade41c1a823be7f025ca141"; try { if (cgno == null) { string warning = string.Format("参数Cgno不能为nul!举例:http://218.92.115.55/M_DL_Gwtxc/Service/Consign/GetConsignDetail.aspx?Cgno=cbdde8de4bca4e628856c1a5167b4e32"); Json = JsonConvert.SerializeObject(new DicPackage(false, null, warning).DicInfo()); return; } string strFilter = string.Format("where cgno='{0}'", cgno); string strSql = string.Format("select * from VW_HC_CONSIGN {0}", strFilter); var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathNewHarbor).ExecuteTable(strSql); if (dt.Rows.Count <= 0) { Json = JsonConvert.SerializeObject(new DicPackage(false, null, "委托编码不存在!").DicInfo()); return; } string[] strNameArray = { "货主", "货物", "航次", "作业过程", "委托号", "计划件数", "计划重量", "实际件数", "实际重量", "委托日期", "卸船航次", "装船航次", "进出", "贸别", "包装", "唛头", "公司" }; //数组排序连接 string strOrderLink = StringTool.ArrayToString(strNameArray); Dictionary <string, object> info = new Dictionary <string, object>(); info.Add(strNameArray[0], Convert.ToString(dt.Rows[0]["cargoowner"])); info.Add(strNameArray[1], Convert.ToString(dt.Rows[0]["cargo"])); info.Add(strNameArray[2], Convert.ToString(dt.Rows[0]["voyage"])); info.Add(strNameArray[3], Convert.ToString(dt.Rows[0]["operation"])); info.Add(strNameArray[4], Convert.ToString(dt.Rows[0]["taskno"])); info.Add(strNameArray[5], Convert.ToString(dt.Rows[0]["planamount"])); info.Add(strNameArray[6], Convert.ToString(dt.Rows[0]["planweight"])); info.Add(strNameArray[7], Convert.ToString(dt.Rows[0]["factamount"])); info.Add(strNameArray[8], Convert.ToString(dt.Rows[0]["factweight"])); info.Add(strNameArray[9], Convert.ToString(dt.Rows[0]["signdate"])); info.Add(strNameArray[10], Convert.ToString(dt.Rows[0]["vgno"])); info.Add(strNameArray[11], Convert.ToString(dt.Rows[0]["vgno_last"])); info.Add(strNameArray[12], Convert.ToString(dt.Rows[0]["inout"])); info.Add(strNameArray[13], Convert.ToString(dt.Rows[0]["trade"])); info.Add(strNameArray[14], Convert.ToString(dt.Rows[0]["pack"])); info.Add(strNameArray[15], Convert.ToString(dt.Rows[0]["mark"])); info.Add(strNameArray[16], Convert.ToString(dt.Rows[0]["company"])); info.Add("Order", strOrderLink); Json = JsonConvert.SerializeObject(new DicPackage(true, info, null).DicInfo()); } catch (Exception ex) { Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}:获取数据发生异常。{1}", ex.Source, ex.Message)).DicInfo()); } }
protected void Page_Load(object sender, EventArgs e) { //委托编码 var cgno = Request.Params["Cgno"]; cgno = "14"; try { if (cgno == null) { string warning = string.Format("参数Cgno不能为nul!举例:http://218.92.115.55/M_Lhgl/Service/Plan/GetOperationPlanDetail.aspx?Cgno=14"); Json = JsonConvert.SerializeObject(new DicPackage(false, null, warning).DicInfo()); return; } string strSql = string.Format(@"select * from vw_ps_mission_yardplan1 where cgno='{0}'", cgno); var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathZCHarbor).ExecuteTable(strSql); if (dt.Rows.Count <= 0) { Json = JsonConvert.SerializeObject(new DicPackage(false, null, "委托编码不存在!").DicInfo()); return; } string[] strNameArray = { "货主", "货物", "航次", "货代", "货场", "重量", "进场日期", "进出口", "内外贸", "唛头", "货位", "包装", "件数", "件重" }; //数组排序连接 string strOrderLink = StringTool.ArrayToString(strNameArray); Dictionary <string, object> info = new Dictionary <string, object>(); info.Add(strNameArray[0], Convert.ToString(dt.Rows[0]["cargoowner"])); info.Add(strNameArray[1], Convert.ToString(dt.Rows[0]["cargo"])); info.Add(strNameArray[2], Convert.ToString(dt.Rows[0]["vgdisplay"])); info.Add(strNameArray[3], Convert.ToString(dt.Rows[0]["client"])); info.Add(strNameArray[4], Convert.ToString(dt.Rows[0]["storage"])); info.Add(strNameArray[5], Convert.ToString(dt.Rows[0]["weight"])); info.Add(strNameArray[6], Convert.ToString(dt.Rows[0]["first_indate"])); info.Add(strNameArray[7], Convert.ToString(dt.Rows[0]["inout"])); info.Add(strNameArray[8], Convert.ToString(dt.Rows[0]["trade"])); info.Add(strNameArray[9], Convert.ToString(dt.Rows[0]["mark"])); info.Add(strNameArray[10], Convert.ToString(dt.Rows[0]["booth"])); info.Add(strNameArray[11], Convert.ToString(dt.Rows[0]["pack"])); info.Add(strNameArray[12], Convert.ToString(dt.Rows[0]["amount"])); info.Add(strNameArray[13], Convert.ToString(dt.Rows[0]["pieceweight"])); info.Add("Order", strOrderLink); Json = JsonConvert.SerializeObject(new DicPackage(true, null, null).DicInfo()); } catch (Exception ex) { Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}:获取数据发生异常。{1}", ex.Source, ex.Message)).DicInfo()); } }
protected void Page_Load(object sender, EventArgs e) { //车号 var vehicleNum = Request.Params["VehicleNum"]; try { if (vehicleNum == null) { string warning = string.Format("参数vehicleNum不能为nul!举例:http://218.92.115.55/M_DL_Gwtxc/Service/Vehicle/GetVehicleTransport.aspx?vehicleNum=14"); Json = JsonConvert.SerializeObject(new DicPackage(false, null, warning).DicInfo()); return; } string strSql = string.Format("select CODE_CLIENT,CARGO,VEHICLE,CODE_WORKTEAM,AMOUNT,GATE_RECORD_ID,audittime from(select CODE_CLIENT,CARGO,VEHICLE,CODE_WORKTEAM,AMOUNT,GATE_RECORD_ID,audittime from v_pda_pro_consignvehicle where VEHICLE = '{0}' order by audittime desc ) where ROWNUM <=1", vehicleNum); var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathHarbor).ExecuteTable(strSql); if (dt.Rows.Count <= 0) { Json = JsonConvert.SerializeObject(new DicPackage(false, null, "车号或用户名不存在!").DicInfo()); return; } string[] strNameArray = { "货代", "货物", "车号", "班组", "件数", "记录" }; //数组排序连接 string strOrderLink = StringTool.ArrayToString(strNameArray); Dictionary <string, object> info = new Dictionary <string, object>(); info.Add(strNameArray[0], Convert.ToString(dt.Rows[0]["CODE_CLIENT"])); info.Add(strNameArray[1], Convert.ToString(dt.Rows[0]["CARGO"])); info.Add(strNameArray[2], Convert.ToString(dt.Rows[0]["VEHICLE"])); info.Add(strNameArray[3], Convert.ToString(dt.Rows[0]["CODE_WORKTEAM"])); info.Add(strNameArray[4], Convert.ToString(dt.Rows[0]["AMOUNT"])); info.Add(strNameArray[5], Convert.ToString(dt.Rows[0]["GATE_RECORD_ID"])); info.Add("Order", strOrderLink); Json = JsonConvert.SerializeObject(new DicPackage(false, info, null).DicInfo()); } catch (Exception ex) { Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}:获取数据发生异常。{1}", ex.Source, ex.Message)).DicInfo()); } }
protected void Page_Load(object sender, EventArgs e) { //委托编码 var cgno = Request.Params["Cgno"]; //公司编码 var codeDepartment = Request.Params["CodeDepartment"]; //白夜班 var dayNight = Request.Params["DayNight"]; //班组日期 var teamDate = Request.Params["TeamDate"]; //cgno = "1511099525"; //codeDepartment = "11"; //dayNight = "白班"; //teamDate = "2016-01-08"; try { if (cgno == null || codeDepartment == null || dayNight == null || teamDate == null) { string warning = string.Format("参数Cgno,CodeDepartment,TeamDate不能为null!举例:http://218.92.115.55/M_DL_Gwtxc/Service/Weighing/GetWeighting.aspx?Cgno=0114111611&CodeDepartment=11&DayNight=白班&TeamDate=2015-08-19"); Json = JsonConvert.SerializeObject(new DicPackage(false, null, warning).DicInfo()); return; } // 每日过磅统计。 string VwDailyCount = "select consign,department,departmentname,client,ship,billnumber1,cargo,weight,sum(weight2-weight1) netweight,count(truck) trucknumber from BALANCECENTER..vw_metages "; // 每日过磅统计(累计)。 string VwDailyCount2 = " select consign,sum(weight2-weight1) netweight,count(truck) trucknumber from BALANCECENTER..vw_metages "; //获取班次统计时间 string strSql = string.Format("select DayTime,NightTime from BALANCECENTER..RunConfig where Department = {0}", codeDepartment); var dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathBc).ExecuteTable(strSql); string day = " 06:00"; string night = " 17:00"; if (dt.Rows.Count > 0) { day = StringTool.ToDayNightForSql(dt.Rows[0]["DayTime"].ToString()); night = StringTool.ToDayNightForSql(dt.Rows[0]["NightTime"].ToString()); } //拼接查询条件 string strFilter; if (dayNight == "白班")// { strFilter = string.Format( "department='{0}' and FinishTime is not null and finishtime<'{1}' and finishtime>='{2}' and consign='{3}'", codeDepartment, string.Concat(Convert.ToDateTime(teamDate).ToShortDateString(), night), string.Concat(Convert.ToDateTime(teamDate).ToShortDateString(), day), cgno); } else { strFilter = string.Format( "department='{0}' and FinishTime is not null and ((finishtime>='{1}' and finishtime<='{2}') or (finishtime>='{3}' and finishtime<'{4}')) and consign='{5}'", codeDepartment, string.Concat(Convert.ToDateTime(teamDate).ToShortDateString(), night), string.Concat(Convert.ToDateTime(teamDate).AddDays(1).ToShortDateString(), " 00:00"), string.Concat(Convert.ToDateTime(teamDate).AddDays(1).ToShortDateString(), " 00:00"), string.Concat(Convert.ToDateTime(teamDate).AddDays(1).ToShortDateString(), day), cgno); } strSql = string.Format( "{0} where {1} group by consign,department,departmentname,client,ship,billnumber1,cargo,weight", VwDailyCount, strFilter); var dt0 = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathBc).ExecuteTable(strSql); strSql = string.Format(" {0} where consign='{1}' group by consign ", VwDailyCount2, cgno); var dt1 = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathBc).ExecuteTable(strSql); if (dt1.Rows.Count <= 0) { Json = JsonConvert.SerializeObject(new DicPackage(false, null, "委托号不存在!").DicInfo()); return; } string[] strNameArray = { "委托号", "船名", "委托人", "货种", "计划重量", "当班量", "累计量", "当班车次", "累计车次", "提单号", "公司", "班组日期", "白夜班" }; //数组排序连接 string strOrderLink = StringTool.ArrayToString(strNameArray); Dictionary <string, object> info = new Dictionary <string, object>(); info.Add(strNameArray[0], Convert.ToString(dt0.Rows[0]["consign"])); info.Add(strNameArray[1], Convert.ToString(dt0.Rows[0]["ship"])); info.Add(strNameArray[2], Convert.ToString(dt0.Rows[0]["client"])); info.Add(strNameArray[3], Convert.ToString(dt0.Rows[0]["cargo"])); info.Add(strNameArray[4], Convert.ToString(dt0.Rows[0]["weight"])); info.Add(strNameArray[5], Convert.ToString(dt0.Rows[0]["netweight"])); info.Add(strNameArray[6], Convert.ToString(dt1.Rows[0]["NETWEIGHT"])); info.Add(strNameArray[7], Convert.ToString(dt0.Rows[0]["trucknumber"])); info.Add(strNameArray[8], Convert.ToString(dt1.Rows[0]["TRUCKNUMBER"])); info.Add(strNameArray[9], Convert.ToString(dt0.Rows[0]["billnumber1"])); info.Add(strNameArray[10], Convert.ToString(dt0.Rows[0]["departmentname"])); info.Add(strNameArray[11], teamDate); info.Add(strNameArray[12], dayNight); info.Add("Order", strOrderLink); Json = JsonConvert.SerializeObject(new DicPackage(true, info, null).DicInfo()); } catch (Exception ex) { Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}:获取数据发生异常。{1}", ex.Source, ex.Message)).DicInfo()); } }