protected string select(string sql)
{
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathBase).ExecuteTable(sql);
var ret = new Leo.Data.Table(dt).ToArray();
return(Leo.Json.JsonConvert.SerializeObject(ret));
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
protected void Page_Load(object sender, EventArgs e)
{
var userCode = Request.Params["userCode"];
//userCode = "111";
var sql = string.Format("select * from TB_HMW_CYGN where userid='{0}'", userCode);
var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
string[] arry = new string[1];
arry[0] = "false";
dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sql);
Json = Request.QueryString.Get("callback") + "(" + JsonConvert.SerializeObject(arry) + ")";
return;
}
sql = string.Format("select cygn from TB_HMW_CYGN where userid='{0}'", userCode);
dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sql);
var arrys = new Leo.Data.Table(dt).ToArray();
if (dt.Rows.Count == 0)
{
sql = string.Format("insert into tb_hmw_cygn (userid) values ('{0}')", userCode);
dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMas).ExecuteTable(sql);
}
Json = Request.QueryString.Get("callback") + "(" + JsonConvert.SerializeObject(arrys) + ")";
}
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);
}
}
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);
}
}
protected void Button1_Click1(object sender, EventArgs e)
{
var sql = string.Format("SELECT CON_IMAGE.CONTAINER_NO,vessel.sign,sship.CHI_VESSEL+'/'+sship.VOYAGE as voyage,CON_IMAGE.work_date,sship.berthno,code_port.port_cha,CON_IMAGE.blno FROM CON_IMAGE LEFT JOIN SSHIP on sship.ship_id = CON_IMAGE.ship_id LEFT JOIN vessel on sship.v_id = vessel.vessel_id LEFT JOIN code_port on CON_IMAGE.code_unload_port = code_port.code_port where container_no = '{0}' and inoutport = 1 order by work_date desc", con_no.Text);
var dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(sql);
var ret = new Leo.Data.Table(dt).ToArray();
Json = Leo.Json.JsonConvert.SerializeObject(ret);
}
protected void Page_Load(object sender, EventArgs e)
{
var sql = "SELECT * FROM view_new_remaintons where not worktime_begin is null and worktime_end is null and goods='件杂货' ";
var dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(sql);
var ret = new Leo.Data.Table(dt).ToArray();
Json = Leo.Json.JsonConvert.SerializeObject(ret);
}
protected void Page_Load(object sender, EventArgs e)
{
var tel = Request["tel"];
var sql = string.Format(
"select RID,taskno,RELATE_NO from V_CONSIGN_VEHICLE_QUICK where state_mark<'9'and driverphone='{0}'", tel);
var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
var array = new Leo.Data.Table(dt).ToArray();
Json = Leo.Json.JsonConvert.SerializeObject(array);
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string strMessage = Request.Params["message"];
var strW = strMessage.Split(' ');
string strVehicleNum = strW[0];
string strMinRow = strW[1];
string strMaxRow = strW[2];
//strCardNum = "600675";
string strSql = string.Empty;
strSql =
string.Format(@"select count(consign) as sum
from BalanceCenter..vw_Metages
where truck like '{0}%' and datediff(day,finishtime,getdate())<=7",
strVehicleNum);
var dt0 = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathBc).ExecuteTable(strSql);
if (dt0.Rows.Count <= 0)
{
var arry0 = 0;
Json = JsonConvert.SerializeObject(arry0);
return;
}
strSql =
string.Format(@"select top {2} consign,finishtime,Ticket,Truck,Amount,weight2,weight1,(weight2-weight1) weight,operator2,balance2
from (select TOP {1} consign,finishtime,Ticket,Truck,Amount,weight2,weight1,(weight2-weight1) weight,operator2,balance2
from BalanceCenter..vw_Metages
where truck like '{0}%' and datediff(day,finishtime,getdate())<=7 order by finishtime asc)a
order by finishtime desc",
strVehicleNum, Convert.ToInt32(dt0.Rows[0]["sum"]) - Convert.ToInt32(strMinRow) + 1, Convert.ToInt32(strMaxRow) - Convert.ToInt32(strMinRow) + 1);
var dt1 = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathBc).ExecuteTable(strSql);
if (dt1.Rows.Count <= 0)
{
var arry0 = 0;
Json = JsonConvert.SerializeObject(arry0);
return;
}
var arry1 = new Leo.Data.Table(dt1).ToArray();
Json = JsonConvert.SerializeObject(arry1);
}
catch (Exception)
{
return;
}
}
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);
}
}
