protected void Page_Load(object sender, EventArgs e)
{
//审批人
var isAuditName = Request.Params["IsAuditName"];
//编码
var TFNO = Request.Params["TFNO"];
Dictionary <string, string> info = new Dictionary <string, string>();
try
{
if (isAuditName == null || TFNO == null)
{
info.Add("参数IsAuditName，TFNO不能为null！", "举例：http://218.92.115.55/wlkg/Service/Approval/BillingApproval/BillingApproval.aspx?IsAuditName=227&TFNO=123234");
Json = JsonConvert.SerializeObject(info);
return;
}
var TFNOArry = TFNO.ToString().Split(' ');
for (int iTFNO = 0; iTFNO < TFNOArry.Length; iTFNO++)
{
string sql =
string.Format("select * from tb_ht_tariff where TFNO='{0}'", TFNOArry[iTFNO]);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathLbts).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
info.Add("Approval", "No");
info.Add("Message", "编码（TFNO）不存在！");
Json = JsonConvert.SerializeObject(info);
return;
}
sql =
string.Format("UPDATE tb_ht_tariff t SET t.isaudit='2' ,t.isauditname='{0}' where TFNO='{1}'", isAuditName, TFNOArry[iTFNO]);
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathLbts).ExecuteTable(sql);
sql =
string.Format("select * from tb_ht_tariff where TFNO='{0}'", TFNOArry[iTFNO]);
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathLbts).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
info.Add("Approval", "No");
info.Add("Message", "网络错误，请稍后重试！");
return;
}
else
{
if ((Convert.ToString(dt.Rows[0]["isaudit"]) != "2") || (Convert.ToString(dt.Rows[0]["isauditname"]) != isAuditName))
{
info.Add("Approval", "No");
info.Add("Message", "网络错误，请稍后重试！");
return;
}
}
}
info.Add("Approval", "Yes");
info.Add("Message", "审批成功！");
Json = JsonConvert.SerializeObject(info);
}
catch (Exception ex)
{
info.Add("ApprovalReturn", "No");
info.Add("Message", "服务器异常：" + ex.Message);
Json = JsonConvert.SerializeObject(info);
}
}
protected void Page_Load(object sender, EventArgs e)
{
var codeUser = Request.Params["CodeUser"];
var oldPassword = Request.Params["OldPassword"];
var newPassword = Request.Params["NewPassword"];
var appName = Request.Params["AppName"];
Dictionary <string, string> info = new Dictionary <string, string>();
try
{
if (codeUser == null || oldPassword == null || newPassword == null || appName == null)
{
info.Add("参数CodeUser，OldPassword，NewPassword，AppName不能为空！", "举例：http://218.92.115.55/MobilePlatform/ChangePassword.aspx?CodeUser=0000&OldPassword=123&NewPassword=456&AppName=HMW");
Json = JsonConvert.SerializeObject(info);
return;
}
string UserType;
switch (appName)
{
case "HMW": UserType = "iPort"; break;
case "YGHY": UserType = "nbw"; break;
case "IPORT": UserType = "iPort"; break;
case "WLKG": UserType = "iPort"; break;
default: return;
}
if (UserType == "nbw")
{
string sql = string.Format("select PWD,PASSWORD from USER_INFO t where t.GONGHAO ='{0}'", codeUser);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathNbw).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
info.Add("IsChange", "No");
info.Add("Message", "用户名错误！");
Json = JsonConvert.SerializeObject(info);
return;
}
if (!Identity.VerifyText(oldPassword, dt.Rows[0]["PASSWORD"] as string))
{
info.Add("IsChange", "No");
info.Add("Message", "密码错误错误！");
}
else
{
sql = string.Format(
"update USER_INFO set PWD='{0}',PASSWORD='******' where GONGHAO='{2}'",
newPassword, Identity.EncodeText(newPassword), codeUser);
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathNbw).ExecuteTable(sql);
info.Add("IsChange", "Yes");
info.Add("Message", "修改成功！");
}
}
else if (UserType == "iPort")
{
string sql = string.Format("select PASSWORD from TB_SYS_USER t where t.CODE_USER ='******'", codeUser);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathIport).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
info.Add("IsChange", "No");
info.Add("Message", "用户名错误！");
Json = JsonConvert.SerializeObject(info);
return;
}
if (dt.Rows[0]["PASSWORD"] as string != null)
{
if (!Identity.VerifyText(oldPassword, dt.Rows[0]["PASSWORD"] as string))
{
info.Add("IsChange", "No");
info.Add("Message", "密码错误！");
}
else
{
sql = string.Format(
"update TB_SYS_USER set DPBEGINTIME=null,DYNAMICPASSWORD=null,PASSWORD='******' where CODE_USER='******'",
Identity.EncodeText(newPassword), codeUser);
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathIport).ExecuteTable(sql);
info.Add("IsChange", "Yes");
info.Add("Message", "修改成功！");
}
}
else if (dt.Rows[0]["PASSWORD"] as string == null && Convert.ToString(oldPassword) == "")
{
sql = string.Format(
"update TB_SYS_USER set DPBEGINTIME=null,DYNAMICPASSWORD=null,PASSWORD='******' where CODE_USER='******'",
Identity.EncodeText(newPassword), codeUser);
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathIport).ExecuteTable(sql);
info.Add("IsChange", "Yes");
info.Add("Message", "修改成功！");
}
else
{
info.Add("IsChange", "No");
info.Add("Message", "密码错误！");
}
}
else
{
return;
}
Json = JsonConvert.SerializeObject(info);
}
catch (Exception ex)
{
info.Add("IsChange", "No");
info.Add("Message", ex.Message);
Json = JsonConvert.SerializeObject(info);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//数据起始行
var strStartRow = Request.Params["StartRow"];
//行数
var strCount = Request.Params["Count"];
//用户编码
string strCodeUser = Request.Params["CodeUser"];
//车牌号
string strVehicleNum = Request.Params["VehicleNum"];
//strStartRow = "1";
//strCount = "100";
//strCodeUser = "******";
//strVehicleNum = "苏";
try
{
if (strStartRow == null || strCount == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "获取车辆放行信息失败！").DicInfo());
return;
}
List <List <string> > listArray = new List <List <string> >();
string strSql = string.Empty;
if (string.IsNullOrWhiteSpace(strVehicleNum))
{
string strFilter1 = string.Empty;
string strFilter2 = string.Empty;
//获取已关联车辆
strSql =
string.Format(@"select vehiclenum
from TB_SPH_VEHICLE_RELATION_PASSED
where code_user='******' order by operatetime desc",
strCodeUser);
var dt1 = new Leo.Oracle.DataAccess(RegistryKey.KeyPathWlxgx).ExecuteTable(strSql);
if (dt1.Rows.Count > 0)
{
for (int iRow = 0; iRow < dt1.Rows.Count; iRow++)
{
strFilter1 += string.Format("vehiclenet='{0}' or ", Convert.ToString(dt1.Rows[iRow]["vehiclenum"]));
strFilter2 += string.Format("vehiclenet<>'{0}' and ", Convert.ToString(dt1.Rows[iRow]["vehiclenum"]));
}
strFilter1 = strFilter1.Remove(strFilter1.Length - 4, 4);
strFilter2 = strFilter2.Remove(strFilter2.Length - 5, 5);
}
//无车牌号筛选，并且第一次加载（关联车辆+未关联车辆）；无车牌号筛选，不是第一次加载（未关联车辆）
if (strStartRow.Equals("1"))
{
strSql = string.Format(@"select * from V_CONSIGN_VEHICLE_ONLY_QUICK where {0} order by audittime desc", strFilter1);
dt1 = new Leo.Oracle.DataAccess(RegistryKey.KeyPathWlxgx).ExecuteTable(strSql);
for (int iRow = 0; iRow < dt1.Rows.Count; iRow++)
{
List <string> list = new List <string>();
list.Add(Convert.ToString(dt1.Rows[iRow]["vehiclenet"]));
list.Add(Convert.ToString(dt1.Rows[iRow]["position"]));
list.Add(Convert.ToString(dt1.Rows[iRow]["storage"]));
list.Add(Convert.ToString(dt1.Rows[iRow]["audittime"]));
list.Add("1");
listArray.Add(list);
}
}
//无关联车辆
strSql =
string.Format(@"select *
from V_CONSIGN_VEHICLE_ONLY_QUICK
where {0} and rownum<{1}
order by audittime desc",
strFilter2, Convert.ToUInt32(strStartRow) + Convert.ToUInt32(strCount));
}
//有车牌号筛选
else
{
strSql =
string.Format(@"select *
from V_CONSIGN_VEHICLE_ONLY_QUICK
where vehiclenet like '%{0}%' and rownum<{1}
order by audittime desc",
strVehicleNum, Convert.ToUInt32(strStartRow) + Convert.ToUInt32(strCount));
}
var dt2 = new Leo.Oracle.DataAccess(RegistryKey.KeyPathWlxgx).ExecuteTable(strSql, Convert.ToInt32(strStartRow), Convert.ToInt32(strStartRow) + Convert.ToInt32(strCount) - 1);
if (dt2.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "暂无数据！").DicInfo());
return;
}
for (int iRow = 0; iRow < dt2.Rows.Count; iRow++)
{
List <string> list = new List <string>();
list.Add(Convert.ToString(dt2.Rows[iRow]["vehiclenet"]));
list.Add(Convert.ToString(dt2.Rows[iRow]["position"]));
list.Add(Convert.ToString(dt2.Rows[iRow]["storage"]));
list.Add(Convert.ToString(dt2.Rows[iRow]["audittime"]));
list.Add("0");
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)
{
//账号
var account = Request.Params["Account"];
Dictionary <string, Array> info = new Dictionary <string, Array>();
try
{
if (account == null)
{
string[] arry0 = new string[1];
arry0[0] = "NO";
info.Add("IsDealingInfo", arry0);
string[] arry1 = new string[1];
arry1[0] = "http://218.92.115.55/M_Sph/Deal/DealingInfoForDriver.aspx?Account=1F4BA283C3F95122E053A86401695122";
info.Add("参数Account不能为空！举例", arry1);
Json = JsonConvert.SerializeObject(info);
return;
}
//查询司机正在交易的信息
string sql =
string.Format("select * from TB_SPH_ORDER where CODE_USER_SECOND = '{0}' and MARK_DEAL='{1}'", account, "0");
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathWlxgx).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
string[] arry0 = new string[1];
arry0[0] = "NO";
info.Add("IsDealingInfo", arry0);
string[] arry1 = new string[1];
arry1[0] = "暂无交易信息！";
info.Add("Message", arry1);
Json = JsonConvert.SerializeObject(info);
return;
}
string[,] ary = new string[dt.Rows.Count, 11];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
ary[iRow, 0] = dt.Rows[iRow]["id"].ToString();
ary[iRow, 1] = dt.Rows[iRow]["sfd"].ToString();
ary[iRow, 2] = dt.Rows[iRow]["mdd"].ToString();
ary[iRow, 3] = dt.Rows[iRow]["MARK_INSURANCE"].ToString();
ary[iRow, 4] = dt.Rows[iRow]["CODE_CARGO_SOURCE"].ToString();
ary[iRow, 5] = dt.Rows[iRow]["ORDERNUM"].ToString();
}
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
sql = string.Format("select * from TB_DMT_CARGO where pkid='{0}'", dt.Rows[iRow]["CODE_CARGO_SOURCE"].ToString());
var dt1 = new Leo.Oracle.DataAccess(RegistryKey.KeyPathWlxgx).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
string[] arry0 = new string[1];
arry0[0] = "NO";
info.Add("IsDealingInfo", arry0);
string[] arry1 = new string[1];
arry1[1] = "网络错误，请稍后再试！";
info.Add("Message", arry1);
Json = JsonConvert.SerializeObject(info);
return;
}
ary[iRow, 6] = dt1.Rows[0]["cargoname"].ToString();
ary[iRow, 7] = dt1.Rows[0]["weight"].ToString();
ary[iRow, 8] = dt1.Rows[0]["volume"].ToString();
ary[iRow, 9] = dt1.Rows[0]["vehiclelen"].ToString();
ary[iRow, 10] = dt1.Rows[0]["vehicletype"].ToString();
}
string[] arry2 = new string[1];
arry2[0] = "Yes";
info.Add("IsDealingInfo", arry2);
info.Add("DealingInfo", ary);
Json = JsonConvert.SerializeObject(info);
}
catch (Exception ex)
{
string[] arry0 = new string[1];
arry0[0] = "NO";
info.Add("IsDealingInfo", arry0);
string[] arry1 = new string[1];
arry1[0] = string.Format("{0}：提交数据发生异常。{1}", ex.Source, ex.Message);
info.Add("Message", arry1);
Json = JsonConvert.SerializeObject(info);
}
}
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)
{
//用户编码
var codeUser = Request.Params["CodeUser"];
Dictionary <string, Array> info = new Dictionary <string, Array>();
try
{
if (codeUser == null)
{
string[] arry0 = new string[1];
arry0[0] = "NO";
info.Add("IsGet", arry0);
string[] arry1 = new string[1];
arry1[0] = "举例：http://218.92.115.55/M_Sph/Vehicle/GetVehicleReleasing.aspx?CodeUser=1DA60DDD8025725AE053A864016A725";
info.Add("参数CodeUser不能为空！", arry1);
Json = JsonConvert.SerializeObject(info);
return;
}
//获取发布中车源
string sql =
string.Format("select * from (select * from TB_SPH_EMPTY_VEHICLE where code_user='******' and mark_repeal='{1}' order by releasetime desc) where rownum=1", codeUser, "0");
var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathWlxgx).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
string[] arry0 = new string[1];
arry0[0] = "NO";
info.Add("IsGet", arry0);
string[] arry1 = new string[1];
arry1[0] = "此车源暂未发布";
info.Add("Message", arry1);
}
else
{
string[] ary = new string[7];
ary[0] = dt.Rows[0]["id"].ToString();
ary[1] = dt.Rows[0]["sfd_province"].ToString();
ary[2] = dt.Rows[0]["sfd_city"].ToString();
ary[3] = dt.Rows[0]["mdd_province"].ToString();
ary[4] = dt.Rows[0]["mdd_city"].ToString();
ary[5] = dt.Rows[0]["mark_back"].ToString();
ary[6] = dt.Rows[0]["mark_favorable"].ToString();
string[] arry0 = new string[1];
arry0[0] = "Yes";
info.Add("IsGet", arry0);
info.Add("VehicleReleasing", ary);
}
Json = JsonConvert.SerializeObject(info);
//string[,] ary = new string[dt.Rows.Count, 9];
//for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
//{
// ary[iRow, 0] = dt.Rows[iRow]["id"].ToString();
// ary[iRow, 1] = dt.Rows[iRow]["sfd_province"].ToString();
// ary[iRow, 2] = dt.Rows[iRow]["sfd_city"].ToString();
// ary[iRow, 4] = dt.Rows[iRow]["mdd_province"].ToString();
// ary[iRow, 5] = dt.Rows[iRow]["mdd_city"].ToString();
// ary[iRow, 7] = dt.Rows[iRow]["backmark"].ToString();
// ary[iRow, 8] = dt.Rows[iRow]["favorablemark"].ToString();
//}
//string[] arry2 = new string[1];
//arry2[0] = "Yes";
//info.Add("IsGet", arry2);
//info.Add("GoodsReleasing", ary);
//Json = JsonConvert.SerializeObject(info);
}
catch (Exception ex)
{
string[] arry0 = new string[1];
arry0[0] = "NO";
info.Add("IsGet", arry0);
string[] arry1 = new string[1];
arry1[0] = string.Format("{0}：获取数据发生异常。{1}", ex.Source, ex.Message);
info.Add("Message", arry1);
Json = JsonConvert.SerializeObject(info);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//号码
var no = Request.Params["No"];
//识别方式
var recognizeMethod = Request.Params["RecognizeMethod"];
Dictionary <string, string> info = new Dictionary <string, string>();
try
{
if (no == null || recognizeMethod == null)
{
info.Add("IsGet", "No");
info.Add("参数ExterNo，ScanType不能为null！举例", "http://218.92.115.55/M_Hmw/GetService/Scan/GetHarbourPass.aspx?No=904250&RecognizeMethod=QR");
Json = JsonConvert.SerializeObject(info);
return;
}
//号码字段名称
string noFieldName = string.Empty;
//SQL
string sql = string.Empty;
//车号
string vehicle = string.Empty;
//卡号
string cardNo = string.Empty;
switch (recognizeMethod)
{
case "QR":
noFieldName = "EXTER_NO";
break;
case "NFC":
noFieldName = "PARK_CARD_NO";
break;
default:
throw new Exception("错误的对象索引");
}
//验证NO
sql =
string.Format("select exter_no,vehicle,card_no from TRANSIT.CARD where {0}='{1}'", noFieldName, no);
var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
info.Add("IsGet", "No");
info.Add("Message", "此卡不存在，读取失败！");
Json = JsonConvert.SerializeObject(info);
return;
}
vehicle = Convert.ToString(dt.Rows[0]["vehicle"]);
cardNo = Convert.ToString(dt.Rows[0]["card_no"]);
string oper = string.Empty;
string recordTime = string.Empty;
string feeName = string.Empty;
string endDate = string.Empty;
sql =
string.Format(@"select OPER,to_char(RECORD_TIME, 'yyyy-MM-dd HH24:mi :ss') as RECORD_TIME,FEE_NAME,to_char(ENDDATE, 'yyyy-MM-dd HH24:mi :ss') ENDDATE
from Transit.V_PARLOR_RECORD_ALL
where CARD_NO='{0}' and VEHICLE='{1}' and MARK_VALID='1' order by RECORD_TIME desc", cardNo, vehicle);
dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
if (dt.Rows.Count != 0)
{
oper = Convert.ToString(dt.Rows[0]["OPER"]);
recordTime = Convert.ToString(dt.Rows[0]["RECORD_TIME"]);
feeName = Convert.ToString(dt.Rows[0]["FEE_NAME"]);
endDate = Convert.ToString(dt.Rows[0]["ENDDATE"]);
}
string gateInName = string.Empty;
string gateOutName = string.Empty;
string gateInTime = string.Empty;
string gateOutTime = string.Empty;
sql =
string.Format(@"select GATE_IN_NAME,GATE_OUT_NAME,to_char(GATE_IN_TIME, 'yyyy-MM-dd HH24:mi :ss') as GATE_IN_TIME,to_char(GATE_OUT_TIME, 'yyyy-MM-dd HH24:mi :ss') as GATE_OUT_TIME
from Transit.V_GATE_TIME
where CARD_NO='{0}' and VEHICLE='{1}' order by GATE_IN_TIME desc", cardNo, vehicle);
dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
if (dt.Rows.Count != 0)
{
gateInName = Convert.ToString(dt.Rows[0]["GATE_IN_NAME"]);
gateOutName = Convert.ToString(dt.Rows[0]["GATE_OUT_NAME"]);
gateInTime = Convert.ToString(dt.Rows[0]["GATE_IN_TIME"]);
gateOutTime = Convert.ToString(dt.Rows[0]["GATE_OUT_TIME"]);
}
string cgateInName = string.Empty;
string cgateOutName = string.Empty;
string cgateInTime = string.Empty;
string cgateOutTime = string.Empty;
sql =
string.Format(@"select CGATE_IN_NAME,CGATE_OUT_NAME,to_char(CGATE_IN_TIME, 'yyyy-MM-dd HH24:mi :ss') as CGATE_IN_TIME,to_char(CGATE_OUT_TIME, 'yyyy-MM-dd HH24:mi :ss') as CGATE_OUT_TIME
from CGate.V_CGATE_TIME
where CARD_NO='{0}' and VEHICLE='{1}' order by CGATE_IN_TIME desc", cardNo, vehicle);
dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
if (dt.Rows.Count != 0)
{
cgateInName = Convert.ToString(dt.Rows[0]["CGATE_IN_NAME"]);
cgateOutName = Convert.ToString(dt.Rows[0]["CGATE_OUT_NAME"]);
cgateInTime = Convert.ToString(dt.Rows[0]["CGATE_IN_TIME"]);
cgateOutTime = Convert.ToString(dt.Rows[0]["CGATE_OUT_TIME"]);
}
string[] nameArry = { "业务类别", "办证时间", "证件类型", "有效期", "入港岗亭", "入港时间", "进门岗亭", "进门时间",
"出门岗亭", "出门时间", "离港岗亭", "离港时间" };
//排序字符串
string order = string.Empty;
order = nameArry[0] + "+" + nameArry[1] + "+" + nameArry[2] + "+" + nameArry[3] + "+" + nameArry[4] + "+" + nameArry[5] + "+" +
nameArry[6] + "+" + nameArry[7] + "+" + nameArry[8] + "+" + nameArry[9] + "+" + nameArry[10] + "+" + nameArry[11];
info.Add(nameArry[0], oper);
info.Add(nameArry[1], recordTime);
info.Add(nameArry[2], feeName);
info.Add(nameArry[3], endDate);
info.Add(nameArry[4], gateInName);
info.Add(nameArry[5], gateInTime);
info.Add(nameArry[6], cgateInName);
info.Add(nameArry[7], cgateInTime);
info.Add(nameArry[8], cgateOutName);
info.Add(nameArry[9], cgateOutTime);
info.Add(nameArry[10], gateOutName);
info.Add(nameArry[11], gateOutTime);
info.Add("Order", order);
Json = JsonConvert.SerializeObject(info);
}
catch (Exception ex)
{
info.Add("IsGet", "No");
info.Add("Message", ex.Message);
Json = JsonConvert.SerializeObject(info);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//用户ID
var userId = Request.Params["UserId"];
//查询页数
var pages = Request.Params["Pages"];
//标题筛选
var filter = Request.Params["Filter"];
Dictionary <string, Array> info = new Dictionary <string, Array>();
try
{
if (pages == null || filter == null)
{
string[] arry = new string[1];
arry[0] = "http://218.92.115.55/wlkg/Service/News/CompanyNews/GetCompanyNewsList.aspx?UserId=&Pages=1&Filter=";
info.Add("参数UserId,Pages，Filter不能为空！举例", arry);
Json = JsonConvert.SerializeObject(info);
return;
}
int minRow = (Convert.ToInt16(pages) - 1) * 15 + 1;
int maxRow = Convert.ToInt16(pages) * 15;
int msgValidDays = Convert.ToInt32(FileTool.GetWebConfigKey("NewsValidDays"));
const string newsType = "03.01";
string rsql =
string.Format(
"SELECT newsid, mark, source, userid FROM news_mark WHERE (source = 'mobile' and newstype='{0}' and userid='{1}')",
newsType, userId);
var rdt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathWl).ExecuteTable(rsql);
string Strfilter = null;
if (!string.IsNullOrEmpty(filter) && !string.IsNullOrWhiteSpace(filter))
{
Strfilter = string.Format(" and TOPIC like '%{0}%' ", filter);
}
string sql =
string.Format(
"select count(ID) as total from News where news_type = '{0}' and audit_mark='1' {1} ", newsType, Strfilter);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathWl).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
string[] arry0 = new string[1];
arry0[0] = "NO";
info.Add("IsGet", arry0);
string[] arry1 = new string[1];
arry1[0] = "暂无新闻！";
info.Add("Message", arry1);
Json = JsonConvert.SerializeObject(info);
return;
}
sql =
string.Format(
"select id,topic,audittime,mark_new from (select * from (select id,topic,audittime,CASE WHEN audittime >= sysdate - {0} THEN '1' ELSE '0' END AS mark_new from News where NEWS_TYPE = '{1}' and audit_mark='1' {2} order by audittime asc) where rownum<={3} order by audittime desc) where rownum<={4}",
msgValidDays, newsType, Strfilter, Convert.ToInt32(dt.Rows[0]["total"]) - minRow + 1, maxRow - minRow + 1);
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathWl).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
string[] arry0 = new string[1];
arry0[0] = "NO";
info.Add("IsGet", arry0);
string[] arry1 = new string[1];
arry1[0] = "暂无更多新闻！";
info.Add("Message", arry1);
Json = JsonConvert.SerializeObject(info);
return;
}
string[,] arrys = new string[dt.Rows.Count, 6];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
arrys[iRow, 0] = Convert.ToString(dt.Rows[iRow]["id"]);
arrys[iRow, 1] = Convert.ToString(dt.Rows[iRow]["topic"]);
arrys[iRow, 2] = Convert.ToString(dt.Rows[iRow]["audittime"]);
arrys[iRow, 3] =
("1" == Convert.ToString(dt.Rows[iRow]["mark_new"]) &&
rdt.Select(string.Format("newsid='{0}'", Convert.ToString(dt.Rows[iRow]["id"]))).Length == 0)
? "1"
: "0";
arrys[iRow, 4] = "公司要闻";
arrys[iRow, 5] = newsType;
}
string[] arry2 = new string[1];
arry2[0] = "Yes";
info.Add("IsGet", arry2);
info.Add("ConmpanyNewsList", arrys);
Json = JsonConvert.SerializeObject(info);
}
catch (Exception ex)
{
string[] arry0 = new string[1];
arry0[0] = "NO";
info.Add("IsGet", arry0);
string[] arry1 = new string[1];
arry1[0] = "服务器异常：" + ex.Message;
info.Add("Message", arry1);
Json = JsonConvert.SerializeObject(info);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//用户编码
var codeUser = Request.Params["CodeUser"];
//起始时间
var startTime = Request.Params["StartTime"];
//终止时间
var endTime = Request.Params["EndTime"];
//codeUser = "******";
//startTime = "2015-08-11";
//endTime = "2015-09-11";
Dictionary <string, Array> info = new Dictionary <string, Array>();
try
{
if (codeUser == null || startTime == null || endTime == null)
{
string[] arry0 = new string[1];
arry0[0] = "举例：http://218.92.115.55/wlkg/Service/Supervise/Finance/GetBS_FinanceManagementCenter.aspx?CodeUser=121355&StartTime=2015-08-11&EndTime=2015-09-11";
info.Add("参数CodeUser，StartTime，EndTime不能为nul！", arry0);
Json = JsonConvert.SerializeObject(info);
return;
}
startTime = Convert.ToDateTime(startTime).ToString("yyyyMMdd");
endTime = Convert.ToDateTime(endTime).ToString("yyyyMMdd");
string firm = "EXISTS(SELECT * FROM ACCESS_CONTROL WHERE CODE_USER='******'AND VIEW_DELEGATION.IPORT_DEPT=ACCESS_CONTROL.CODE_DEPARTMENT)";
string firmQuasi = "(SUBSTR(ORDER_DATE,1,8)>='" + startTime + "'AND SUBSTR(ORDER_DATE,1,8)<='" + endTime + "')";
string taxis = "ORDER BY INPUT_DATE DESC";
string sql =
string.Format(@"SELECT *
from view_delegation where {0} and {1} {2}", firm, firmQuasi, taxis);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathLbts).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
string[] arry0 = new string[1];
arry0[0] = "NO";
info.Add("IsGet", arry0);
string[] arry1 = new string[1];
arry1[0] = "暂无数据！";
info.Add("Message", arry1);
Json = JsonConvert.SerializeObject(info);
return;
}
string[,] ary = new string[dt.Rows.Count, 7];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
ary[iRow, 0] = Convert.ToString(dt.Rows[iRow]["ID"]);
ary[iRow, 1] = Convert.ToString(dt.Rows[iRow]["SHIPNAME"]);
ary[iRow, 2] = Convert.ToString(dt.Rows[iRow]["VOYAGE"]);
ary[iRow, 3] = Convert.ToString(dt.Rows[iRow]["CARGO_NAME"]);
ary[iRow, 4] = Convert.ToString(dt.Rows[iRow]["CLIENTSHORT"]);
ary[iRow, 5] = Convert.ToString(dt.Rows[iRow]["TOTALAMOUNT"]);
ary[iRow, 6] = Convert.ToString(dt.Rows[iRow]["CTNNO_COUNT"]);
}
string[] arry2 = new string[1];
arry2[0] = "Yes";
info.Add("IsGet", arry2);
info.Add("BusinessManagementCenter", ary);
Json = JsonConvert.SerializeObject(info);
}
catch (Exception ex)
{
string[] arry0 = new string[1];
arry0[0] = "NO";
info.Add("IsGet", arry0);
string[] arry1 = new string[1];
arry1[0] = "服务器异常：" + ex.Message;
info.Add("Message", arry1);
Json = JsonConvert.SerializeObject(info);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//甲方账号(货主)
var firstAccount = Request.Params["FirstAccount"];
//乙方账号（司机）
var secondAccount = Request.Params["SecondAccount"];
//交易源ID（货源ID）
var originId = Request.Params["OriginId"];
//订单号
var orderNum = Request.Params["OrderNum"];
//始发地
var SFD = Request.Params["SFD"];
//目的地
var MDD = Request.Params["MDD"];
//交易金额
var amount = Request.Params["Amount"];
//保险是否购买
var insurance = Request.Params["Insurance"];
Dictionary <string, string> info = new Dictionary <string, string>();
try
{
if (firstAccount == null || secondAccount == null || originId == null || orderNum == null || SFD == null || MDD == null || amount == null || insurance == null)
{
info.Add("参数FirstAccount，SecondAccount，OriginId，OrderNum，SFD，MDD，Amount，Insurance不能为空！举例", "http://218.92.115.55/M_Sph/Deal/DealForConsingor.aspx?FirstAccount=1DBAB54785BDB214E053A864016AB214&SecondAccount=1F4BA283C3F95122E053A86401695122&OriginId=931&OrderNum=YGPH201506251507&SFD=江苏省连云港&MDD=安徽省&Amount=100&insurance=1");
Json = JsonConvert.SerializeObject(info);
return;
}
//查询此货物是否已交易
string sql =
string.Format("select * from TB_SPH_ORDER where CODE_CARGO_SOURCE='{0}' and CODE_USER_FIRST='{1}' and CODE_USER_SECOND='{2}'", originId, firstAccount, secondAccount);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathWlxgx).ExecuteTable(sql);
if (dt.Rows.Count != 0)
{
info.Add("IsDeal", "No");
info.Add("Message", "此货源双方正在交易！");
Json = JsonConvert.SerializeObject(info);
return;
}
//插入甲方交易记录
sql =
string.Format("insert into TB_SPH_ORDER (CODE_CARGO_SOURCE,sfd,mdd,amount,CODE_USER_FIRST,DEALTIME_FIRST,MARK_INSURANCE,CODE_USER_SECOND) values('{0}','{1}','{2}','{3}','{4}',to_date('{5}','YYYY-MM-DD HH24:MI:SS'),'{6}','{7}')", originId, SFD, MDD, amount, firstAccount, DateTime.Now, insurance, secondAccount);
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathWlxgx).ExecuteTable(sql);
sql =
string.Format("select * from TB_SPH_ORDER where CODE_CARGO_SOURCE = '{0}' and CODE_USER_FIRST='{1}' and CODE_USER_SECOND='{2}'", originId, firstAccount, secondAccount);
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathWlxgx).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
info.Add("IsDeal", "No");
info.Add("Message", "网络错误，请稍后再试！");
}
else
{
info.Add("IsDeal", "Yes");
info.Add("Message", "已发起成交！");
}
Json = JsonConvert.SerializeObject(info);
}
catch (Exception ex)
{
info.Add("IsDeal", "No");
info.Add("Message", string.Format("{0}：提交数据发生异常。{1}", ex.Source, ex.Message));
Json = JsonConvert.SerializeObject(info);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//用户ID
var userCode = Request.Params["UserCode"];
Dictionary <string, Array> info = new Dictionary <string, Array>();
try
{
if (userCode == null)
{
string[] arry = new string[1];
arry[0] = "举例：http://218.92.115.55/wlkg/Service/Approval/BillingApproval/GetDelegationList.aspx?UserCode=1";
info.Add("参数UserCode不能为null！", arry);
Json = JsonConvert.SerializeObject(info);
return;
}
string sql =
string.Format(
@"SELECT id, shipname, voyage, blno, cargo_name, blno_count, clientshort, fanghuo, remark, iport_dept
FROM view_all_delegation_eas
WHERE EXISTS(SELECT * FROM ACCESS_CONTROL WHERE CODE_USER='******' AND VIEW_ALL_DELEGATION_EAS.IPORT_DEPT=ACCESS_CONTROL.CODE_DEPARTMENT)
AND IPORT_DEPT in (select code_department FROM ACCESS_CONTROL WHERE CODE_USER='******' )",
userCode);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathLbts).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
string[] arry0 = new string[1];
arry0[0] = "No";
info.Add("IsGet", arry0);
string[] arry1 = new string[1];
arry1[0] = "暂无委托信息！";
info.Add("Message", arry1);
Json = JsonConvert.SerializeObject(info);
return;
}
string[,] arrys = new string[dt.Rows.Count, 10];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
arrys[iRow, 0] = Convert.ToString(dt.Rows[iRow]["id"]);
arrys[iRow, 1] = Convert.ToString(dt.Rows[iRow]["shipname"]);
arrys[iRow, 2] = Convert.ToString(dt.Rows[iRow]["voyage"]);
arrys[iRow, 3] = Convert.ToString(dt.Rows[iRow]["blno"]);
arrys[iRow, 4] = Convert.ToString(dt.Rows[iRow]["cargo_name"]);
arrys[iRow, 5] = Convert.ToString(dt.Rows[iRow]["blno_count"]);
arrys[iRow, 6] = Convert.ToString(dt.Rows[iRow]["clientshort"]);
arrys[iRow, 7] = Convert.ToString(dt.Rows[iRow]["fanghuo"]);
arrys[iRow, 8] = Convert.ToString(dt.Rows[iRow]["remark"]);
arrys[iRow, 9] = Convert.ToString(dt.Rows[iRow]["iport_dept"]);
}
string[] arry2 = new string[1];
arry2[0] = "Yes";
info.Add("IsGet", arry2);
info.Add("DelegationList", arrys);
Json = JsonConvert.SerializeObject(info);
}
catch (Exception ex)
{
string[] arry0 = new string[1];
arry0[0] = "No";
info.Add("IsGet", arry0);
string[] arry1 = new string[1];
arry1[0] = "服务器异常：" + ex.Message;
info.Add("Message", arry1);
Json = JsonConvert.SerializeObject(info);
}
}
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)
{
//数据起始行
var startRow = Request.Params["StartRow"];
//行数
var count = Request.Params["Count"];
//始发地省
var SFDProvince = Request.Params["SFDProvince"];
//始发地市
var SFDCity = Request.Params["SFDCity"];
//始发地区
var SFDCounty = Request.Params["SFDCounty"];
//目的地省
var MDDProvince = Request.Params["MDDProvince"];
//目的地市
var MDDCity = Request.Params["MDDCity"];
//目的地区
var MDDCount = Request.Params["MDDCounty"];
//货物
var cargo = Request.Params["Cargo"];
//车型
var vehicleType = Request.Params["VehicleType"];
//关键字
string strKeyWord = Request.Params["KeyWord"];
//SFDProvince = "江苏";
////SFDCity = "";
//MDDProvince = "江苏";
//MDDCity = "";
//startRow = "1";
//count = "2";
//cargo = "铁矿砂";
//strKeyWord = "江苏省";
Dictionary <string, Array> info = new Dictionary <string, Array>();
try
{
if (startRow == null || count == null)
{
string[] arry0 = new string[1];
arry0[0] = "NO";
info.Add("IsFind", arry0);
string[] arry1 = new string[1];
arry1[0] = "举例：http://218.92.115.55/M_Sph/Goods/FindGoods.aspx?StartRow=1&Count=15";
info.Add("参数StartRow，Count不能为null！", arry1);
Json = JsonConvert.SerializeObject(info);
return;
}
string filter = string.Empty;
//始发地省、市、区
if (!string.IsNullOrWhiteSpace(SFDProvince) && SFDProvince != "全国")
{
filter += string.Format("sfd_province like '%{0}%' and ", SFDProvince);
if (!string.IsNullOrWhiteSpace(SFDCity))
{
filter += string.Format("sfd_city like '%{0}%' and ", SFDCity);
if (!string.IsNullOrWhiteSpace(SFDCounty))
{
filter += string.Format("sfd_county like '%{0}%' and ", SFDCounty);
}
}
}
//目的地省、市、区
if (!string.IsNullOrWhiteSpace(MDDProvince) && MDDProvince != "全国")
{
filter += string.Format("mdd_province like '%{0}%' and ", MDDProvince);
if (!string.IsNullOrWhiteSpace(MDDCity))
{
filter += string.Format("mdd_city like '%{0}%' and ", MDDCity);
if (!string.IsNullOrWhiteSpace(MDDCount))
{
filter += string.Format("mdd_county like '%{0}%' and ", MDDCount);
}
}
}
//货物名称
if (!string.IsNullOrWhiteSpace(cargo))
{
filter += string.Format("cargoname='{0}' and ", cargo);
}
//车型
if (!string.IsNullOrWhiteSpace(vehicleType))
{
filter += string.Format("vehicletype='{0}' and ", vehicleType);
}
//关键词
if (!string.IsNullOrWhiteSpace(strKeyWord))
{
string filterKeyWord = string.Format(@"sfd_province like '%{0}%' or sfd_city like '%{0}%' or sfd_county like '%{0}%' or sfd_address like '%{0}% '
or mdd_province like '%{0}%' or mdd_city like '%{0}%' or mdd_county like '%{0}%' or mdd_address like '%{0}% '
or cargoname like '%{0}%' or vehicletype like '%{0}%' or contact_man like '%{0}%' or mobile like '%{0}%' and",
strKeyWord);
if (!string.IsNullOrWhiteSpace(filter))
{
filter = filter.Remove(filter.Length - 5, 5);
filter = filter + " or " + filterKeyWord;
}
else
{
filter += filterKeyWord;
}
}
if (!string.IsNullOrWhiteSpace(filter))
{
filter = " where " + filter + " is_end ='0'";
}
else
{
filter = " where is_end ='0'";
}
string sql =
string.Format(@"select distinct *
from TB_DMT_CARGO {0}
order by opeartetime desc",
filter);
var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathWlxgx).ExecuteTable(sql, Convert.ToInt32(startRow), Convert.ToInt32(startRow) + Convert.ToInt32(count) - 1);
if (dt.Rows.Count <= 0)
{
string[] arry0 = new string[1];
arry0[0] = "NO";
info.Add("IsFind", arry0);
string[] arry1 = new string[1];
arry1[0] = startRow == "1" ? "暂无数据！" : "暂无更多数据！";
info.Add("Message", arry1);
Json = JsonConvert.SerializeObject(info);
return;
}
string[,] ary = new string[dt.Rows.Count, 19];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
ary[iRow, 0] = dt.Rows[iRow]["pkid"].ToString();
ary[iRow, 1] = dt.Rows[iRow]["sfd_province"].ToString();
ary[iRow, 2] = dt.Rows[iRow]["sfd_city"].ToString();
ary[iRow, 3] = dt.Rows[iRow]["sfd_county"].ToString();
ary[iRow, 4] = dt.Rows[iRow]["mdd_province"].ToString();
ary[iRow, 5] = dt.Rows[iRow]["mdd_city"].ToString();
ary[iRow, 6] = dt.Rows[iRow]["mdd_county"].ToString();
ary[iRow, 7] = dt.Rows[iRow]["cargoname"].ToString();
ary[iRow, 8] = dt.Rows[iRow]["weight"].ToString();
ary[iRow, 9] = dt.Rows[iRow]["volume"].ToString();
ary[iRow, 10] = dt.Rows[iRow]["vehiclelen"].ToString();
ary[iRow, 11] = dt.Rows[iRow]["vehicletype"].ToString();
ary[iRow, 12] = dt.Rows[iRow]["mobile"].ToString();
ary[iRow, 13] = dt.Rows[iRow]["phone"].ToString();
ary[iRow, 14] = dt.Rows[iRow]["opeartetime"].ToString();
ary[iRow, 15] = dt.Rows[iRow]["diatance"].ToString();
ary[iRow, 16] = dt.Rows[iRow]["contact_man"].ToString();
ary[iRow, 17] = dt.Rows[iRow]["sfd_address"].ToString();
ary[iRow, 18] = dt.Rows[iRow]["mdd_address"].ToString();
}
string[] arry2 = new string[1];
arry2[0] = "Yes";
info.Add("IsFind", arry2);
string[] arry3 = new string[1];
info.Add("GoodsReleasing", ary);
Json = JsonConvert.SerializeObject(info);
}
catch (Exception ex)
{
string[] arry0 = new string[1];
arry0[0] = "NO";
info.Add("IsFind", arry0);
string[] arry1 = new string[1];
arry1[0] = string.Format("{0}：获取数据发生异常。{1}", ex.Source, ex.Message);
info.Add("Message", arry1);
Json = JsonConvert.SerializeObject(info);
}
}
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)
{
//用户编码
var codeUser = Request.Params["CodeUser"];
Dictionary <string, string> info = new Dictionary <string, string>();
try
{
if (codeUser == null)
{
info.Add("IsRepeal", "No");
info.Add("参数Account不能为空！举例", "http://218.92.115.55/M_Sph/Vehicle/RepealVehicle.aspx?CodeUser=1DA60DDD8025725AE053A864016A725");
Json = JsonConvert.SerializeObject(info);
return;
}
//撤销车源
string sql =
string.Format("select * from TB_SPH_EMPTY_VEHICLE where code_user='******' order by releasetime desc", codeUser);
var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathWlxgx).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
info.Add("IsRepeal", "No");
info.Add("Message", "网络错误，请稍后再试！");
}
else
{
if (dt.Rows[0]["mark_repeal"].ToString() == "0")
{
sql =
string.Format("update TB_SPH_EMPTY_VEHICLE set mark_repeal='{0}' where code_user='******' and mark_repeal='{2}'", "1", codeUser, "0");
dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathWlxgx).ExecuteTable(sql);
sql =
string.Format("select * from TB_SPH_EMPTY_VEHICLE where code_user='******'", codeUser);
dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathWlxgx).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
info.Add("IsRepeal", "No");
info.Add("Message", "网络错误，请稍后再试！");
}
else
{
if (Convert.ToString(dt.Rows[0]["mark_repeal"]) == "1")
{
info.Add("IsRepeal", "Yes");
info.Add("Message", "撤销成功！");
}
else
{
info.Add("IsRepeal", "No");
info.Add("Message", "网络错误，请稍后再试！");
}
}
}
else if (dt.Rows[0]["mark_repeal"].ToString() == "1")
{
info.Add("IsRepeal", "No");
info.Add("Message", "此车源已被撤销！");
}
}
Json = JsonConvert.SerializeObject(info);
}
catch (Exception ex)
{
info.Add("IsRepeal", "No");
info.Add("Message", string.Format("{0}：提交数据发生异常。{1}", ex.Source, ex.Message));
Json = JsonConvert.SerializeObject(info);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//数据起始行
var startRow = Request.Params["StartRow"];
//行数
var count = Request.Params["Count"];
//公司编码
var codeCompany = Request.Params["CodeCompany"];
//货物
var cargo = Request.Params["Cargo"];
//货主
var cargoOwner = Request.Params["CargoOwner"];
//货代
var client = Request.Params["Client"];
//货场
var storage = Request.Params["Storage"];
cargo = cargo == null ? string.Empty : cargo;
cargoOwner = cargoOwner == null ? string.Empty : cargoOwner;
client = client == null ? string.Empty : client;
storage = storage == null ? string.Empty : storage;
//startRow = "1";
//count = "15";
//cargo = "煤炭";
//cargoOwner = "北京弘帆";
codeCompany = "693";
try
{
if (startRow == null || count == null || codeCompany == null)
{
string warning = string.Format("参数StartRow，Count，CodeCompany不能为null！举例：http://218.92.115.55/M_Lhgl/Service/Stock/GetStock.aspx?StartRow=1&Count=14&CodeCompany=14");
Json = JsonConvert.SerializeObject(new DicPackage(false, null, warning).DicInfo());
return;
}
string strFilter = string.Empty;
string strTable = "VW_HS_STOCKDORMANT a";
if (!string.IsNullOrWhiteSpace(codeCompany))
{
strFilter += string.Format("a.code_company='{0}' and ", codeCompany);
}
if (!string.IsNullOrWhiteSpace(cargo))
{
strFilter += string.Format("a.cargo='{0}' and ", cargo);
}
if (!string.IsNullOrWhiteSpace(cargoOwner))
{
strFilter += string.Format("a.cargoowner='{0}' and ", cargoOwner);
}
if (!string.IsNullOrWhiteSpace(client))
{
strFilter += string.Format("a.client='{0}' and ", client);
}
if (!string.IsNullOrWhiteSpace(storage))
{
strFilter += string.Format("a.storage='{0}' and ", storage);
}
if (!string.IsNullOrWhiteSpace(strFilter))
{
strFilter = strFilter.Remove(strFilter.Length - 5, 5);
strFilter = " where " + strFilter;
}
string strSql =
string.Format(@"select a.gbno,a.cargoowner,a.cargo,a.vgdisplay,a.client,a.storage,a.weight,a.code_storage,code_booth
from {0}{1} order by a.storagetype,a.storage",
strTable, strFilter);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathJHHarbor).ExecuteTable(strSql, Convert.ToInt32(startRow), Convert.ToInt32(startRow) + Convert.ToInt32(count) - 1);
if (dt.Rows.Count <= 0)
{
string strWarning = startRow == "1" ? "暂无数据！" : "暂无更多数据！";
Json = JsonConvert.SerializeObject(new DicPackage(false, null, strWarning).DicInfo());
return;
}
string[,] strArray = new string[dt.Rows.Count, 9];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
strArray[iRow, 0] = Convert.ToString(dt.Rows[iRow]["gbno"]);
strArray[iRow, 1] = Convert.ToString(dt.Rows[iRow]["cargoowner"]);
strArray[iRow, 2] = Convert.ToString(dt.Rows[iRow]["cargo"]);
strArray[iRow, 3] = Convert.ToString(dt.Rows[iRow]["vgdisplay"]);
strArray[iRow, 4] = Convert.ToString(dt.Rows[iRow]["client"]);
strArray[iRow, 5] = Convert.ToString(dt.Rows[iRow]["storage"]);
strArray[iRow, 6] = Convert.ToString(dt.Rows[iRow]["weight"]);
strArray[iRow, 7] = Convert.ToString(dt.Rows[iRow]["code_storage"]);
strArray[iRow, 8] = Convert.ToString(dt.Rows[iRow]["code_booth"]);
}
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)
{
//数据起始行
var startRow = Request.Params["StartRow"];
//行数
var count = Request.Params["Count"];
//用户编码
var codeUser = Request.Params["CodeUser"];
//理货日期
var tallyDate = Request.Params["TallyDate"];
//白夜班
var dayNight = Request.Params["DayNight"];
tallyDate = tallyDate == null ? string.Empty : tallyDate;
dayNight = dayNight == null ? string.Empty : dayNight;
dayNight = "白班";
//tallyDate = "2016-01-07";
codeUser = "******";
//startRow = "1";
//count = "15";
//cargo = "煤炭";
//taskNo = "北京弘帆";
try
{
if (startRow == null || count == null || codeUser == null)
{
string warning = string.Format("参数StartRow，Count，CodeUser不能为null！举例：http://218.92.115.55/M_DL_Gwtxc/Service/Slip/GetMissionCommand.aspx?StartRow=1&Count=14&CodeUser=71B4CD89E6654D84B8AED9116DDB1C4C");
Json = JsonConvert.SerializeObject(new DicPackage(false, null, warning).DicInfo());
return;
}
string strFilter = string.Empty;
string strTable = "vw_ps_mission_ma a";
if (!string.IsNullOrWhiteSpace(codeUser))
{
strFilter += string.Format("a.code_tallyman2='{0}' and ", codeUser);
}
if (!string.IsNullOrWhiteSpace(tallyDate))
{
strFilter += string.Format("a.tallydate=to_date('{0}', 'yyyy/mm/dd') and ", Convert.ToDateTime(tallyDate).ToShortDateString());
}
if (!string.IsNullOrWhiteSpace(dayNight))
{
dayNight = dayNight == "白班" ? "1" : "2";
strFilter += string.Format("a.code_worktime='{0}' and ", dayNight);
}
if (!string.IsNullOrWhiteSpace(strFilter))
{
strFilter = strFilter.Remove(strFilter.Length - 5, 5);
strFilter = " where " + strFilter;
}
string strSql =
string.Format(@"select a.pmno,a.cgno,a.client,a.taskno,a.cargo,a.operation,a.planweight,a.begintime,a.endtime,a.carrier1,a.carrier2
from {0}{1} order by a.tallydate desc",
strTable, strFilter);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathNewHarbor).ExecuteTable(strSql, Convert.ToInt32(startRow), Convert.ToInt32(startRow) + Convert.ToInt32(count) - 1);
if (dt.Rows.Count <= 0)
{
string strWarning = startRow == "1" ? "暂无数据！" : "暂无更多数据！";
Json = JsonConvert.SerializeObject(new DicPackage(false, null, strWarning).DicInfo());
return;
}
string[,] strArray = new string[dt.Rows.Count, 14];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
strArray[iRow, 0] = Convert.ToString(dt.Rows[iRow]["pmno"]);
strArray[iRow, 1] = Convert.ToString(dt.Rows[iRow]["cgno"]);
strArray[iRow, 2] = string.Empty;
strArray[iRow, 3] = Convert.ToString(dt.Rows[iRow]["client"]);
strArray[iRow, 4] = Convert.ToString(dt.Rows[iRow]["taskno"]);
strArray[iRow, 5] = Convert.ToString(dt.Rows[iRow]["cargo"]);
strArray[iRow, 6] = Convert.ToString(dt.Rows[iRow]["operation"]);
strArray[iRow, 7] = Convert.ToString(dt.Rows[iRow]["planweight"]);
strArray[iRow, 8] = string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["begintime"])) == true ? string.Empty : StringTool.ToDayNightForSql(Convert.ToString(dt.Rows[iRow]["begintime"]));
strArray[iRow, 9] = string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["endtime"])) == true ? string.Empty : StringTool.ToDayNightForSql(Convert.ToString(dt.Rows[iRow]["endtime"]));
strArray[iRow, 10] = Convert.ToString(dt.Rows[iRow]["carrier1"]);
strArray[iRow, 11] = Convert.ToString(dt.Rows[iRow]["carrier2"]);
strArray[iRow, 12] = string.Empty;
strArray[iRow, 13] = string.Empty;
}
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)
{
//数据起始行
var startRow = Request.Params["StartRow"];
//行数
var count = Request.Params["Count"];
//公司编码
var codeCompany = Request.Params["CodeCompany"];
//泊位
var nberth = Request.Params["Nberth"];
//过程
var operationFact = Request.Params["OperationFact"];
//开始时间
var beginTime = Request.Params["BeginTime"];
//结束时间
var endTime = Request.Params["EndTime"];
//货名
var cargo = Request.Params["Cargo"];
nberth = nberth == null ? string.Empty : nberth;
operationFact = operationFact == null ? string.Empty : operationFact;
beginTime = beginTime == null ? string.Empty : beginTime;
endTime = endTime == null ? string.Empty : endTime;
cargo = cargo == null ? string.Empty : cargo;
//startRow = "1";
//count = "15";
//cargo = "煤炭";
//cargoOwner = "北京弘帆";
try
{
if (startRow == null || count == null || codeCompany == null)
{
string warning = string.Format("参数StartRow，Count，CodeCompany不能为null！举例：http://218.92.115.55/M_Lhgl/Service/Plan/GetOperationPlan.aspx?StartRow=1&Count=14&CodeCompany=14");
Json = JsonConvert.SerializeObject(new DicPackage(false, null, warning).DicInfo());
return;
}
string strFilter = string.Empty;
string strTable = "vw_ps_mission_yardplan1 a";
if (!string.IsNullOrWhiteSpace(codeCompany))
{
strFilter += string.Format("a.code_company='{0}' and ", codeCompany);
}
if (!string.IsNullOrWhiteSpace(nberth))
{
strFilter += string.Format("a.nberthlast='{0}' and ", nberth);
}
if (!string.IsNullOrWhiteSpace(operationFact))
{
strFilter += string.Format("a.operation_fact='{0}' and ", operationFact);
}
if (!string.IsNullOrWhiteSpace(beginTime))
{
strFilter += string.Format("a.begintime='{0}' and ", beginTime);
}
if (!string.IsNullOrWhiteSpace(endTime))
{
strFilter += string.Format("a.endtime='{0}' and ", endTime);
}
if (!string.IsNullOrWhiteSpace(cargo))
{
strFilter += string.Format("a.cargo='{0}' and ", cargo);
}
if (!string.IsNullOrWhiteSpace(strFilter))
{
strFilter = strFilter.Remove(strFilter.Length - 5, 5);
strFilter = " where " + strFilter;
}
string strSql =
string.Format(@"select a.cgno,a.nberthlast,a.operation_fact,a.begintime,a.endtime,a.cargo
from {0}{1} order by a.begintime",
strTable, strFilter);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathZCHarbor).ExecuteTable(strSql, Convert.ToInt32(startRow), Convert.ToInt32(startRow) + Convert.ToInt32(count) - 1);
if (dt.Rows.Count <= 0)
{
string strWarning = startRow == "1" ? "暂无数据！" : "暂无更多数据！";
Json = JsonConvert.SerializeObject(new DicPackage(false, null, strWarning).DicInfo());
return;
}
string[,] strArray = new string[dt.Rows.Count, 6];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
strArray[iRow, 0] = Convert.ToString(dt.Rows[iRow]["cgno"]);
strArray[iRow, 1] = Convert.ToString(dt.Rows[iRow]["nberthlast"]);
strArray[iRow, 2] = Convert.ToString(dt.Rows[iRow]["operation_fact"]);
strArray[iRow, 3] = Convert.ToString(dt.Rows[iRow]["begintime"]);
strArray[iRow, 4] = Convert.ToString(dt.Rows[iRow]["endtime"]);
strArray[iRow, 5] = Convert.ToString(dt.Rows[iRow]["cargo"]);;
}
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)
{
//账号
var account = Request.Params["Account"];
//充值金额
var payAmount = Request.Params["PayAmount"];
Dictionary<string, string> info = new Dictionary<string, string>();
try
{
if (account == null)
{
info.Add("IsBalance", "No");
info.Add("参数Account，PayAmount不能为空！举例", "http://218.92.115.55/M_Sph/Fund/PayForDriver.aspx?Account=18000000000&PayAmount=130");
Json = JsonConvert.SerializeObject(info);
return;
}
//获取当前会员资金余额
string sql =
string.Format("select * from TB_YGPH_FUND where account='{0}' and roletype='{1}' order by dealtime desc", account, "1");
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathHmw).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
info.Add("IsBalance", "No");
info.Add("Message", "此会员不存在！");
Json = JsonConvert.SerializeObject(info);
return;
}
double balance = Convert.ToDouble(dt.Rows[0]["balance"]) + Convert.ToDouble(payAmount);
//插入新余额
sql =
string.Format("insert into TB_YGPH_FUND (account,income,balance,dealtime,roletype,content) values('{0}','{1}','{2}',to_date('{3}','YYYY-MM-DD HH24:MI:SS'),'{4}','{5}')", account, payAmount, balance, DateTime.Now, "1", "充值");
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathHmw).ExecuteTable(sql);
sql =
string.Format("select * from TB_YGPH_FUND where account='{0}' and roletype='{1}' order by dealtime desc", account, "1");
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathHmw).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
info.Add("IsPay", "No");
info.Add("Message", "网络错误，请稍后再试！");
}
else
{
if (dt.Rows[0]["balance"].ToString() != balance.ToString())
{
info.Add("IsPay", "No");
info.Add("Message", "网络错误，请稍后再试！");
}
else
{
info.Add("IsPay", "Yes");
info.Add("Message", "充值成功！");
}
}
Json = JsonConvert.SerializeObject(info);
}
catch (Exception ex)
{
info.Add("IsPay", "No");
info.Add("Message", string.Format("{0}：获取数据发生异常。{1}", ex.Source, ex.Message));
Json = JsonConvert.SerializeObject(info);
}
}
protected void Page_Load(object sender, EventArgs e)
{
var codeUser = Request.Params["CodeUser"];
var deviceToken = Request.Params["DeviceToken"];
var deviceType = Request.Params["DeviceType"];
var appName = Request.Params["AppName"];
var isBinding = Request.Params["IsBinding"];
Dictionary <string, string> info = new Dictionary <string, string>();
try
{
if (codeUser == null || deviceToken == null || deviceType == null || appName == null)
{
info.Add("参数CodeUser，DeviceToken，DeviceType，AppName不能为空！", "举例：http://218.92.115.55/MobilePlatform/DeviceBinding.aspx?CodeUser=0000&DeviceToken=aaaaaa&DeviceType=iOS&AppName=HMW&IsBinding=0");
Json = JsonConvert.SerializeObject(info);
return;
}
string sql = string.Format("select * from tb_app_device where Code_User='******' and appname='{1}'", codeUser, appName);
var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMa).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
info.Add("IsBinding", "No");
info.Add("Message", "登陆出错！");
Json = JsonConvert.SerializeObject(info);
return;
}
else
{
if (dt.Rows[0]["isbinding"].ToString() == "1" && isBinding == "1")
{
info.Add("IsBinding", "No");
info.Add("Message", "当前用户已被绑定！");
Json = JsonConvert.SerializeObject(info);
return;
}
else
{
sql =
string.Format("update tb_app_device set devicetoken='{0}',devicetype='{1}',isbinding='{2}',modifytime=to_date('{5}','YYYY-MM-DD HH24:MI:SS') where code_user='******' and appname='{4}'", deviceToken, deviceType, isBinding, codeUser, appName, DateTime.Now);
}
}
dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMa).ExecuteTable(sql);
sql = string.Format("select devicetoken,isbinding from tb_app_device where Code_User='******' and appname='{1}'", codeUser, appName);
dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathMa).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
info.Add("IsBinding", "No");
info.Add("Message", "网络错误，请稍后再试！");
}
else
{
if (dt.Rows[0]["devicetoken"].ToString() == deviceToken)
{
if (dt.Rows[0]["isbinding"].ToString() == isBinding)
{
switch (isBinding)
{
case "0":
info.Add("IsBinding", "Yes");
info.Add("Message", "解绑成功！");
break;
case "1":
info.Add("IsBinding", "Yes");
info.Add("Message", "绑定成功！");
break;
default:
info.Add("IsBinding", "No");
info.Add("Message", "网络错误，请稍后再试！！");
break;
}
}
}
}
Json = JsonConvert.SerializeObject(info);
}
catch (Exception ex)
{
info.Add("IsBinding", "No");
info.Add("Message", ex.Message);
Json = JsonConvert.SerializeObject(info);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//派工编码
var pmno = Request.Params["Pmno"];
//委托编码
var cgno = Request.Params["Cgno"];
//理货单编码
var tbno = Request.Params["Tbno"];
try
{
//
// 非调发 ?Pmno=20151010000161&Cgno=d1bff20fa2d54a0b87e4385a5cb46914
// ?Pmno=20151021000241&Cgno=c14ba9abd9694d9b8e40250c5891b360
// 调发 ?Pmno=20151009000121&Cgno=b02fb038209f4008bedfba6f27966efe
//
if (pmno == null || cgno == null || tbno == null)
{
string warning = string.Format("参数Pmno，Cgno，Tbno不能为nul！举例：http://218.92.115.55/M_Lhgl/Service/Slip/GetSavedGoodsBill.aspx?Pmno=20151212000565&Cgno=8f18014480034dbdb3f5c234ccd35b1f&Tbno=20151221066196");
Json = JsonConvert.SerializeObject(new DicPackage(false, null, warning).DicInfo());
return;
}
string strGbdisplay = string.Empty;
string strGbdisplaylast = string.Empty;
string strSql =
string.Format(@"select gbdisplay,gbdisplaylast
from VW_REG_TALLYBILL
where tbno='{0}'",
tbno);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathZCHarbor).ExecuteTable(strSql);
if (dt.Rows.Count > 0)
{
strGbdisplay = Convert.ToString(dt.Rows[0]["gbdisplay"]);
strGbdisplaylast = Convert.ToString(dt.Rows[0]["gbdisplaylast"]);
}
//获取基础数据
Json = GetBaseData(pmno, cgno);
if (Json != string.Empty)
{
return;
}
goodBillE.StrGoodsBill1Name = "销账票货";
goodBillE.StrGoodsBill2Name = "商务销账";
if (goodBillE.StrMarkExchange == "0")//非调发
{
Json = GetGoodsBillForNoAdjust(cgno, strGbdisplay, strGbdisplaylast);
}
else//调发
{
Json = GetGoodsBillForAdjust(cgno, strGbdisplay, strGbdisplaylast);
}
}
catch (Exception ex)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：获取数据发生异常。{1}", ex.Source, ex.Message)).DicInfo());
}
}
protected void Page_Load(object sender, EventArgs e)
{
//用户编码
var codeUser = Request.Params["CodeUser"];
Dictionary <string, string> info = new Dictionary <string, string>();
try
{
if (codeUser == null)
{
info.Add("IsInfo", "No");
info.Add("参数CodeUser不能为null！", "举例：http://218.92.115.55/M_Sph/UserInfo/InfoForDriver.aspx?CodeUser=1DBAB54785BDB214E053A864016AB214");
Json = JsonConvert.SerializeObject(info);
return;
}
string sql =
string.Format("select * from TB_SPH_USER_AUTH where code_user='******' and roletype='{1}'", codeUser, "1");
//验证此会员是否已认证
var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathWlxgx).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
info.Add("IsInfo", "No");
info.Add("Message", "用户未认证！");
Json = JsonConvert.SerializeObject(info);
return;
}
//查询司机信息
// sql =
// string.Format(@"select b.username,b.identity_card,b.vehiclenum,b.vehiclelen,b.vehicletype,b.tons,b.auditmark_identity,b.auditmark_driving,b.auditmark_vehicle,a.account,a.logogram
// from tb_sph_user a, tb_sph_user_auth b
// where a.code_user=b.code_user and a.code_user='******' and b.roletype='{1}'"
// , codeUser, "1");
sql =
string.Format(@"select b.username,b.identity_card,b.vehiclenum,b.vehiclelen,b.vehicletype,b.tons,b.auditmark_identity,b.auditmark_driving,b.auditmark_vehicle
from tb_sph_user_auth b
where code_user='******' and roletype='{1}'"
, codeUser, "1");
dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathWlxgx).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
info.Add("IsInfo", "No");
info.Add("Message", "网络错误，请稍后再试！");
}
else
{
info.Add("IsInfo", "Yes");
info.Add("UserName", dt.Rows[0]["username"].ToString());
info.Add("IdentityCard", TokenTool.HideIDCard(dt.Rows[0]["identity_card"].ToString()));
info.Add("VehicleNum", dt.Rows[0]["vehiclenum"].ToString());
info.Add("VehicleLen", dt.Rows[0]["vehiclelen"].ToString());
info.Add("VehicleType", dt.Rows[0]["vehicletype"].ToString());
info.Add("Tons", dt.Rows[0]["tons"].ToString());
info.Add("AuditMarkIdentity", dt.Rows[0]["auditmark_identity"].ToString());
info.Add("AuditMarkDriving", dt.Rows[0]["auditmark_driving"].ToString());
info.Add("AuditMarkVehicle", dt.Rows[0]["auditmark_vehicle"].ToString());
info.Add("Mobile", string.Empty);
info.Add("Logogram", string.Empty);
}
Json = JsonConvert.SerializeObject(info);
}
catch (Exception ex)
{
info.Add("IsInfo", "No");
info.Add("Message", string.Format("{0}：获取数据发生异常。{1}", ex.Source, ex.Message));
Json = JsonConvert.SerializeObject(info);
}
}
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(c.name)
from con_image i left join TALLY_CLERK c on c.work_no = i.work_no
where i.SHIP_ID = '{0}' AND MOVED = '1' 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 MOVED='1'
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());
}
}
/// <summary>
/// 移动接口身份校验
/// </summary>
/// <param name="Request">Http请求对象</param>
/// <returns></returns>
public static bool IdentityVerify(HttpRequest Request)
{
//应用名称
string strAppName = Request.Params["AppName"];
//签名
string strSign = Request.Params["Sign"];
if (string.IsNullOrWhiteSpace(strAppName) || string.IsNullOrWhiteSpace(strSign))
{
return(false);
}
//拼接令牌
string strSql =
string.Format(@"select token
from VW_APP_TOKEN
where appname='{0}'",
strAppName);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathMa).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
return(false);
}
//键值数组
string[] strKeyList = null;
if (Request.QueryString.Count != 0)
{
strKeyList = new string[Request.QueryString.Count];
Request.QueryString.AllKeys.CopyTo(strKeyList, 0);
}
else if (Request.Form.Count != 0)
{
strKeyList = new string[Request.Form.Count];
Request.Form.AllKeys.CopyTo(strKeyList, 0);
}
//键值排序
Array.Sort(strKeyList);
string strSet = string.Empty;
//拼接（参数名+参数）
for (int iKey = 0; iKey < strKeyList.Length; iKey++)
{
string strKey = strKeyList[iKey];
if (strKey == "Sign")
{
continue;
}
strSet += strKeyList[iKey] + Request.Params[strKey];
}
strSet += Convert.ToString(dt.Rows[0]["token"]);
//身份校验(拼接字符串MD5加密与签名比较)
//if (EncryptionTool.MD5Encrypt(strSet) != strSign.ToUpper())
//{
// return false;
//}
string strMD5 = EncryptionTool.MD5Encrypt(strSet);
if (strMD5 != strSign.ToUpper())
{
return(false);
}
return(true);
}
protected void Page_Load(object sender, EventArgs e)
{
//派工编码
var pmno = Request.Params["Pmno"];
//委托编码
var cgno = Request.Params["Cgno"];
//pmno = "20160107001001";
//cgno = "a182b39682434432a71794ee4892eeb4";
try
{
if (pmno == null || cgno == null)
{
string warning = string.Format("参数Pmno，Cgno不能为nul！举例：http://218.92.115.55/M_DL_Gwtxc/Service/Slip/GetAllTallyBill.aspx?Pmno=20160107001001&Cgno=a182b39682434432a71794ee4892eeb4");
Json = JsonConvert.SerializeObject(new DicPackage(false, null, warning).DicInfo());
return;
}
string strSql =
string.Format(@"select a.tbno,a.gbno,a.gbdisplay,a.gbnolast,a.gbdisplaylast,a.taskno,a.weight,a.amount,a.amount2,b.code_carrier_s,b.code_carrier_e,a.carrier1,a.carrier1num,a.carrier2,a.carrier2num,a.mark_finish
from VW_REG_TALLYBILL a, vw_ps_mission b
where a.pmno=b.pmno and a.pmno='{0}' and a.cgno='{1}' order by a.mark_finish asc, a.modifytime desc", pmno, cgno);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathNewHarbor).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "暂无数据！").DicInfo());
return;
}
string[,] strArray = new string[dt.Rows.Count, 8];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
string strCount = string.Empty;
if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["amount"])) && Convert.ToString(dt.Rows[iRow]["amount"]) != "0")
{
strCount += string.Format("{0}件", Convert.ToString(dt.Rows[iRow]["amount"])) + "/";;
}
if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["amount2"])) && Convert.ToString(dt.Rows[iRow]["amount2"]) != "0")
{
strCount += string.Format("{0}件2", Convert.ToString(dt.Rows[iRow]["amount2"])) + "/";;
}
if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["weight"])) && Convert.ToString(dt.Rows[iRow]["weight"]) != "0")
{
strCount += string.Format("{0}吨", Convert.ToString(dt.Rows[iRow]["weight"])) + "/";;
}
if (!string.IsNullOrWhiteSpace(strCount))
{
strCount = strCount.Remove(strCount.Length - 1, 1);
}
string strCarrier1 = string.Empty;
if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["carrier1"])))
{
strCarrier1 += string.Format("{0}", Convert.ToString(dt.Rows[iRow]["carrier1"])) + "/";;
}
if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["carrier1num"])))
{
strCarrier1 += string.Format("{0}", Convert.ToString(dt.Rows[iRow]["carrier1num"])) + "/";;
}
if (!string.IsNullOrWhiteSpace(strCarrier1))
{
strCarrier1 = strCarrier1.Remove(strCarrier1.Length - 1, 1);
}
string strCarrier2 = string.Empty;
if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["carrier2"])))
{
strCarrier2 += string.Format("{0}", Convert.ToString(dt.Rows[iRow]["carrier2"])) + "/";;
}
if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["carrier2num"])))
{
strCarrier2 += string.Format("{0}", Convert.ToString(dt.Rows[iRow]["carrier2num"])) + "/";;
}
if (!string.IsNullOrWhiteSpace(strCarrier2))
{
strCarrier2 = strCarrier2.Remove(strCarrier2.Length - 1, 1);
}
string strGbDisplayLast = string.Empty;
string strMarkLast = string.Empty;
strSql =
string.Format("select mark_last from TB_HC_CONSIGN_GBNO where cgno='{0}' and gbno='{1}'", cgno, Convert.ToString(dt.Rows[iRow]["gbnolast"]));
var dt1 = new Leo.Oracle.DataAccess(RegistryKey.KeyPathNewHarbor).ExecuteTable(strSql);
if (dt1.Rows.Count > 0)
{
strMarkLast = Convert.ToString(dt1.Rows[0]["mark_last"]);
}
if (strMarkLast == "1")
{
strGbDisplayLast = Convert.ToString(dt.Rows[iRow]["gbdisplaylast"]);
}
strArray[iRow, 0] = Convert.ToString(dt.Rows[iRow]["tbno"]);
strArray[iRow, 1] = Convert.ToString(dt.Rows[iRow]["gbdisplay"]);
strArray[iRow, 2] = strGbDisplayLast;
strArray[iRow, 3] = strCarrier1;
strArray[iRow, 4] = strCarrier2;
strArray[iRow, 5] = Convert.ToString(dt.Rows[iRow]["taskno"]);
strArray[iRow, 6] = strCount;
strArray[iRow, 7] = Convert.ToString(dt.Rows[iRow]["mark_finish"]);
}
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 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"];
//验证码
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)
{
//数据起始行
var startRow = Request.Params["StartRow"];
//行数
var count = Request.Params["Count"];
//公司编码
var codeCompany = Request.Params["CodeCompany"];
//起始时间
var startTime = Request.Params["StartTime"];
//终止时间
var endTime = Request.Params["EndTime"];
//货物
var cargo = Request.Params["Cargo"];
//货主
var cargoOwner = Request.Params["CargoOwner"];
//航次
var voyage = Request.Params["Voyage"];
//作业过程
var operation = Request.Params["Operation"];
//委托号
var taskNo = Request.Params["TaskNo"];
//唛头
var mark = Request.Params["Mark"];
//驳船名
var nvessel = Request.Params["Nvessel"];
cargo = cargo == null ? string.Empty : cargo;
voyage = voyage == null ? string.Empty : voyage;
taskNo = taskNo == null ? string.Empty : taskNo;
mark = mark == null ? string.Empty : mark;
nvessel = nvessel == null ? string.Empty : nvessel;
//codeCompany = "14";
startRow = "1";
count = "15";
//startTime = "2015-01-18";
//endTime = "2015-10-18";
//cargo = "煤炭";
//cargoOwner = "北京弘帆";
try
{
if (startRow == null || count == null || codeCompany == null || startTime == null || endTime == null)
{
string warning = string.Format("参数StartRow，Count，CodeCompany，StartTime，EndTime不能为null！举例：http://218.92.115.55/M_Lhgl/Service/Consign/GetConsign.aspx?StartRow=1&Count=14&CodeCompany=14&StartTime=2015-08-19&EndTime=2015-09-19");
Json = JsonConvert.SerializeObject(new DicPackage(false, null, warning).DicInfo());
return;
}
string strFilter = string.Empty;
string strTable = "VW_HC_CONSIGN a";
if (!string.IsNullOrWhiteSpace(codeCompany))
{
strFilter += string.Format("a.code_company='{0}' and ", codeCompany);
}
if (!string.IsNullOrWhiteSpace(startTime))
{
strFilter += string.Format("a.signdate>=to_date('{0}','yyyy/MM/dd') and ", Convert.ToDateTime(startTime).ToShortDateString());
}
if (!string.IsNullOrWhiteSpace(endTime))
{
strFilter += string.Format("a.signdate<=to_date('{0}','yyyy/MM/dd') and ", Convert.ToDateTime(endTime).ToShortDateString());
}
if (!string.IsNullOrWhiteSpace(cargo))
{
strFilter += string.Format("a.cargo='{0}' and ", cargo);
}
if (!string.IsNullOrWhiteSpace(cargoOwner))
{
strFilter += string.Format("a.cargoowner='{0}' and ", cargoOwner);
}
if (!string.IsNullOrWhiteSpace(voyage))
{
strFilter += string.Format("a.voyage='{0}' and ", voyage);
}
if (!string.IsNullOrWhiteSpace(operation))
{
strFilter += string.Format("a.operation='{0}' and ", operation);
}
if (!string.IsNullOrWhiteSpace(taskNo))
{
strFilter += string.Format("a.taskno like '{0}' and ", taskNo);
}
if (!string.IsNullOrWhiteSpace(mark))
{
strFilter += string.Format("a.mark like '{0}' and ", mark);
}
if (!string.IsNullOrWhiteSpace(nvessel))
{
strFilter += string.Format("b.nvessel like '{0}' and ", mark);
strFilter += "a.cgno=b.cgno and ";
strTable = "VW_HC_CONSIGN a, VW_HC_CONSIGNSHIP b";
}
if (!string.IsNullOrWhiteSpace(strFilter))
{
strFilter = strFilter.Remove(strFilter.Length - 5, 5);
strFilter = " where " + strFilter;
}
string strSql =
string.Format(@"select a.cgno,a.cargoowner,a.cargo,a.voyage,a.operation,a.taskno,a.planamount,a.planweight
from {0}{1} order by a.signdate desc",
strTable, strFilter);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathZCHarbor).ExecuteTable(strSql, Convert.ToInt32(startRow), Convert.ToInt32(startRow) + Convert.ToInt32(count) - 1);
if (dt.Rows.Count <= 0)
{
string strWarning = startRow == "1" ? "暂无数据！" : "暂无更多数据！";
Json = JsonConvert.SerializeObject(new DicPackage(false, null, strWarning).DicInfo());
return;
}
string[,] strArray = new string[dt.Rows.Count, 8];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
strArray[iRow, 0] = Convert.ToString(dt.Rows[iRow]["cgno"]);
strArray[iRow, 1] = Convert.ToString(dt.Rows[iRow]["cargoowner"]);
strArray[iRow, 2] = Convert.ToString(dt.Rows[iRow]["cargo"]);
strArray[iRow, 3] = Convert.ToString(dt.Rows[iRow]["voyage"]);
strArray[iRow, 4] = Convert.ToString(dt.Rows[iRow]["operation"]);
strArray[iRow, 5] = Convert.ToString(dt.Rows[iRow]["taskno"]);
strArray[iRow, 6] = Convert.ToString(dt.Rows[iRow]["planamount"]);
strArray[iRow, 7] = Convert.ToString(dt.Rows[iRow]["planweight"]);
}
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)
{
//用户编码
var codeUser = Request.Params["CodeUser"];
Dictionary <string, Array> info = new Dictionary <string, Array>();
try
{
if (codeUser == null)
{
string[] arry0 = new string[1];
arry0[0] = "NO";
info.Add("IsGet", arry0);
string[] arry1 = new string[1];
arry1[0] = "举例：http://218.92.115.55/M_Sph/Goods/GetGoodsReleasing.aspx?CodeUser=1DBAB54785BDB214E053A864016AB214";
info.Add("参数CodeUser不能为mull！", arry1);
Json = JsonConvert.SerializeObject(info);
return;
}
//获取用户信息
string sql =
string.Format(@"select a.code_company,b.username, b.authstate
from iport.tb_sys_user a, tb_sph_user_auth b
where a.code_user=b.code_user and a.code_user='******' and b.roletype='{1}'"
, codeUser, "2");
var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathWlxgx).ExecuteTable(sql);
if (dt.Rows.Count == 0 || Convert.ToString(dt.Rows[0]["authstate"]) != "1")
{
string[] arry0 = new string[1];
arry0[0] = "NO";
info.Add("IsGet", arry0);
string[] arry1 = new string[1];
arry1[0] = "用户未认证！";
info.Add("Message", arry1);
Json = JsonConvert.SerializeObject(info);
return;
}
//获取发布中货源
sql =
string.Format("select * from TB_DMT_CARGO where code_user='******' and is_end='{1}' order by opeartetime desc", codeUser, "0");
dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathWlxgx).ExecuteTable(sql);
string[,] ary = new string[dt.Rows.Count, 17];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
ary[iRow, 0] = dt.Rows[iRow]["pkid"].ToString();
ary[iRow, 1] = dt.Rows[iRow]["sfd_province"].ToString();
ary[iRow, 2] = dt.Rows[iRow]["sfd_city"].ToString();
ary[iRow, 3] = dt.Rows[iRow]["sfd_county"].ToString();
ary[iRow, 4] = dt.Rows[iRow]["mdd_province"].ToString();
ary[iRow, 5] = dt.Rows[iRow]["mdd_city"].ToString();
ary[iRow, 6] = dt.Rows[iRow]["mdd_county"].ToString();
ary[iRow, 7] = dt.Rows[iRow]["cargoname"].ToString();
ary[iRow, 8] = dt.Rows[iRow]["weight"].ToString();
ary[iRow, 9] = dt.Rows[iRow]["volume"].ToString();
ary[iRow, 10] = dt.Rows[iRow]["vehiclelen"].ToString();
ary[iRow, 11] = dt.Rows[iRow]["vehicletype"].ToString();
ary[iRow, 12] = dt.Rows[iRow]["mobile"].ToString();
ary[iRow, 13] = dt.Rows[iRow]["phone"].ToString();
ary[iRow, 14] = dt.Rows[iRow]["opeartetime"].ToString();
ary[iRow, 15] = dt.Rows[iRow]["diatance"].ToString();
ary[iRow, 16] = dt.Rows[iRow]["contact_man"].ToString();
}
string[] arry2 = new string[1];
arry2[0] = "Yes";
info.Add("IsGet", arry2);
info.Add("GoodsReleasing", ary);
Json = JsonConvert.SerializeObject(info);
}
catch (Exception ex)
{
string[] arry0 = new string[1];
arry0[0] = "NO";
info.Add("IsGet", arry0);
string[] arry1 = new string[1];
arry1[0] = string.Format("{0}：获取数据发生异常。{1}", ex.Source, ex.Message);
info.Add("Message", arry1);
Json = JsonConvert.SerializeObject(info);
}
}
/// <summary>
/// 获取通过用户名登陆信息
/// </summary>
/// <param name="account">用户名</param>
/// <param name="password">密码</param>
/// <returns>返回结果</returns>
private string GetInfoByUserNameLogin(string account, string password)
{
Dictionary <string, string> info = new Dictionary <string, string>();
string Json = string.Empty;
string codeUser = string.Empty;
string sql =
string.Format("select * from TB_SPH_USER where upper(logogram)='{0}'", account.ToUpper());
//判断用户是否存在
var dt0 = new Leo.Oracle.DataAccess(RegistryKey.KeyPathWlxgx).ExecuteTable(sql);
if (dt0.Rows.Count == 0)
{
sql =
string.Format("select code_user,password,code_company from TB_SYS_USER where upper(logogram) = '{0}'", account.ToUpper());
var dt1 = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathIport).ExecuteTable(sql);
if (dt1.Rows.Count == 0)
{
info.Add("IsLogin", "No");
info.Add("Message", "登陆账号错误！");
Json = JsonConvert.SerializeObject(info);
return(Json);
}//Iport用户表不存在
else
{
if (!Identity.VerifyText(Format.Trim(password), dt1.Rows[0]["password"] as string))
{
info.Add("IsLogin", "No");
info.Add("Message", "密码错误");
Json = JsonConvert.SerializeObject(info);
return(Json);
}
string mobile = string.Empty;
string codeCompany = string.Empty;
string iportCodeUser = string.Empty;
//获取Iport用户电话信息
sql =
string.Format("select mobile from TB_SYS_USERINFO where code_user = '******'", Convert.ToString(dt1.Rows[0]["code_user"]));
var dt2 = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathIport).ExecuteTable(sql);
if (dt2.Rows.Count != 0)
{
mobile = Convert.ToString(dt2.Rows[0]["mobile"]);
}
codeCompany = Convert.ToString(dt1.Rows[0]["code_company"]);
iportCodeUser = Convert.ToString(dt1.Rows[0]["code_user"]);
//查询此账号（手机号）是否已注册
sql =
string.Format("select * from TB_SPH_USER where account='{0}'", mobile);
//判断用户（手机号）是否存在
var dt3 = new Leo.Oracle.DataAccess(RegistryKey.KeyPathWlxgx).ExecuteTable(sql);
if (dt3.Rows.Count != 0)
{
info.Add("IsLogin", "No");
info.Add("Message", "您已用手机号进行注册，可以联系客服！");
Json = JsonConvert.SerializeObject(info);
return(Json);
}
//App使用截止时间
string timeType = "MONTH";
int timeInterval = 3;
DateTime endTime;
switch (timeType)
{
case "DAY":
endTime = DateTime.Now.AddDays(timeInterval);
break;
case "MONTH":
endTime = DateTime.Now.AddMonths(timeInterval);
break;
case "YEAR":
endTime = DateTime.Now.AddYears(timeInterval);
break;
default:
throw new Exception("错误的对象索引");
}
//sph用户表插入新用户信息
sql =
string.Format(@"insert into TB_SPH_USER (account, logogram, code_company, endtime, usertype, iport_code_user)
values('{0}','{1}','{2}',to_date('{3}','YYYY-MM-DD HH24:MI:SS'),'{4}','{5}')"
, mobile, account, codeCompany, endTime, "1", iportCodeUser);
var dt4 = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathWlxgx).ExecuteTable(sql);
//检查是否已插入
sql =
string.Format("select * from TB_SPH_USER where upper(logogram)='{0}'", account.ToUpper());
var dt5 = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathWlxgx).ExecuteTable(sql);
if (dt5.Rows.Count == 0)
{
info.Add("IsLogin", "No");
info.Add("Message", "网络错误，请稍后再试！");
Json = JsonConvert.SerializeObject(info);
return(Json);
}
else
{
if (Convert.ToString(dt5.Rows[0]["account"]) != mobile || Convert.ToString(dt5.Rows[0]["code_company"]) != codeCompany || Convert.ToString(dt5.Rows[0]["usertype"]) != "1" || Convert.ToString(dt5.Rows[0]["endtime"]) != endTime.ToString() || Convert.ToString(dt5.Rows[0]["iport_code_user"]) != iportCodeUser)
{
info.Add("IsLogin", "No");
info.Add("Message", "网络错误，请稍后再试！");
Json = JsonConvert.SerializeObject(info);
return(Json);
}
{
codeUser = Convert.ToString(dt5.Rows[0]["code_user"]);
}
}
} //Iport用户表存在
} //sph用户表不存在
else
{
sql =
string.Format("select password from TB_SYS_USER where upper(logogram) = '{0}'", account.ToUpper());
var dt1 = new Leo.Oracle.DataAccess(RegistryKey.KeyPathIport).ExecuteTable(sql);
if (dt1.Rows.Count == 0)
{
info.Add("IsLogin", "No");
info.Add("Message", "Iport账号可能变动，请联系客服！");
Json = JsonConvert.SerializeObject(info);
return(Json);
}
else
{
if (!Identity.VerifyText(password, Convert.ToString(dt1.Rows[0]["password"])))
{
info.Add("IsLogin", "No");
info.Add("Message", "密码错误");
Json = JsonConvert.SerializeObject(info);
return(Json);
}
}
codeUser = Convert.ToString(dt0.Rows[0]["code_user"]);
} //sph用户表存在
info.Add("IsLogin", "Yes");
info.Add("CodeUser", codeUser);
Json = JsonConvert.SerializeObject(info);
return(Json);
}
