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