protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerifyForSys(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
//参数1
string strParam1 = Request.Params["Param1"];
//参数2
string strParam2 = Request.Params["Param2"];
try
{
if (strParam1 == null || strParam2 == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，登陆失败！").DicInfo());
return;
}
string[] strArray = new string[4];
strArray[0] = strParam1;
strArray[1] = strParam2;
strArray[2] = Request.Params["SysName"];
strArray[3] = Request.Params["Sign"];
Json = JsonConvert.SerializeObject(new DicPackage(true, strArray, null).DicInfo());
//string ms = "尊敬的用户，你注册的【速配货司机】失败原因我们已查明并修改，请您再次注册，如有不便敬请谅解！";
//MobileSmsSender.Send("18266265676", ms);
}
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)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
try
{
string strSql =
string.Format(@"select coord,longitude,latitude,voice
from TB_PRO_COORDVOICE
order by createtime desc");
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[,] strArray = new string[dt.Rows.Count, 4];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
strArray[iRow, 0] = dt.Rows[iRow]["coord"].ToString();
strArray[iRow, 1] = dt.Rows[iRow]["longitude"].ToString();
strArray[iRow, 2] = dt.Rows[iRow]["latitude"].ToString();
strArray[iRow, 3] = dt.Rows[iRow]["voice"].ToString();
}
Json = JsonConvert.SerializeObject(new DicPackage(true, strArray, 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)
{
if (!InterfaceTool.IdentityVerify(Request))
{
Json = Result.Failure("身份认证错误");
return;
}
TallyE tallyE = new TallyE();
tallyE.StrShip_Id = Request.Params["Ship_Id"];
tallyE.StrContainer_No = Request.Params["Container_No"];
tallyE.StrBay_No = Request.Params["Bay_No"];
tallyE.StrWork_No = Request.Params["Work_No"];
tallyE.StrTeam_No = Request.Params["Team_No"];
tallyE.StrHoliady_Mark = Request.Params["Holiady_Mark"];
tallyE.StrTime = Request.Params["Time"];
tallyE.StrEndTime = Request.Params["EndTime"];
tallyE.StrNewShip_Id = Request.Params["NewShip_Id"];
tallyE.StrBerth_No = Request.Params["Berth_No"];
tallyE.StrMovedMark = "1";
//strShip_Id = "6887";
//strContainer_No = "185";
if (tallyE.StrShip_Id == null || tallyE.StrContainer_No == null || tallyE.StrBay_No == null || tallyE.StrWork_No == null || tallyE.StrTeam_No == null || tallyE.StrTime == null)
{
Json = Result.Failure("参数错误");
return;
}
Log log = new Log(Request, tallyE);
log.strBehavior = "进口出舱作业";
log.strBehaviorURL = "/Tally/Import/OutCabinOfImport.aspx";
log.strWorkType = "tally_dx";
Json = new Con_Tally(log).Moved_Load_Unload(tallyE);
}
protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
try
{
IInAndOutCoord iStorage = new IInAndOutCoord();
List <List <string> > listArray = new List <List <string> >();
foreach (string strCodeCompany in iStorage.GetCodeCompany())
{
var dt = iStorage.GetInAndOutCoord(strCodeCompany);
if (dt.Rows.Count > 0)
{
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
List <string> list = new List <string>();
list.Add(dt.Rows[iRow]["in_long"].ToString());
list.Add(dt.Rows[iRow]["in_latitude"].ToString());
list.Add(dt.Rows[iRow]["out_long"].ToString());
list.Add(dt.Rows[iRow]["out_latitude"].ToString());
list.Add(dt.Rows[iRow]["code_storage"].ToString().ToUpper());
listArray.Add(list);
}
}
}
Json = JsonConvert.SerializeObject(new DicPackage(false, listArray.ToArray(), 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)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
//用户编码
string strCodeUser = Request.Params["CodeUser"];
try
{
if (strCodeUser == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，修改密码失败！").DicInfo());
return;
}
string strVehicleNum = string.Empty;
string strSql =
string.Format("select * from TB_APP_DDJG_VEHICLE where code_user = '******'", strCodeUser);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathMa).ExecuteTable(strSql);
if (dt.Rows.Count > 0)
{
strVehicleNum = Convert.ToString(dt.Rows[0]["vehiclenum"]);
}
Json = JsonConvert.SerializeObject(new DicPackage(true, strVehicleNum, 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)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
//ID
string strId = Request.Params["Id"];
//strId = "2F400B128F37E20CE053A864016AE20C";
try
{
if (strId == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，删除已关联车辆！").DicInfo());
return;
}
string strSql =
string.Format(@"delete
from TB_SPH_VEHICLE_RELATION_PASSED
where id ='{0}'",
strId);
new Leo.Oracle.DataAccess(RegistryKey.KeyPathWlxgx).ExecuteNonQuery(strSql);
Json = JsonConvert.SerializeObject(new DicPackage(true, 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)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
//用户名
string strAccount = Request.Params["Account"];
//密码
string strPassword = Request.Params["Password"];
AppLog log = new AppLog(Request);
log.strAccount = strAccount;
log.strBehavior = "用户登陆";
log.strBehaviorURL = "/Entrance/Login.aspx";
try
{
if (strAccount == null || strPassword == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，登录失败！").DicInfo());
return;
}
string strSql = null;
strSql = string.Format("select username from tb_app_tally_user where logogram='{0}'", strAccount);
var dt0 = new Leo.Oracle.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(strSql);
if (dt0.Rows.Count >= 0)
{
strSql =
string.Format(@"select user_id,password,serial_nam,work_no from SYSTEM_USER_TABLE
where serial_nam='{0}' and password='******'",
strAccount, strPassword);
}
else
{
strSql =
string.Format(@"select user_id,password,serial_nam,work_no from SYSTEM_USER_TABLE
where serial_nam='{0}' and password='******' and work_no is not null",
strAccount, strPassword);
}
var dt1 = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTallySqlServer).ExecuteTable(strSql);
if (dt1.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "用户名或密码错误！").DicInfo());
return;
}
//string[] strArray = new string[4];
//strArray[0] = Convert.ToString(dt.Rows[0]["user_id"].ToString());
//strArray[1] = Convert.ToString(dt.Rows[0]["serial_nam"].ToString());
//strArray[2] = Convert.ToString(dt.Rows[0]["password"].ToString());
//strArray[3] = Convert.ToString(dt.Rows[0]["work_no"].ToString());
Json = JsonConvert.SerializeObject(new DicPackage(true, dt1.Rows[0]["user_id"].ToString(), null).DicInfo());
log.LogCatalogSuccess();
}
catch (Exception ex)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：获取登录数据发生异常。{1}", ex.Source, ex.Message)).DicInfo());
log.LogCatalogFailure(string.Format("{0}：获取登录数据发生异常。{1}", ex.Source, ex.Message));
}
}
protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
//手机号
string strMobile = Request.Form["Mobile"];
//速记码（Iport登陆账户）
string strLogogram = Request.Form["Logogram"];
//密码1
string strPassword1 = Request.Form["Password1"];
//密码2
string strPassword2 = Request.Form["Password2"];
//用户名称
string strUserName = Request.Form["UserName"];
//公司编码
string strCompanyCode = Request.Form["CompanyCode"];
//部门编码
string strDepartmentCode = Request.Form["DepartmentCode"];
//用户类型编码
string strUserTypeCode = Request.Form["UserTypeCode"];
//员工工号
string strWorkNo = Request.Form["WorkNo"];
//电话
string strPhone = Request.Form["Phone"];
//QQ
string strQQ = Request.Form["QQ"];
//邮箱
string strEmail = Request.Form["Email"];
////手机号
//string strMobile = Request.Params["Mobile"];
////速记码（Iport登陆账户）
//string strLogogram = Request.Params["Logogram"];
////密码1
//string strPassword1 = Request.Params["Password1"];
////密码2
//string strPassword2 = Request.Params["Password2"];
////用户名称
//string strUserName = Request.Params["UserName"];
////公司编码
//string strCompanyCode = Request.Params["CompanyCode"];
////部门编码
//string strDepartmentCode = Request.Params["DepartmentCode"];
////用户类型编码
//string strUserTypeCode = Request.Params["UserTypeCode"];
////员工工号
//string strWorkNo = Request.Params["WorkNo"];
////电话
//string strPhone = Request.Params["Phone"];
////QQ
//string strQQ = Request.Params["QQ"];
////邮箱
//string strEmail = Request.Params["Email"];
strMobile = Format.Trim(strMobile);
strPassword1 = Format.Trim(strPassword1);
strPassword2 = Format.Trim(strPassword2);
strLogogram = Format.Trim(strLogogram);
strUserName = Format.Trim(strUserName);
strPhone = Format.Trim(strPhone);
strQQ = Format.Trim(strQQ);
strEmail = Format.Trim(strEmail);
//strMobile = "18036600293";
//strPassword1 = "123456";
//strPassword2 = "123456";
try
{
//校验注册参数
string[] strParamArray = RegisterParamsTool.GetParams(Request.Params["AppName"]);
if (strParamArray == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，注册失败！").DicInfo());
return;
}
for (int iParam = 0; iParam < strParamArray.Length; iParam++)
{
string strParam = "" + strParamArray[iParam] + "";
if (Request.Params[strParam] == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，注册失败！").DicInfo());
return;
}
}
//注册数据集
RegisterE registerE = new RegisterE();
registerE.strMobile = strMobile;
registerE.strPassword1 = strPassword1;
registerE.strPassword2 = strPassword2;
if (string.IsNullOrWhiteSpace(strLogogram))
{
//生成用户速记码
string strSql =
string.Format("select sq_user_logogram.nextval as num from dual");
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathIport).ExecuteTable(strSql);
strLogogram = "IPORT" + Convert.ToString(dt.Rows[0]["num"]);
}
registerE.strLogogram = strLogogram;
if (string.IsNullOrWhiteSpace(strUserName))
{
registerE.strUserName = strLogogram;
}
else
{
registerE.strUserName = strUserName;
}
if (!string.IsNullOrWhiteSpace(strCompanyCode))
{
registerE.strCompanyCode = strCompanyCode;
}
if (!string.IsNullOrWhiteSpace(strDepartmentCode))
{
registerE.strDepartmentCode = strDepartmentCode;
}
if (!string.IsNullOrWhiteSpace(strUserTypeCode))
{
registerE.strUserTypeCode = strUserTypeCode;
}
if (!string.IsNullOrWhiteSpace(strWorkNo))
{
registerE.strWorkNo = strWorkNo;
}
if (!string.IsNullOrWhiteSpace(strPhone))
{
registerE.strPhone = strPhone;
}
if (!string.IsNullOrWhiteSpace(strQQ))
{
registerE.strQQ = strQQ;
}
if (!string.IsNullOrWhiteSpace(strEmail))
{
registerE.strEmail = strEmail;
}
//注册Iport
IRegister iRegister = new IRegister(registerE);
Json = iRegister.RegisterIportUser();
}
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)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误").DicInfo());
return;
}
//数据起始行
var strStartRow = Request.Params["StartRow"];
//数据结束行
var strEndRow = Request.Params["EndRow"];
//账户
string strAccount = Request.Params["Account"];
try
{
if (strAccount == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，获取我的投诉列表数据失败").DicInfo());
return;
}
//获取我的投诉列表
string strSql =
string.Format(@"select a.id,a.type_mark,c.complain_name,b.department,a.vehicle,a.driverphone,to_char(a.createtime, 'yyyy/mm/dd') as createtime,a.anonymous_mark,a.finish_mark,a.title,a.detail,a.adjust_time,a.deal_time,a.evaluate_time,e.complain_name as complain_name_org,d.department as department_org
from SER_COMPLAIN a
left join HARBOR.V_SYS_DEPART_CONVERT b on a.code_company=b.code_department
left join SER_CODE_COMPLAIN c on a.code_complain=c.code_complain
left join HARBOR.V_SYS_DEPART_CONVERT d on a.code_company_org=d.code_department
left join SER_CODE_COMPLAIN e on a.code_complain_org=e.code_complain
where a.type_mark='0' and a.account='{0}' and a.finish_mark='0'
order by a.createtime desc",
strAccount);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathCGate).ExecuteTable(strSql, Convert.ToInt32(strStartRow), Convert.ToInt32(strEndRow));
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, null).DicInfo());
return;
}
string[,] strArray = new string[dt.Rows.Count, 12];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
strArray[iRow, 0] = Convert.ToString(dt.Rows[iRow]["id"]);
string strType = Convert.ToString(dt.Rows[iRow]["type_mark"]).Equals("0") == true ? "投诉" : "问题";
strArray[iRow, 1] = strType;
string strComplain_Name = Convert.ToString(dt.Rows[iRow]["complain_name_org"]);
string strDepartment = Convert.ToString(dt.Rows[iRow]["department_org"]);
if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["complain_name"])))
{
strComplain_Name = Convert.ToString(dt.Rows[iRow]["complain_name"]);
strDepartment = Convert.ToString(dt.Rows[iRow]["department"]);
}
strArray[iRow, 2] = strComplain_Name;
strArray[iRow, 3] = strDepartment;
strArray[iRow, 4] = Convert.ToString(dt.Rows[iRow]["vehicle"]);
strArray[iRow, 5] = Convert.ToString(dt.Rows[iRow]["driverphone"]);
strArray[iRow, 6] = Convert.ToString(dt.Rows[iRow]["createtime"]);
string strAnonymous = Convert.ToString(dt.Rows[iRow]["anonymous_mark"]).Equals("0") == true ? "" : "匿名";
strArray[iRow, 7] = strAnonymous;
string strState = string.Empty;
if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["evaluate_time"])))
{
strState = "已评价";
}
else if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["deal_time"])))
{
strState = "已解决";
}
else if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["adjust_time"])))
{
strState = "已受理";
}
else
{
strState = "待受理";
}
strArray[iRow, 8] = strState;
strArray[iRow, 9] = Convert.ToString(dt.Rows[iRow]["title"]);
strArray[iRow, 10] = Convert.ToString(dt.Rows[iRow]["detail"]);
}
Json = JsonConvert.SerializeObject(new DicPackage(true, strArray, 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)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
//航次编码
string strShip_Id = Request.Params["Ship_Id"];
//strShip_Id = "2014";
try
{
if (strShip_Id == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "参数错误，获取个统计操作员数据数据失败！").DicInfo());
return;
}
//strShip_Id = string.IsNullOrWhiteSpace(strShip_Id) ? string.Empty : strShip_Id;
string strSql = string.Empty;
string strTallySql = string.Empty;
FullStatisticsE fullStatisticsE = new FullStatisticsE();
strTallySql =
string.Format(@"select distinct(OPER_NAME)
FROM (SELECT I.SIZE_CON,I.FULLOREMPTY,I.UNLOAD_MARK,I.CONTAINER_NO,CASE WHEN T.NAME IS NOT NULL THEN T.NAME ELSE I.USER_NAME END as OPER_NAME
from con_image I LEFT JOIN TALLY_CLERK T ON I.USER_NAME=T.WORK_NO
where I.SHIP_ID='{0}' and MOVED='1' AND I.USER_NAME is not null)
group by size_con,fullorempty,OPER_NAME",
strShip_Id);
strSql =
string.Format(@"select SIZE_CON,FULLOREMPTY,OPER_NAME,count(case when unload_mark='1' then 1 end) operCon
FROM (SELECT I.SIZE_CON,I.FULLOREMPTY,I.UNLOAD_MARK,I.CONTAINER_NO,CASE WHEN T.NAME IS NOT NULL THEN T.NAME ELSE I.USER_NAME END as OPER_NAME
from con_image I LEFT JOIN TALLY_CLERK T ON I.USER_NAME=T.WORK_NO
where I.SHIP_ID='{0}' and MOVED='1')
group by size_con,fullorempty,OPER_NAME",
strShip_Id);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(strTallySql);
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "暂无数据！").DicInfo());
return;
}
List <SingleStatisticsE> singleStatisticsList = new List <SingleStatisticsE>();
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
SingleStatisticsE singleStatisticsE = new SingleStatisticsE();
singleStatisticsE.Name = Convert.ToString(dt.Rows[iRow]["OPER_NAME"]);
singleStatisticsList.Add(singleStatisticsE);
}
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(strSql);
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
string name = Convert.ToString(dt.Rows[iRow]["OPER_NAME"]);
for (int j = 0; j < singleStatisticsList.Count; j++)
{
SingleStatisticsE s = singleStatisticsList[j];
if (s.Name.Equals(name))
{
if (dt.Rows[iRow]["FULLOREMPTY"].Equals("E"))
{
if (dt.Rows[iRow]["SIZE_CON"].Equals("20"))
{
s.E_20 = Convert.ToInt16(dt.Rows[iRow]["OPERCON"]);
}
else if (dt.Rows[iRow]["SIZE_CON"].Equals("40"))
{
s.E_40 = Convert.ToInt16(dt.Rows[iRow]["OPERCON"]);
}
else
{
s.E_other = Convert.ToInt16(dt.Rows[iRow]["OPERCON"]);
}
}
if (dt.Rows[iRow]["FULLOREMPTY"].Equals("F"))
{
if (dt.Rows[iRow]["SIZE_CON"].Equals("20"))
{
s.F_20 = Convert.ToInt16(dt.Rows[iRow]["OPERCON"]);
}
else if (dt.Rows[iRow]["SIZE_CON"].Equals("40"))
{
s.F_40 = Convert.ToInt16(dt.Rows[iRow]["OPERCON"]);
}
else
{
s.F_other = Convert.ToInt16(dt.Rows[iRow]["OPERCON"]);
}
}
}
}
}
Json = JsonConvert.SerializeObject(new DicPackage(true, singleStatisticsList, 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)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
////账号（内部网账号）
//string strAccount = Request.Form["Account"];
////密码
//string strPassword = Request.Form["Password"];
//账号（手机号或Iport账号）
string strAccount = Request.Params["Account"];
//密码
string strPassword = Request.Params["Password"];
AppLog log = new AppLog(Request);
log.strAccount = strAccount;
log.strBehavior = "用户登陆";
log.strBehaviorURL = "/Entrance/Nbw/Login.aspx";
try
{
if (strAccount == null || strPassword == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，登陆失败！").DicInfo());
return;
}
string strSql =
string.Format(@"select id,pwd
from user_info
where username='******'",
strAccount);
//判断用户是否存在
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathNbw).ExecuteTable(strSql);
if (dt.Rows.Count == 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "用户名或密码错误！").DicInfo());
log.LogCatalogFailure("用户名或密码错误！");
return;
}
if (!strPassword.Equals(Convert.ToString(dt.Rows[0]["pwd"])))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "用户名或密码错误！").DicInfo());
log.LogCatalogFailure("用户名或密码错误！");
return;
}
Json = JsonConvert.SerializeObject(new DicPackage(true, Convert.ToString(dt.Rows[0]["id"]), null).DicInfo());
log.LogCatalogSuccess();
}
catch (Exception ex)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：用户登陆数据发生异常。{1}", ex.Source, ex.Message)).DicInfo());
log.LogCatalogFailure(string.Format("{0}：用户登陆数据发生异常。{1}", ex.Source, ex.Message));
}
}
protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
//手机号
string strMobile = Request.Params["Mobile"];
//strMobile = "17710556243";
//strMobile = "18036600293";
AppLog log = new AppLog(Request);
log.strAccount = strMobile;
log.strBehavior = "获取手机验证码";
log.strBehaviorURL = "/Entrance/GetMobileAuthCode.aspx";
try
{
if (strMobile == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，获取验证码失败！").DicInfo());
return;
}
//手机号验证
string strMessage = TokenTool.VerifyMobile(strMobile);
if (strMessage != "ture")
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, strMessage).DicInfo());
return;
}
//生成随机验证码
string strSql =
string.Format("select round(dbms_random.value(100000,1000000)) as authcode from dual");
var dt0 = new Leo.Oracle.DataAccess(RegistryKey.KeyPathHmw).ExecuteTable(strSql);
//if (dt0.Rows.Count <= 0)
//{
// Json = JsonConvert.SerializeObject(new DicPackage(false, null, "网络错误，请稍后再试！").DicInfo());
// return;
//}
//获取应用中文名称
strSql =
string.Format(@"select fullname
from VW_APP_TOKEN
where appname='{0}'",
Request.Params["AppName"]);
var dt1 = new Leo.Oracle.DataAccess(RegistryKey.KeyPathMa).ExecuteTable(strSql);
//if (dt.Rows.Count <= 0)
//{
// Json = JsonConvert.SerializeObject(new DicPackage(false, null, "网络错误，请稍后再试！").DicInfo());
// return;
//}
string paramData = "{\"template\":\"SMS_63320388\"," +
"\"recipients\":[\"" + strMobile + "\"]," +
"\"prefix\":\"连云港港\"," +
"\"parameters\":{\"AUTHCODE\":\"" + Convert.ToString(dt0.Rows[0]["authcode"]) + "\",\"APPNAME\":\"" + "（" + Convert.ToString(dt1.Rows[0]["fullname"]) + "）" + "\"}}";
var result = ALiSmsSender.PostRequest(paramData);
if (result.Item1 == true)
{
//保存动态验证码（MobileCenter）
//string strDynamicIntervalTime = ConfigTool.GetWebConfigKey("DynamicIntervalTime");
//DateTime dynamicBeginTime = DateTime.Now;
//DateTime dynamicEndTime = dynamicBeginTime.AddSeconds(Convert.ToDouble(strDynamicIntervalTime));
strSql =
string.Format(@"insert into TB_APP_MOBILE_AUTHCODE (mobile,dynamic_authcode,dynamic_begintime,dynamic_endtime,un_dynamic_authcode)
values({0},'{1}',sysdate,sysdate+2/24/60,{2})",
strMobile, Identity.RijndaelEncode(Convert.ToString(dt0.Rows[0]["authcode"])), Convert.ToString(dt0.Rows[0]["authcode"]));
new Leo.Oracle.DataAccess(RegistryKey.KeyPathMa).ExecuteNonQuery(strSql);
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "已成功发送，请注意查看！").DicInfo());
log.LogCatalogSuccess();
}
else
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "线路问题，请重新发送").DicInfo());
log.LogCatalogFailure("线路问题，请重新发送1");
}
}
catch (Exception ex)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：获取手机验证码数据发生异常。{1}", ex.Source, ex.Message)).DicInfo());
log.LogCatalogFailure(string.Format("{0}：获取手机验证码数据发生异常。{1}", ex.Source, ex.Message));
}
}
protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误").DicInfo());
return;
}
//数据起始行
var strStartRow = Request.Params["StartRow"];
//数据结束行
var strEndRow = Request.Params["EndRow"];
//账户
string strAccount = Request.Params["Account"];
//strStartRow = "1";
//strEndRow = "15";
//strAccount = "13812347543";
try
{
if (strStartRow == null || strEndRow == null || strAccount == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，获取我的评价列表数据失败").DicInfo());
return;
}
//获取我的评价列表数据
string strSql =
string.Format(@"select t.id,t.veh_attest_no,t.driverphone,t.finish_mark,to_char(t.createtime, 'yyyy/mm/dd') as createtime,t.evaluate_hall,t.evaluate_dock,t.evaluate_gate,t.index_attitude,t.index_audit,t.index_make,t.index_overall,t.hall_time,t.dock_time,t.gate_time
from SER_EVALUATE t where t.account='{0}' and t.finish_mark = '0'
order by t.createtime desc",
strAccount);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathCGate).ExecuteTable(strSql, Convert.ToInt32(strStartRow), Convert.ToInt32(strEndRow));;
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, null).DicInfo());
return;
}
string[,] strArray = new string[dt.Rows.Count, 12];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
strArray[iRow, 0] = Convert.ToString(dt.Rows[iRow]["id"]);
strArray[iRow, 1] = Convert.ToString(dt.Rows[iRow]["veh_attest_no"]);
strArray[iRow, 2] = Convert.ToString(dt.Rows[iRow]["driverphone"]);
string strExplain = string.Empty;
if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["hall_time"])) || !string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["dock_time"])) || !string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["gate_time"])))
{
strExplain = "有说明";
}
strArray[iRow, 3] = strExplain;
strArray[iRow, 4] = Convert.ToString(dt.Rows[iRow]["createtime"]);
strArray[iRow, 5] = Convert.ToString(dt.Rows[iRow]["evaluate_hall"]);
strArray[iRow, 6] = Convert.ToString(dt.Rows[iRow]["evaluate_dock"]);
strArray[iRow, 7] = Convert.ToString(dt.Rows[iRow]["evaluate_gate"]);
strArray[iRow, 8] = GetChineseEvaluate(Convert.ToInt16(dt.Rows[iRow]["index_attitude"]));
strArray[iRow, 9] = GetChineseEvaluate(Convert.ToInt16(dt.Rows[iRow]["index_audit"]));
strArray[iRow, 10] = GetChineseEvaluate(Convert.ToInt16(dt.Rows[iRow]["index_make"]));
strArray[iRow, 11] = GetChineseEvaluate(Convert.ToInt16(dt.Rows[iRow]["index_overall"]));
}
Json = JsonConvert.SerializeObject(new DicPackage(true, strArray, null).DicInfo());
}
catch (Exception ex)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：获取我的评价列表数据发生异常。{1}", ex.Source, ex.Message)).DicInfo());
}
}
protected virtual void OnDeactivateTool(InterfaceTool new_tool)
{
}
protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
//航次编码
string strShip_Id = Request.Params["Ship_Id"];
//进出口编码
string strCodeInOut = Request.Params["CodeInOut"];
//strShip_Id = "2014";
//strCodeInOut = "0";
try
{
if (strShip_Id == null || strCodeInOut == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "参数错误，获取个统计理货员数据失败！").DicInfo());
return;
}
//strShip_Id = string.IsNullOrWhiteSpace(strShip_Id) ? string.Empty : strShip_Id;
//strCodeInOut = string.IsNullOrWhiteSpace(strCodeInOut) ? string.Empty : strCodeInOut;
string strSql = string.Empty;
string strTallySql = string.Empty;
FullStatisticsE fullStatisticsE = new FullStatisticsE();
//进
if (strCodeInOut.Equals("0"))
{
strTallySql =
string.Format(@"select distinct(c.name)
from con_image i left join TALLY_CLERK c on c.work_no = i.work_no
where i.SHIP_ID = '{0}' and i.CODE_UNLOAD_PORT LIKE '%LYG' AND MOVED = '0' AND c.NAME is not null",
strShip_Id);
strSql =
string.Format(@"select SIZE_CON,FULLOREMPTY,c.name,count(case when unload_mark='1' then 1 end) tallyCon
from con_image i left join TALLY_CLERK c on c.work_no=i.work_no
where i.SHIP_ID='{0}' and i.CODE_UNLOAD_PORT LIKE '%LYG' AND MOVED='0'
group by size_con,fullorempty,c.name",
strShip_Id);
}
else
{
strTallySql =
string.Format(@"select distinct(c.name)
from con_image i left join TALLY_CLERK c on c.work_no = i.work_no
where i.SHIP_ID = '{0}' and i.CODE_LOAD_PORT LIKE '%LYG' AND MOVED = '0' AND c.NAME is not null",
strShip_Id);
strSql =
string.Format(@"select SIZE_CON,FULLOREMPTY,c.name,count(case when unload_mark='1' then 1 end) tallyCon
from con_image i left join TALLY_CLERK c on c.work_no=i.work_no
where i.SHIP_ID='{0}' and i.CODE_LOAD_PORT LIKE '%LYG' AND MOVED='0'
group by size_con,fullorempty,c.name",
strShip_Id);
}
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(strTallySql);
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "暂无数据！").DicInfo());
return;
}
List <SingleStatisticsE> singleStatisticsList = new List <SingleStatisticsE>();
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
SingleStatisticsE singleStatisticsE = new SingleStatisticsE();
singleStatisticsE.Name = Convert.ToString(dt.Rows[iRow]["NAME"]);
singleStatisticsList.Add(singleStatisticsE);
}
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(strSql);
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
string name = Convert.ToString(dt.Rows[iRow]["NAME"]);
for (int j = 0; j < singleStatisticsList.Count; j++)
{
SingleStatisticsE s = singleStatisticsList[j];
if (s.Name.Equals(name))
{
if (dt.Rows[iRow]["FULLOREMPTY"].Equals("E"))
{
if (dt.Rows[iRow]["SIZE_CON"].Equals("20"))
{
s.E_20 = Convert.ToInt16(dt.Rows[iRow]["TALLYCON"]);
}
else if (dt.Rows[iRow]["SIZE_CON"].Equals("40"))
{
s.E_40 = Convert.ToInt16(dt.Rows[iRow]["TALLYCON"]);
}
else
{
s.E_other = Convert.ToInt16(dt.Rows[iRow]["TALLYCON"]);
}
}
if (dt.Rows[iRow]["FULLOREMPTY"].Equals("F"))
{
if (dt.Rows[iRow]["SIZE_CON"].Equals("20"))
{
s.F_20 = Convert.ToInt16(dt.Rows[iRow]["TALLYCON"]);
}
else if (dt.Rows[iRow]["SIZE_CON"].Equals("40"))
{
s.F_40 = Convert.ToInt16(dt.Rows[iRow]["TALLYCON"]);
}
else
{
s.F_other = Convert.ToInt16(dt.Rows[iRow]["TALLYCON"]);
}
}
}
}
}
Json = JsonConvert.SerializeObject(new DicPackage(true, singleStatisticsList, 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)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
//手机号
string strMobile = Request.Params["Mobile"];
//strMobile = "18036600293";
//strAppName = "速配货";
try
{
if (strMobile == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，获取验证码失败！").DicInfo());
return;
}
//校验手机号
Json = VerifyMobile(strMobile);
if (!string.IsNullOrWhiteSpace(Json))
{
return;
}
//生成随机验证码
string strSql =
string.Format("select round(dbms_random.value(100000,1000000)) as authcode from dual");
var dt0 = new Leo.Oracle.DataAccess(RegistryKey.KeyPathHmw).ExecuteTable(strSql);
//if (dt0.Rows.Count <= 0)
//{
// Json = JsonConvert.SerializeObject(new DicPackage(false, null, "网络错误，请稍后再试！").DicInfo());
// return;
//}
//获取应用中文名称
strSql =
string.Format(@"select fullname
from VW_APP_TOKEN
where appname='{0}'",
Request.Params["AppName"]);
var dt1 = new Leo.Oracle.DataAccess(RegistryKey.KeyPathMa).ExecuteTable(strSql);
//if (dt.Rows.Count <= 0)
//{
// Json = JsonConvert.SerializeObject(new DicPackage(false, null, "网络错误，请稍后再试！").DicInfo());
// return;
//}
string strMessage =
string.Format("【{0}】您本次获取的随机验证码是：{1}。如非本人使用，敬请忽略本信息。", Convert.ToString(dt1.Rows[0]["fullname"]), Convert.ToString(dt0.Rows[0]["authcode"]));
//发送至短信机
ServiceSendMessage.mobileSoapClient send = new ServiceSendMessage.mobileSoapClient();
bool isSuccess = send.sendmessage(strMobile, strMessage, "短信系统", "短信系统");
if (isSuccess)
{
//保存动态验证码（MobileCenter）
string strDynamicIntervalTime = ConfigTool.GetWebConfigKey("DynamicIntervalTime");
DateTime dynamicBeginTime = DateTime.Now;
DateTime dynamicEndTime = dynamicBeginTime.AddSeconds(Convert.ToDouble(strDynamicIntervalTime));
strSql =
string.Format(@"insert into TB_APP_MOBILE_AUTHCODE (mobile,dynamic_authcode,dynamic_begintime,dynamic_endtime)
values({0},'{1}',to_date('{2}','YYYY-MM-DD HH24:MI:SS'),to_date('{3}','YYYY-MM-DD HH24:MI:SS'))",
strMobile, Identity.RijndaelEncode(Convert.ToString(dt0.Rows[0]["authcode"])), dynamicBeginTime, dynamicEndTime);
new Leo.Oracle.DataAccess(RegistryKey.KeyPathMa).ExecuteNonQuery(strSql);
Json = JsonConvert.SerializeObject(new DicPackage(true, null, null).DicInfo());
}
else
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "线路问题，请直接输入验证码六个1").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)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
//航次编码
string strShip_Id = Request.Params["Ship_Id"];
//贝号
string strBay_Num = Request.Params["Bay_Num"];
//strShip_Id = "600";
//strBay_Num = "01";
try
{
if (strShip_Id == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，获取某航次所有贝船图数据失败！").DicInfo());
return;
}
string strSql =
string.Format(@"select t.SHIP_ID,t.V_ID,t.ENG_VESSEL,t.CHI_VESSEL,t.LOCATION,t.BAY_NUM,t.BAY_COL,t.BAY_ROW,t.SBAYNO,t.TBAYNO,t.JBAYNO,t.USER_CHAR,t.SCREEN_ROW,t.SCREEN_COL,t.JOINT,t.CODE_LOAD_PORT,t.CODE_UNLOAD_PORT,t.CODE_DELIVERY,t.MOVED,t.UNLOAD_MARK,t.WORK_NO,t.DANGER_GRADE,t.DEGREE_SETTING,t.DEGREE_UNIT,t.MIN_DEGREE,t.MAX_DEGREE,t.BAYNO,t.OLDBAYNO,t.CODE_CRANE,t.IMAGE_ID,t.BAYNUM,t.BAYCOL,t.BAYROW,t.CONTAINER_NO,t.SIZE_CON,t.CONTAINER_TYPE,t.CODE_EMPTY,t.WEIGHT,t.WORK_DATE,t.SEALNO,t.MOVED_NAME,t.INOUTMARK,t.TransMark,t.JJR,t.YB,t.NAME
from vcon_bay_detail t
where t.SHIP_ID='{0}' and t.BAY_NUM='{1}'",
strShip_Id, strBay_Num);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "暂无数据！").DicInfo());
return;
}
string[,] strArray = new string[dt.Rows.Count, 46];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
strArray[iRow, 0] = dt.Rows[iRow]["SHIP_ID"].ToString();
strArray[iRow, 1] = dt.Rows[iRow]["V_ID"].ToString();
strArray[iRow, 2] = dt.Rows[iRow]["ENG_VESSEL"].ToString();
strArray[iRow, 3] = dt.Rows[iRow]["CHI_VESSEL"].ToString();
strArray[iRow, 4] = dt.Rows[iRow]["LOCATION"].ToString();
strArray[iRow, 5] = dt.Rows[iRow]["BAY_NUM"].ToString();
strArray[iRow, 6] = dt.Rows[iRow]["BAY_COL"].ToString();
strArray[iRow, 7] = dt.Rows[iRow]["BAY_ROW"].ToString();
strArray[iRow, 8] = dt.Rows[iRow]["SBAYNO"].ToString();
strArray[iRow, 9] = dt.Rows[iRow]["TBAYNO"].ToString();
strArray[iRow, 10] = dt.Rows[iRow]["JBAYNO"].ToString();
strArray[iRow, 11] = dt.Rows[iRow]["USER_CHAR"].ToString();
strArray[iRow, 12] = dt.Rows[iRow]["SCREEN_ROW"].ToString();
strArray[iRow, 13] = dt.Rows[iRow]["SCREEN_COL"].ToString();
strArray[iRow, 14] = dt.Rows[iRow]["JOINT"].ToString();
strArray[iRow, 15] = dt.Rows[iRow]["CODE_LOAD_PORT"].ToString();
strArray[iRow, 16] = dt.Rows[iRow]["CODE_UNLOAD_PORT"].ToString();
strArray[iRow, 17] = dt.Rows[iRow]["CODE_DELIVERY"].ToString();
strArray[iRow, 18] = dt.Rows[iRow]["MOVED"].ToString();
strArray[iRow, 19] = dt.Rows[iRow]["UNLOAD_MARK"].ToString();
strArray[iRow, 20] = dt.Rows[iRow]["WORK_NO"].ToString();
strArray[iRow, 21] = dt.Rows[iRow]["DANGER_GRADE"].ToString();
strArray[iRow, 22] = dt.Rows[iRow]["DEGREE_SETTING"].ToString();
strArray[iRow, 23] = dt.Rows[iRow]["DEGREE_UNIT"].ToString();
strArray[iRow, 24] = dt.Rows[iRow]["MIN_DEGREE"].ToString();
strArray[iRow, 25] = dt.Rows[iRow]["MAX_DEGREE"].ToString();
strArray[iRow, 26] = dt.Rows[iRow]["BAYNO"].ToString();
strArray[iRow, 27] = dt.Rows[iRow]["OLDBAYNO"].ToString();
strArray[iRow, 28] = dt.Rows[iRow]["CODE_CRANE"].ToString();
strArray[iRow, 29] = dt.Rows[iRow]["image_id"].ToString();
strArray[iRow, 30] = dt.Rows[iRow]["baynum"].ToString();
strArray[iRow, 31] = dt.Rows[iRow]["baycol"].ToString();
strArray[iRow, 32] = dt.Rows[iRow]["bayrow"].ToString();
strArray[iRow, 33] = dt.Rows[iRow]["container_no"].ToString();
strArray[iRow, 34] = dt.Rows[iRow]["size_con"].ToString();
strArray[iRow, 35] = dt.Rows[iRow]["container_type"].ToString();
strArray[iRow, 36] = dt.Rows[iRow]["code_empty"].ToString();
strArray[iRow, 37] = dt.Rows[iRow]["weight"].ToString();
strArray[iRow, 38] = dt.Rows[iRow]["work_date"].ToString();
strArray[iRow, 39] = dt.Rows[iRow]["sealno"].ToString();
strArray[iRow, 40] = dt.Rows[iRow]["moved_name"].ToString();
strArray[iRow, 41] = dt.Rows[iRow]["inoutmark"].ToString();
strArray[iRow, 42] = dt.Rows[iRow]["transmark"].ToString();
strArray[iRow, 43] = dt.Rows[iRow]["jjr"].ToString();
strArray[iRow, 44] = dt.Rows[iRow]["yb"].ToString();
strArray[iRow, 45] = dt.Rows[iRow]["name"].ToString();
}
Json = JsonConvert.SerializeObject(new DicPackage(true, strArray, 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)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
//手机号码
string strMobile = Request.Form["Mobile"];
//密码1
string strPassword1 = Request.Form["Password1"];
//密码2
string strPassword2 = Request.Form["Password2"];
AppLog log = new AppLog(Request);
log.strBehavior = "找回密码";
log.strBehaviorURL = "/Entrance/RetrievePassword.aspx";
try
{
if (strMobile == null || strPassword1 == null || strPassword2 == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，修改密码失败！").DicInfo());
return;
}
string strSql =
string.Format("select code_user from TB_SYS_USERINFO where mobile ='{0}'", strMobile);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathIport).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "用户名错误！").DicInfo());
return;
}
//校验新密码
if (strPassword1.Length < 6 || strPassword1.Length > 32 || strPassword2.Length < 6 || strPassword2.Length > 32)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "密码应为6~32个字符！").DicInfo());
return;
}
if (!strPassword1.Equals(strPassword2))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "新密码不一致！").DicInfo());
return;
}
//string strXmlParams =
// string.Format("<params><usercode>{0}</usercode><oldpassword>{1}</oldpassword><newpassword>{2}</newpassword></params>",
// strCodeUser, strOldPassword, strNewPassword1);
//ServiceIportUser.WebServiceUserSoapClient service = new ServiceIportUser.WebServiceUserSoapClient();
//string strReturnMessage = service.UpdatePassword(strXmlParams, 1);
//RetureMessage retureMessage = JsonConvert.DeserializeObject<RetureMessage>(strReturnMessage);
//if ((bool)retureMessage.Value == false)
//{
// Json = JsonConvert.SerializeObject(new DicPackage(false, null, retureMessage.Message).DicInfo());
//}
//else
//{
// Json = JsonConvert.SerializeObject(new DicPackage(true, null, "密码重置成功！").DicInfo());
//}
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "接口调式中！").DicInfo());
log.LogCatalogSuccess();
}
catch (Exception ex)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：找回密码数据发生异常。{1}", ex.Source, ex.Message)).DicInfo());
log.LogCatalogFailure(string.Format("{0}：找回密码数据发生异常。{1}", ex.Source, ex.Message));
}
}
protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误").DicInfo());
return;
}
//ID
string strId = Request.Params["Id"];
//strId = "6";
try
{
if (strId == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，获取问题详情数据失败").DicInfo());
return;
}
//获取问题详情
string strSql =
string.Format(@"select a.id,a.type_mark,c.complain_name,b.department,a.vehicle,a.driverphone,to_char(a.createtime, 'yyyy/mm/dd hh24:mi:ss') as createtime,a.anonymous_mark,a.finish_mark,a.title,a.detail,a.deal_result,to_char(a.deal_time, 'yyyy/mm/dd hh24:ss:mi') as deal_time,a.evaluate,a.index_satisfy,to_char(a.evaluate_time, 'yyyy/mm/dd hh24:mi:ss') as evaluate_time,a.adjust_time,e.complain_name as complain_name_org,d.department as department_org
from SER_COMPLAIN a
left join HARBOR.V_SYS_DEPART_CONVERT b on a.code_company=b.code_department
left join SER_CODE_COMPLAIN c on a.code_complain=c.code_complain
left join HARBOR.V_SYS_DEPART_CONVERT d on a.code_company_org=d.code_department
left join SER_CODE_COMPLAIN e on a.code_complain_org=e.code_complain
where a.id='{0}'
order by a.finish_mark asc,a.createtime desc",
strId);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathCGate).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, null).DicInfo());
return;
}
string[] strArray = new string[16];
strArray[0] = Convert.ToString(dt.Rows[0]["id"]);
string strType = Convert.ToString(dt.Rows[0]["type_mark"]).Equals("0") == true ? "投诉" : "问题";
strArray[1] = strType;
string strComplain_Name = Convert.ToString(dt.Rows[0]["complain_name_org"]);
string strDepartment = Convert.ToString(dt.Rows[0]["department_org"]);
if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["complain_name"])))
{
strComplain_Name = Convert.ToString(dt.Rows[0]["complain_name"]);
strDepartment = Convert.ToString(dt.Rows[0]["department"]);
}
strArray[2] = strComplain_Name;
strArray[3] = strDepartment;
strArray[4] = Convert.ToString(dt.Rows[0]["vehicle"]);
strArray[5] = Convert.ToString(dt.Rows[0]["driverphone"]);
strArray[6] = Convert.ToString(dt.Rows[0]["createtime"]);
string strAnonymous = Convert.ToString(dt.Rows[0]["anonymous_mark"]).Equals("0") == true ? "" : "匿名";
strArray[7] = strAnonymous;
string strState = string.Empty;
if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["evaluate_time"])))
{
strState = "已评价";
}
else if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["deal_time"])))
{
strState = "已解决";
}
else if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["adjust_time"])))
{
strState = "已受理";
}
else
{
strState = "待受理";
}
strArray[8] = strState;
strArray[9] = Convert.ToString(dt.Rows[0]["title"]);
strArray[10] = Convert.ToString(dt.Rows[0]["detail"]);
strArray[11] = Convert.ToString(dt.Rows[0]["deal_result"]);
strArray[12] = Convert.ToString(dt.Rows[0]["deal_time"]);
strArray[13] = Convert.ToString(dt.Rows[0]["evaluate"]);
string strIndex_satisfy = string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["index_satisfy"])) == true ? string.Empty : GetChineseEvaluate(Convert.ToInt16(dt.Rows[0]["index_satisfy"]));
strArray[14] = strIndex_satisfy;
strArray[15] = Convert.ToString(dt.Rows[0]["evaluate_time"]);
Json = JsonConvert.SerializeObject(new DicPackage(true, strArray, 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)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
//用户编码
string strCodeUser = Request.Form["CodeUser"];
//旧密码
string strOldPassword = Request.Form["OldPassword"];
//新密码1
string strNewPassword1 = Request.Form["NewPassword1"];
//新密码2
string strNewPassword2 = Request.Form["NewPassword2"];
////用户编码
//string strCodeUser = Request.Params["CodeUser"];
////旧密码
//string strOldPassword = Request.Params["OldPassword"];
////新密码1
//string strNewPassword1 = Request.Params["NewPassword1"];
////新密码2
//string strNewPassword2 = Request.Params["NewPassword2"];
AppLog log = new AppLog(Request);
log.strBehavior = "修改密码";
log.strBehaviorURL = "/Entrance/ChangePassword.aspx";
try
{
if (strCodeUser == null || strOldPassword == null || strNewPassword1 == null || strNewPassword2 == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，修改密码失败！").DicInfo());
return;
}
string strSql =
string.Format("select password from TB_SYS_USER t where code_user ='******'", strCodeUser);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathIport).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "无效用户！").DicInfo());
log.LogCatalogFailure("无效用户！");
return;
}
//校验旧密码
if (!string.IsNullOrWhiteSpace(dt.Rows[0]["PASSWORD"] as string))
{
if (!Identity.VerifyText(strOldPassword, dt.Rows[0]["PASSWORD"] as string))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "当前密码错误，请重新输入！").DicInfo());
log.LogCatalogFailure("当前密码错误，请重新输入！");
return;
}
}
else if (!(string.IsNullOrWhiteSpace(strOldPassword) && string.IsNullOrWhiteSpace(dt.Rows[0]["PASSWORD"] as string)))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "当前密码错误，请重新输入！").DicInfo());
log.LogCatalogFailure("当前密码错误，请重新输入！");
return;
}
//校验新密码
if (strNewPassword1.Length < 6 || strNewPassword1.Length > 32 || strNewPassword2.Length < 6 || strNewPassword2.Length > 32)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "密码应为6~32个字符！").DicInfo());
log.LogCatalogFailure("密码应为6~32个字符！");
return;
}
if (!strNewPassword1.Equals(strNewPassword2))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "新密码不一致！").DicInfo());
log.LogCatalogFailure("新密码不一致！");
return;
}
string strXmlParams =
string.Format("<params><usercode>{0}</usercode><oldpassword>{1}</oldpassword><newpassword>{2}</newpassword></params>",
strCodeUser, strOldPassword, strNewPassword1);
bool isSuccess = YGSoft.IPort.MobileManage.Interface.Core.ServiceUser.UpdatePassword(strXmlParams).Value;
if (!isSuccess)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, YGSoft.IPort.MobileManage.Interface.Core.ServiceUser.UpdatePassword(strXmlParams).Message).DicInfo());
log.LogCatalogFailure(YGSoft.IPort.MobileManage.Interface.Core.ServiceUser.UpdatePassword(strXmlParams).Message);
}
else
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "密码修改成功！").DicInfo());
log.LogCatalogSuccess();
}
}
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)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
//航次Id
string strShipId = Request.Params["ShipId"];
//船舶Id
string strV_Id = Request.Params["V_Id"];
//箱号
string strContainerNo = Request.Params["ContainerNo"];
//目标贝号
string strEndBayno = Request.Params["EndBayno"];
//用户ID
string strUserId = Request.Params["UserId"];
//strShipId = "195";
//strV_Id = "6321";
//strContainerNo = "CXDU2283528";
//strEndBayno = "050304";
//strUserId = "215";
AppLog log = new AppLog(Request);
log.strBehavior = "移贝";
log.strBehaviorURL = "/Move/MoveBay.aspx";
log.strAccount = strUserId;
try
{
if (strShipId == null || strV_Id == null || strContainerNo == null || strEndBayno == null || strUserId == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，移贝失败！").DicInfo());
log.LogCatalogFailure(string.Format("参数错误，移贝失败"));
return;
}
da.BeginTransaction();
IMoveBay iMoveBay = new IMoveBay(log);
iMoveBay.setDataAccess(da);
//校验目标贝位号是否存在
if (!iMoveBay.isExistBayno(strV_Id, strEndBayno))
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "错误贝位号").DicInfo());
log.LogCatalogFailure(string.Format("错误贝位号"));
return;
}
string strOperareName = string.Empty;
string strSql = string.Format(@"select distinct name
from SYSTEM_USER_TABLE
where user_id='{0}'",
strUserId);
var dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTallySqlServer).ExecuteTable(strSql);
if (dt.Rows.Count > 0)
{
strOperareName = Convert.ToString(dt.Rows[0]["name"]);
}
//获取待移集装箱信息
strSql =
string.Format(@"select size_con,bayno
from con_image
where container_no='{0}' and ship_id={1}",
strContainerNo, strShipId);
dt = da.ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "待移集装箱号不存在").DicInfo());
log.LogCatalogFailure(string.Format("待移集装箱号不存在"));
return;
}
if (Convert.ToInt16(dt.Rows[0]["size_con"]) == 20)
{
Json = iMoveBay.MoveBayOfTwenty(strShipId, strContainerNo, Convert.ToString(dt.Rows[0]["bayno"]), strEndBayno, strOperareName);
}
else
{
Json = iMoveBay.MoveBayOfForty(strShipId, strContainerNo, Convert.ToString(dt.Rows[0]["bayno"]), strEndBayno, strOperareName);
}
if (Json != null)
{
return;
}
da.CommitTransaction();
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "上传成功！").DicInfo());
log.LogCatalogSuccess();
}
catch (Exception ex)
{
da.RollbackTransaction();
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：移贝发生异常。{1}", ex.Source, ex.Message)).DicInfo());
log.LogCatalogFailure(string.Format("{0}：移贝发生异常。{1}", ex.Source, ex.Message));
}
}
protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误").DicInfo());
return;
}
//数据起始行
var strStartRow = Request.Params["StartRow"];
//数据结束行
var strEndRow = Request.Params["EndRow"];
//账户
string strAccount = Request.Params["Account"];
//strStartRow = "1";
//strEndRow = "15";
//strAccount = "18936578716";
try
{
if (strStartRow == null || strEndRow == null || strAccount == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，获取待评价列表数据失败").DicInfo());
return;
}
//获取待评价列表数据
string strSql =
string.Format(@"select a.id,a.ingateno,b.fullorempty,b.vessel,b.cargo,a.vehicle,to_char(a.submittime, 'yyyy/mm/dd hh24:mi') as submittime,b.department
from TB_PRO_CONSIGNVEHICLE a, V_CONSIGN_QUICK b
where a.cgno=b.cgno and a.driverphone='{0}' and a.delete_mark_ser_evaluate='0'
order by a.submittime desc",
strAccount);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathHarbor).ExecuteTable(strSql, Convert.ToInt32(strStartRow), Convert.ToInt32(strEndRow));;
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, null).DicInfo());
return;
}
string[,] strArray = new string[dt.Rows.Count, 7];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
strArray[iRow, 0] = Convert.ToString(dt.Rows[iRow]["id"]);
strArray[iRow, 1] = Convert.ToString(dt.Rows[iRow]["ingateno"]);
strArray[iRow, 2] = Convert.ToString(dt.Rows[iRow]["department"]);
strArray[iRow, 3] = Convert.ToString(dt.Rows[iRow]["vessel"]);
strArray[iRow, 4] = Convert.ToString(dt.Rows[iRow]["cargo"]);
strArray[iRow, 5] = Convert.ToString(dt.Rows[iRow]["vehicle"]);
strArray[iRow, 6] = Convert.ToString(dt.Rows[iRow]["submittime"]);
}
////获取待评价列表数据
//string strSql =
// string.Format(@"select a.id,a.ingateno,a.vehicle,to_char(a.submittime, 'yyyy/mm/dd hh24:mi') as submittime,a.cgno
// from TB_PRO_CONSIGNVEHICLE a
// where a.driverphone='{0}' and a.delete_mark_ser_evaluate='0'
// order by a.submittime desc",
// strAccount);
//var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathHarbor).ExecuteTable(strSql); ;
//if (dt.Rows.Count <= 0)
//{
// Json = JsonConvert.SerializeObject(new DicPackage(true, null, null).DicInfo());
// return;
//}
//List<List<string>> listArray = new List<List<string>>();
//for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
//{
// strSql =
// string.Format(@"select b.fullorempty,b.vessel,b.cargo
// from V_CONSIGN_QUICK b
// where b.cgno='{0}'",
// Convert.ToString(dt.Rows[iRow]["cgno"]));
// var dt1 = new Leo.Oracle.DataAccess(RegistryKey.KeyPathHarbor).ExecuteTable(strSql);
// if (dt1.Rows.Count > 0)
// {
// List<string> list = new List<string>();
// list.Add(Convert.ToString(dt.Rows[iRow]["id"]));
// list.Add(Convert.ToString(dt.Rows[iRow]["ingateno"]));
// list.Add(Convert.ToString(dt1.Rows[0]["fullorempty"]));
// list.Add(Convert.ToString(dt1.Rows[0]["vessel"]));
// list.Add(Convert.ToString(dt1.Rows[0]["cargo"]));
// list.Add(Convert.ToString(dt.Rows[iRow]["vehicle"]));
// list.Add(Convert.ToString(dt.Rows[iRow]["submittime"]));
// listArray.Add(list);
// }
//}
Json = JsonConvert.SerializeObject(new DicPackage(true, strArray, null).DicInfo());
}
catch (Exception ex)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：获取待评价列表数据发生异常。{1}", ex.Source, ex.Message)).DicInfo());
}
}
protected override void OnDeactivateTool(InterfaceTool new_tool)
{
base.OnDeactivateTool(new_tool);
ToolMenu.Instance.PriorityScreen.Show(false);
}
protected override void OnDeactivateTool(InterfaceTool new_tool)
{
base.OnDeactivateTool(new_tool);
sourceGameObject = null;
}
protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
//手机号
string strMobile = Request.Form["Mobile"];
//验证码
string strAuthCode = Request.Form["AuthCode"];
////手机号
//string strMobile = Request.Params["Mobile"];
////验证码
//string strAuthCode = Request.Params["AuthCode"];
AppLog log = new AppLog(Request);
log.strAccount = strMobile;
log.strBehavior = "校验手机验证码";
log.strBehaviorURL = "/Entrance/VerifyAuthCode.aspx";
try
{
if (strMobile == null || strAuthCode == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，校验手机验证码失败！").DicInfo());
return;
}
string strSql =
string.Format(@"select *
from TB_APP_MOBILE_AUTHCODE
where mobile={0} and dynamic_endtime > sysdate
order by createtime desc",
strMobile);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathMa).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "验证码已超时！").DicInfo());
log.LogCatalogFailure("验证码已超时！");
return;
}
//校验验证码
if (Identity.RijndaelDecode(dt.Rows[0]["dynamic_authcode"].ToString()) != strAuthCode)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "验证码不匹配！").DicInfo());
log.LogCatalogFailure("验证码不匹配！");
}
else
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, null).DicInfo());
log.LogCatalogSuccess();
}
}
catch (Exception ex)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：校验手机验证码数据发生异常。{1}", ex.Source, ex.Message)).DicInfo());
log.LogCatalogFailure(string.Format("{0}：校验手机验证码数据发生异常。{1}", ex.Source, ex.Message));
}
}
protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
try
{
IStorageCoord iStorage = new IStorageCoord();
List <List <string> > listArray = new List <List <string> >();
foreach (string strCodeCompany in iStorage.GetCodeCompany())
{
var dt = iStorage.GetStorageCoord(strCodeCompany);
if (dt == null)
{
continue;
}
if (dt.Rows.Count > 0)
{
if (strCodeCompany == "010219")
{
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
List <string> list = new List <string>();
list.Add(dt.Rows[iRow]["mass_num"].ToString());
list.Add(dt.Rows[iRow]["vertex_count"].ToString());
list.Add(dt.Rows[iRow]["vertex1_latitude"].ToString());
list.Add(dt.Rows[iRow]["vertex1_long"].ToString());
list.Add(dt.Rows[iRow]["vertex2_latitude"].ToString());
list.Add(dt.Rows[iRow]["vertex2_long"].ToString());
list.Add(dt.Rows[iRow]["vertex3_latitude"].ToString());
list.Add(dt.Rows[iRow]["vertex3_long"].ToString());
list.Add(dt.Rows[iRow]["vertex4_latitude"].ToString());
list.Add(dt.Rows[iRow]["vertex4_long"].ToString());
list.Add(dt.Rows[iRow]["vertex5_latitude"].ToString());
list.Add(dt.Rows[iRow]["vertex5_long"].ToString());
list.Add(dt.Rows[iRow]["vertex6_latitude"].ToString());
list.Add(dt.Rows[iRow]["vertex6_long"].ToString());
list.Add(dt.Rows[iRow]["areacode"].ToString().ToUpper());
listArray.Add(list);
}
}
else
{
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
List <string> list = new List <string>();
list.Add(dt.Rows[iRow]["mass_num"].ToString());
list.Add(dt.Rows[iRow]["vertex_count"].ToString());
list.Add(dt.Rows[iRow]["vertex1_latitude"].ToString());
list.Add(dt.Rows[iRow]["vertex1_long"].ToString());
list.Add(dt.Rows[iRow]["vertex2_latitude"].ToString());
list.Add(dt.Rows[iRow]["vertex2_long"].ToString());
list.Add(dt.Rows[iRow]["vertex3_latitude"].ToString());
list.Add(dt.Rows[iRow]["vertex3_long"].ToString());
list.Add(dt.Rows[iRow]["vertex4_latitude"].ToString());
list.Add(dt.Rows[iRow]["vertex4_long"].ToString());
list.Add(dt.Rows[iRow]["vertex5_latitude"].ToString());
list.Add(dt.Rows[iRow]["vertex5_long"].ToString());
list.Add(dt.Rows[iRow]["vertex6_latitude"].ToString());
list.Add(dt.Rows[iRow]["vertex6_long"].ToString());
list.Add(dt.Rows[iRow]["code_storage"].ToString().ToUpper());
listArray.Add(list);
}
}
}
}
Json = JsonConvert.SerializeObject(new DicPackage(true, listArray.ToArray(), 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)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
//航次编码
string strShip_Id = Request.Params["Ship_Id"];
//贝
string strBayNum = Request.Params["BayNum"];
//strShip_Id = "41";
//strBayNum = "29";
try
{
if (strShip_Id == null || strBayNum == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，获取单个贝船图数据失败！").DicInfo());
return;
}
string strSql =
string.Format(@"select image_id,ship_id,baynum,baycol,bayrow,container_no,size_con,container_type,code_empty,weight,work_date,sealno,moved_name,inoutmark,transmark,jjr,yb,code_crane,name
from vcon_image_monitor
WHERE ship_id='{0}' and baynum='{1}'",
strShip_Id, strBayNum);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "暂无数据！").DicInfo());
return;
}
string[,] strArray = new string[dt.Rows.Count, 18];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
strArray[iRow, 0] = dt.Rows[iRow]["image_id"].ToString();
strArray[iRow, 1] = dt.Rows[iRow]["baynum"].ToString();
strArray[iRow, 2] = dt.Rows[iRow]["baycol"].ToString();
strArray[iRow, 3] = dt.Rows[iRow]["bayrow"].ToString();
strArray[iRow, 4] = dt.Rows[iRow]["container_no"].ToString();
strArray[iRow, 5] = dt.Rows[iRow]["size_con"].ToString();
strArray[iRow, 6] = dt.Rows[iRow]["container_type"].ToString();
strArray[iRow, 7] = dt.Rows[iRow]["code_empty"].ToString();
strArray[iRow, 8] = dt.Rows[iRow]["weight"].ToString();
strArray[iRow, 9] = dt.Rows[iRow]["work_date"].ToString();
strArray[iRow, 10] = dt.Rows[iRow]["sealno"].ToString();
strArray[iRow, 11] = dt.Rows[iRow]["moved_name"].ToString();
strArray[iRow, 12] = dt.Rows[iRow]["inoutmark"].ToString();
strArray[iRow, 13] = dt.Rows[iRow]["transmark"].ToString();
strArray[iRow, 14] = dt.Rows[iRow]["jjr"].ToString();
strArray[iRow, 15] = dt.Rows[iRow]["yb"].ToString();
strArray[iRow, 16] = dt.Rows[iRow]["code_crane"].ToString();
strArray[iRow, 17] = dt.Rows[iRow]["name"].ToString();
}
Json = JsonConvert.SerializeObject(new DicPackage(true, strArray, null).DicInfo());
}
catch (Exception ex)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：获取单个贝船图数据发生异常。{1}", ex.Source, ex.Message)).DicInfo());
}
}
protected override void OnDeactivateTool(InterfaceTool new_tool)
{
base.OnDeactivateTool(new_tool);
PlayerController.Instance.ToolDeactivated(this);
}
protected override void OnDeactivateTool(InterfaceTool new_tool)
{
base.OnDeactivateTool(new_tool);
SandboxToolParameterMenu.instance.gameObject.SetActive(false);
}
protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误").DicInfo());
return;
}
//ID
string strId = Request.Params["Id"];
//strId = "211";
try
{
if (strId == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，获取评价详情数据失败").DicInfo());
return;
}
//获取待评价详情
string strSql =
string.Format(@"select t.id,t.veh_attest_no,t.driverphone,t.finish_mark,t.evaluate_hall,t.evaluate_dock,t.evaluate_gate,t.index_attitude,t.index_audit,t.index_make,t.index_overall,to_char(t.createtime, 'yyyy/mm/dd hh24:ss:mi') as evaluatetime,
t.hall_comment,to_char(t.hall_time, 'yyyy/mm/dd hh24:mi:ss') as hall_time,t.dock_comment,to_char(t.dock_time, 'yyyy/mm/dd hh24:ss:mi') as dock_time,t.gate_comment,to_char(t.gate_time, 'yyyy/mm/dd hh24:ss:mi') as gate_time
from ser_evaluate t where t.id='{0}'",
strId);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathCGate).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, null).DicInfo());
return;
}
string[] strArray = new string[18];
strArray[0] = Convert.ToString(dt.Rows[0]["id"]);
strArray[1] = Convert.ToString(dt.Rows[0]["veh_attest_no"]);
strArray[2] = Convert.ToString(dt.Rows[0]["driverphone"]);
string strExplain = string.Empty;
if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["hall_time"])) || !string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["dock_time"])) || !string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["gate_time"])))
{
strExplain = "有说明";
}
strArray[3] = strExplain;
strArray[4] = Convert.ToString(dt.Rows[0]["evaluate_hall"]);
strArray[5] = Convert.ToString(dt.Rows[0]["evaluate_dock"]);
strArray[6] = Convert.ToString(dt.Rows[0]["evaluate_gate"]);
strArray[7] = GetChineseEvaluate(Convert.ToInt16(dt.Rows[0]["index_attitude"]));
strArray[8] = GetChineseEvaluate(Convert.ToInt16(dt.Rows[0]["index_audit"]));
strArray[9] = GetChineseEvaluate(Convert.ToInt16(dt.Rows[0]["index_make"]));
strArray[10] = GetChineseEvaluate(Convert.ToInt16(dt.Rows[0]["index_overall"]));
strArray[11] = Convert.ToString(dt.Rows[0]["evaluatetime"]);
strArray[12] = Convert.ToString(dt.Rows[0]["hall_comment"]);
strArray[13] = Convert.ToString(dt.Rows[0]["hall_time"]);
strArray[14] = Convert.ToString(dt.Rows[0]["dock_comment"]);
strArray[15] = Convert.ToString(dt.Rows[0]["dock_time"]);
strArray[16] = Convert.ToString(dt.Rows[0]["gate_comment"]);
strArray[17] = Convert.ToString(dt.Rows[0]["gate_time"]);
Json = JsonConvert.SerializeObject(new DicPackage(true, strArray, null).DicInfo());
}
catch (Exception ex)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：获取评价详情数据发生异常。{1}", ex.Source, ex.Message)).DicInfo());
}
}
