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());
}
}