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
{
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
{
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
{
//仓储资讯
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(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)
{
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";
}
}
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(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)
{
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 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
{
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 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 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 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 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 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);
}
}
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
{
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 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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}