1039 lines
44 KiB
C#
1039 lines
44 KiB
C#
using System;
|
||
using System.Collections.Generic;
|
||
using System.Linq;
|
||
using System.Web;
|
||
using System.Web.Services;
|
||
using System.Data.SqlClient;
|
||
using System.Data.OleDb;
|
||
using System.Data;
|
||
using Newtonsoft.Json;
|
||
using System.Text;
|
||
using System.Security.Cryptography;
|
||
using System.IO;
|
||
using Newtonsoft.Json.Linq;
|
||
using System.Web.Script.Serialization;
|
||
using log4net;
|
||
|
||
namespace TiJianFuWu
|
||
{
|
||
/// <summary>
|
||
/// PAJK 的摘要说明
|
||
/// </summary>
|
||
[WebService(Namespace = "http://tempuri.org/")]
|
||
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
|
||
[System.ComponentModel.ToolboxItem(false)]
|
||
// 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务，请取消注释以下行。
|
||
// [System.Web.Script.Services.ScriptService]
|
||
public class PAJK : System.Web.Services.WebService
|
||
{
|
||
private static SqlConnection connection;
|
||
string yzm = "0";
|
||
object yzm1 = "0";
|
||
private const string SError = "Error";
|
||
|
||
/// <summary>
|
||
/// 1.预约申请
|
||
/// </summary>
|
||
/// <param name="data">3DES加密后的预约JSON数据</param>
|
||
/// <returns>status=状态码：正常：200，参数异常400，权限异常: 401未知错误: 500不能预约: 600预约人数已满: 601其他无法预约情况: 602</returns>
|
||
/// <returns>hospitalOrderId=医疗机构订单ID</returns>
|
||
/// <returns>orderState=预约订单状态：预约已确认：01 预约待确认：02</returns>
|
||
[WebMethod]
|
||
public string yysq(string sign, string timestamp, string data)
|
||
{
|
||
try
|
||
{
|
||
//var log = log4net.LogManager.GetLogger(this.GetType());
|
||
var log = log4net.LogManager.GetLogger(SError);
|
||
log.Info(data);
|
||
|
||
if (JianQuan(sign, timestamp) == false)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "401", hospitalOrderId = "", orderState = "02" });
|
||
}
|
||
|
||
//EAS.Loggers.ILogger log = new EAS.Loggers.TextLogger();
|
||
//使用3des解密
|
||
//var data3des = Decrypt3Des1(data, "pOju50umByKqfGFAqrknUKmM");
|
||
var data3des = Decrypt3Des1(data, "D4c631fEanBeA1dMdrsCjdte");
|
||
|
||
//将解密字符串转换成Json对象
|
||
JObject jo = (JObject)JsonConvert.DeserializeObject(data3des);
|
||
|
||
//医疗机构订单ID
|
||
string hospitalOrderId = Guid.NewGuid().ToString();
|
||
|
||
|
||
//体检平台订单ID
|
||
string orderId = jo["orderId"].ToString();
|
||
|
||
string sql = "select * from pa_yysq where orderId='"+ orderId + "'";
|
||
DataTable dtMd = GetDataSet(sql);
|
||
if(dtMd.Rows.Count>0)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "200", hospitalOrderId = hospitalOrderId, orderState = "01" });
|
||
}
|
||
|
||
//客户姓名
|
||
string customerName = jo["customerName"].ToString();
|
||
if (string.IsNullOrEmpty(customerName))
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "400", hospitalOrderId = "", orderState = "02" });
|
||
}
|
||
var log1 = log4net.LogManager.GetLogger(SError);
|
||
log1.Info(customerName);
|
||
|
||
//客户证件类型--身份证：1，护照：2，军人证：3，港澳通行证 / 回乡证或台胞证：6
|
||
string customerIdentityType = jo["customerIdentityType"].ToString();
|
||
|
||
//客户证件号
|
||
string customerIdentityNo = jo["customerIdentityNo"].ToString();
|
||
if (string.IsNullOrEmpty(customerIdentityNo))
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "400", hospitalOrderId = "", orderState = "02" });
|
||
}
|
||
|
||
//客户性别 男：M，女：F
|
||
string customerGender = jo["customerGender"].ToString();
|
||
|
||
//客户出生日期 yyyyMMdd
|
||
string customerBirthday = jo["customerBirthday"].ToString();
|
||
|
||
//生理状态：男：01 未婚女：02 已婚女：03
|
||
string medicalStatus = jo["medicalStatus"].ToString();
|
||
|
||
//门店ID
|
||
string hospitalSubId = jo["hospitalSubId"].ToString();
|
||
|
||
//套餐ID
|
||
string medicalPackage = jo["medicalPackage"].ToString();
|
||
|
||
//预约时间 yyyyMMddHHmmss
|
||
string appointmentTime = jo["appointmentTime"].ToString();
|
||
if (string.IsNullOrEmpty(appointmentTime))
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "400", hospitalOrderId = "", orderState = "02" });
|
||
}
|
||
|
||
string aa = appointmentTime.Substring(0, 8);
|
||
//var time = DateTime.Parse(Request["Pusinessdate"].ToString());
|
||
DateTime dtAppointmentTime = Convert.ToDateTime(DateTime.ParseExact(aa, "yyyyMMdd", null, System.Globalization.DateTimeStyles.AllowWhiteSpaces).ToString("yyyy-MM-dd"));
|
||
|
||
//是否授权查看体检报告：是：Y 否：N
|
||
string hasAuthorized = jo["hasAuthorized"].ToString();
|
||
|
||
//手机号码，11位
|
||
string phone = jo["phone"].ToString();
|
||
|
||
//套餐展示名称
|
||
string packageDisplayName = jo["packageDisplayName"].ToString();
|
||
|
||
//所属公司名称
|
||
string companyName = jo["companyName"].ToString();
|
||
|
||
//是否VIP预约：否：N 是：Y
|
||
string isVip = jo["isVip"].ToString();
|
||
|
||
/*
|
||
* 验证是否可以预约
|
||
*/
|
||
/// canOrder 是否可预约：可预约： 1 不可预约： 0
|
||
/// provideVipData 是否提供VIP预约数据：提供：1 不提供：0
|
||
/// vipMaxNum VIP最大可体检人数
|
||
/// vipOrderNum VIP已预约人数
|
||
/// maxNum 最大可体检人数（包括vip和非vip）
|
||
/// orderNum 已预约人数（包括vip和非vip）
|
||
/// status=状态码：正常：200，参数异常400，权限异常: 401未知错误: 500不能预约: 600预约人数已满: 601其他无法预约情况: 602
|
||
|
||
sql = "select * from pa_yyrs where yyrq='" + dtAppointmentTime + "'";
|
||
DataTable dt1 = GetDataSet(sql);
|
||
if (dt1.Rows.Count == 0)
|
||
{
|
||
sql = @"INSERT INTO pa_yyrs
|
||
(yyrq
|
||
,maxNum
|
||
,orderNum
|
||
,vipMaxNum
|
||
,vipOrderNum
|
||
,canOrder
|
||
,provideVipData
|
||
) VALUES ('{0}',{1},{2},{3},{4},{5},{6})";
|
||
|
||
sql = string.Format(sql, dtAppointmentTime
|
||
, 150
|
||
, 1
|
||
, 50
|
||
, isVip == "Y" ? 1 : 0
|
||
, (int)dtAppointmentTime.DayOfWeek == 1 ? 0 : 1
|
||
, (int)dtAppointmentTime.DayOfWeek == 1 ? 0 : 1);
|
||
|
||
//创建SqlCommand对象
|
||
SqlCommand cmd1 = new SqlCommand(sql, Connection);
|
||
|
||
//执行SQL语句
|
||
int returnvalue1 = cmd1.ExecuteNonQuery();
|
||
|
||
//判断SQL语句是否执行成功
|
||
if (returnvalue1 < 0)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "500", hospitalOrderId = hospitalOrderId, orderState = "02" });
|
||
}
|
||
|
||
}
|
||
else
|
||
{
|
||
if (dt1.Rows[0]["canOrder"].ToString() == "0")
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "600", hospitalOrderId = "", orderState = "02" });
|
||
}
|
||
|
||
if (isVip == "Y")
|
||
{
|
||
if (dt1.Rows[0]["provideVipData"].ToString() == "0")
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "600", hospitalOrderId = "", orderState = "02" });
|
||
}
|
||
|
||
if (Convert.ToInt32(dt1.Rows[0]["vipMaxNum"]) == Convert.ToInt32(dt1.Rows[0]["vipOrderNum"]))
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "601", hospitalOrderId = "", orderState = "02" });
|
||
}
|
||
|
||
sql = "update pa_yyrs set vipOrderNum=vipOrderNum+1,orderNum=orderNum+1 where yyrq='" + dtAppointmentTime + "'";
|
||
//创建SqlCommand对象
|
||
SqlCommand cmd2 = new SqlCommand(sql, Connection);
|
||
|
||
//执行SQL语句
|
||
int returnvalue2 = cmd2.ExecuteNonQuery();
|
||
|
||
//判断SQL语句是否执行成功
|
||
if (returnvalue2 < 0)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "500", hospitalOrderId = hospitalOrderId, orderState = "02" });
|
||
}
|
||
}
|
||
else
|
||
{
|
||
if (Convert.ToInt32(dt1.Rows[0]["maxNum"]) == Convert.ToInt32(dt1.Rows[0]["orderNum"]))
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "601", hospitalOrderId = "", orderState = "02" });
|
||
}
|
||
|
||
sql = "update pa_yyrs set orderNum=orderNum+1 where yyrq='" + dtAppointmentTime + "'";
|
||
//创建SqlCommand对象
|
||
SqlCommand cmd3 = new SqlCommand(sql, Connection);
|
||
|
||
//执行SQL语句
|
||
int returnvalue3 = cmd3.ExecuteNonQuery();
|
||
|
||
//判断SQL语句是否执行成功
|
||
if (returnvalue3 < 0)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "500", hospitalOrderId = hospitalOrderId, orderState = "02" });
|
||
}
|
||
}
|
||
}
|
||
|
||
|
||
|
||
|
||
sql = @"INSERT INTO pa_yysq
|
||
(hospitalOrderId
|
||
,orderId
|
||
,customerName
|
||
,customerIdentityType
|
||
,customerIdentityNo
|
||
,customerGender
|
||
,customerBirthday
|
||
,medicalStatus
|
||
,hospitalSubId
|
||
,medicalPackage
|
||
,appointmentTime
|
||
,hasAuthorized
|
||
,phone
|
||
,packageDisplayName
|
||
,companyName
|
||
,isVip
|
||
,tm
|
||
,orderState,status,tjrq)
|
||
VALUES
|
||
('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}',{18},'{19}')";
|
||
|
||
//填充SQL语句
|
||
sql = string.Format(sql, hospitalOrderId
|
||
, orderId
|
||
, customerName
|
||
, customerIdentityType
|
||
, customerIdentityNo
|
||
, customerGender
|
||
, customerBirthday
|
||
, medicalStatus
|
||
, hospitalSubId
|
||
, medicalPackage
|
||
, appointmentTime
|
||
, hasAuthorized
|
||
, phone
|
||
, packageDisplayName
|
||
, companyName
|
||
, isVip
|
||
, ""
|
||
, "01"
|
||
, "200", DateTime.Now.ToString("yyyyMMdd HH:mm:ss"));
|
||
|
||
//创建SqlCommand对象
|
||
SqlCommand cmd = new SqlCommand(sql, Connection);
|
||
|
||
//执行SQL语句
|
||
int returnvalue = cmd.ExecuteNonQuery();
|
||
|
||
//判断SQL语句是否执行成功
|
||
if (returnvalue != -1)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "200", hospitalOrderId = hospitalOrderId, orderState = "01" });
|
||
}
|
||
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "602", hospitalOrderId = "", orderState = "02" });
|
||
|
||
}
|
||
catch (Exception ext)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "500", hospitalOrderId = yzm, orderState = yzm1 });
|
||
}
|
||
}
|
||
|
||
/// <summary>
|
||
/// 1.预约申请2
|
||
/// </summary>
|
||
/// <param name="data">3DES加密后的预约JSON数据</param>
|
||
/// <returns>status=状态码：正常：200，参数异常400，权限异常: 401未知错误: 500不能预约: 600预约人数已满: 601其他无法预约情况: 602</returns>
|
||
/// <returns>hospitalOrderId=医疗机构订单ID</returns>
|
||
/// <returns>orderState=预约订单状态：预约已确认：01 预约待确认：02</returns>
|
||
[WebMethod]
|
||
public string yysq2(string data)
|
||
{
|
||
try
|
||
{
|
||
//var log = log4net.LogManager.GetLogger(this.GetType());
|
||
var log = log4net.LogManager.GetLogger(SError);
|
||
log.Info(data);
|
||
|
||
//EAS.Loggers.ILogger log = new EAS.Loggers.TextLogger();
|
||
//使用3des解密
|
||
//var data3des = Decrypt3Des1(data, "pOju50umByKqfGFAqrknUKmM");
|
||
var data3des = Decrypt3Des1(data, "D4c631fEanBeA1dMdrsCjdte");
|
||
|
||
//将解密字符串转换成Json对象
|
||
JObject jo = (JObject)JsonConvert.DeserializeObject(data3des);
|
||
|
||
//医疗机构订单ID
|
||
string hospitalOrderId = Guid.NewGuid().ToString();
|
||
//yzm = hospitalOrderId;
|
||
|
||
//体检平台订单ID
|
||
string orderId = jo["orderId"].ToString();
|
||
|
||
string sql = "select * from pa_yysq where orderId='" + orderId + "'";
|
||
DataTable dtMd = GetDataSet(sql);
|
||
if (dtMd.Rows.Count > 0)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "200", hospitalOrderId = hospitalOrderId, orderState = "01" });
|
||
}
|
||
|
||
//客户姓名
|
||
string customerName = jo["customerName"].ToString();
|
||
if (string.IsNullOrEmpty(customerName))
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "400", hospitalOrderId = "", orderState = "02" });
|
||
}
|
||
var log1 = log4net.LogManager.GetLogger(SError);
|
||
log1.Info(customerName);
|
||
|
||
//客户证件类型--身份证：1，护照：2，军人证：3，港澳通行证 / 回乡证或台胞证：6
|
||
string customerIdentityType = jo["customerIdentityType"].ToString();
|
||
|
||
//客户证件号
|
||
string customerIdentityNo = jo["customerIdentityNo"].ToString();
|
||
if (string.IsNullOrEmpty(customerIdentityNo))
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "400", hospitalOrderId = "", orderState = "02" });
|
||
}
|
||
|
||
//客户性别 男：M，女：F
|
||
string customerGender = jo["customerGender"].ToString();
|
||
|
||
//客户出生日期 yyyyMMdd
|
||
string customerBirthday = jo["customerBirthday"].ToString();
|
||
|
||
//生理状态：男：01 未婚女：02 已婚女：03
|
||
string medicalStatus = jo["medicalStatus"].ToString();
|
||
|
||
//门店ID
|
||
string hospitalSubId = jo["hospitalSubId"].ToString();
|
||
|
||
//套餐ID
|
||
string medicalPackage = jo["medicalPackage"].ToString();
|
||
|
||
//预约时间 yyyyMMddHHmmss
|
||
string appointmentTime = jo["appointmentTime"].ToString();
|
||
if (string.IsNullOrEmpty(appointmentTime))
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "400", hospitalOrderId = "", orderState = "02" });
|
||
}
|
||
|
||
string aa = appointmentTime.Substring(0, 8);
|
||
//var time = DateTime.Parse(Request["Pusinessdate"].ToString());
|
||
DateTime dtAppointmentTime = Convert.ToDateTime(DateTime.ParseExact(aa, "yyyyMMdd", null, System.Globalization.DateTimeStyles.AllowWhiteSpaces).ToString("yyyy-MM-dd"));
|
||
|
||
//是否授权查看体检报告：是：Y 否：N
|
||
string hasAuthorized = jo["hasAuthorized"].ToString();
|
||
|
||
//手机号码，11位
|
||
string phone = jo["phone"].ToString();
|
||
|
||
//套餐展示名称
|
||
string packageDisplayName = jo["packageDisplayName"].ToString();
|
||
|
||
//所属公司名称
|
||
string companyName = jo["companyName"].ToString();
|
||
|
||
//是否VIP预约：否：N 是：Y
|
||
string isVip = jo["isVip"].ToString();
|
||
|
||
/*
|
||
* 验证是否可以预约
|
||
*/
|
||
/// canOrder 是否可预约：可预约： 1 不可预约： 0
|
||
/// provideVipData 是否提供VIP预约数据：提供：1 不提供：0
|
||
/// vipMaxNum VIP最大可体检人数
|
||
/// vipOrderNum VIP已预约人数
|
||
/// maxNum 最大可体检人数（包括vip和非vip）
|
||
/// orderNum 已预约人数（包括vip和非vip）
|
||
/// status=状态码：正常：200，参数异常400，权限异常: 401未知错误: 500不能预约: 600预约人数已满: 601其他无法预约情况: 602
|
||
|
||
sql = "select * from pa_yyrs where yyrq='" + dtAppointmentTime + "'";
|
||
DataTable dt1 = GetDataSet(sql);
|
||
if (dt1.Rows.Count == 0)
|
||
{
|
||
sql = @"INSERT INTO pa_yyrs
|
||
(yyrq
|
||
,maxNum
|
||
,orderNum
|
||
,vipMaxNum
|
||
,vipOrderNum
|
||
,canOrder
|
||
,provideVipData
|
||
) VALUES ('{0}',{1},{2},{3},{4},{5},{6})";
|
||
|
||
sql = string.Format(sql, dtAppointmentTime
|
||
, 150
|
||
, 1
|
||
, 50
|
||
, isVip == "Y" ? 1 : 0
|
||
, (int)dtAppointmentTime.DayOfWeek == 1 ? 0 : 1
|
||
, (int)dtAppointmentTime.DayOfWeek == 1 ? 0 : 1);
|
||
|
||
//创建SqlCommand对象
|
||
SqlCommand cmd1 = new SqlCommand(sql, Connection);
|
||
|
||
//执行SQL语句
|
||
int returnvalue1 = cmd1.ExecuteNonQuery();
|
||
|
||
//判断SQL语句是否执行成功
|
||
if (returnvalue1 < 0)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "500", hospitalOrderId = hospitalOrderId, orderState = "02" });
|
||
}
|
||
|
||
}
|
||
else
|
||
{
|
||
if (dt1.Rows[0]["canOrder"].ToString() == "0")
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "600", hospitalOrderId = "", orderState = "02" });
|
||
}
|
||
|
||
if (isVip == "Y")
|
||
{
|
||
if (dt1.Rows[0]["provideVipData"].ToString() == "0")
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "600", hospitalOrderId = "", orderState = "02" });
|
||
}
|
||
|
||
if (Convert.ToInt32(dt1.Rows[0]["vipMaxNum"]) == Convert.ToInt32(dt1.Rows[0]["vipOrderNum"]))
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "601", hospitalOrderId = "", orderState = "02" });
|
||
}
|
||
|
||
sql = "update pa_yyrs set vipOrderNum=vipOrderNum+1,orderNum=orderNum+1 where yyrq='" + dtAppointmentTime + "'";
|
||
//创建SqlCommand对象
|
||
SqlCommand cmd2 = new SqlCommand(sql, Connection);
|
||
|
||
//执行SQL语句
|
||
int returnvalue2 = cmd2.ExecuteNonQuery();
|
||
|
||
//判断SQL语句是否执行成功
|
||
if (returnvalue2 < 0)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "500", hospitalOrderId = hospitalOrderId, orderState = "02" });
|
||
}
|
||
}
|
||
else
|
||
{
|
||
if (Convert.ToInt32(dt1.Rows[0]["maxNum"]) == Convert.ToInt32(dt1.Rows[0]["orderNum"]))
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "601", hospitalOrderId = "", orderState = "02" });
|
||
}
|
||
|
||
sql = "update pa_yyrs set orderNum=orderNum+1 where yyrq='" + dtAppointmentTime + "'";
|
||
//创建SqlCommand对象
|
||
SqlCommand cmd3 = new SqlCommand(sql, Connection);
|
||
|
||
//执行SQL语句
|
||
int returnvalue3 = cmd3.ExecuteNonQuery();
|
||
|
||
//判断SQL语句是否执行成功
|
||
if (returnvalue3 < 0)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "500", hospitalOrderId = hospitalOrderId, orderState = "02" });
|
||
}
|
||
}
|
||
}
|
||
|
||
|
||
|
||
|
||
sql = @"INSERT INTO pa_yysq
|
||
(hospitalOrderId
|
||
,orderId
|
||
,customerName
|
||
,customerIdentityType
|
||
,customerIdentityNo
|
||
,customerGender
|
||
,customerBirthday
|
||
,medicalStatus
|
||
,hospitalSubId
|
||
,medicalPackage
|
||
,appointmentTime
|
||
,hasAuthorized
|
||
,phone
|
||
,packageDisplayName
|
||
,companyName
|
||
,isVip
|
||
,tm
|
||
,orderState,status,tjrq)
|
||
VALUES
|
||
('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}',{18},'{19}')";
|
||
|
||
//填充SQL语句
|
||
sql = string.Format(sql, hospitalOrderId
|
||
, orderId
|
||
, customerName
|
||
, customerIdentityType
|
||
, customerIdentityNo
|
||
, customerGender
|
||
, customerBirthday
|
||
, medicalStatus
|
||
, hospitalSubId
|
||
, medicalPackage
|
||
, appointmentTime
|
||
, hasAuthorized
|
||
, phone
|
||
, packageDisplayName
|
||
, companyName
|
||
, isVip
|
||
, ""
|
||
, "01"
|
||
, "200", DateTime.Now.ToString("yyyyMMdd HH:mm:ss"));
|
||
|
||
//创建SqlCommand对象
|
||
SqlCommand cmd = new SqlCommand(sql, Connection);
|
||
|
||
//执行SQL语句
|
||
int returnvalue = cmd.ExecuteNonQuery();
|
||
|
||
//判断SQL语句是否执行成功
|
||
if (returnvalue != -1)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "200", hospitalOrderId = hospitalOrderId, orderState = "01" });
|
||
}
|
||
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "602", hospitalOrderId = "", orderState = "02" });
|
||
|
||
}
|
||
catch (Exception ext)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "500", hospitalOrderId = yzm, orderState = yzm1 });
|
||
}
|
||
}
|
||
|
||
/// <summary>
|
||
/// 2.取消预约
|
||
/// </summary>
|
||
/// <param name="hospitalOrderId">医疗机构订单ID</param>
|
||
/// <param name="orderId">体检平台订单ID</param>
|
||
/// <returns>status=状态码：正常：200，参数异常400，权限异常: 401未知错误: 500不能预约: 600预约人数已满: 601其他无法预约情况: 602</returns>
|
||
[WebMethod]
|
||
public string qxyy(string sign, string timestamp, string hospitalOrderId, string orderId)
|
||
{
|
||
try
|
||
{
|
||
if (JianQuan(sign, timestamp) == false)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "401" });
|
||
}
|
||
|
||
//DateTime dtAppointmentTime = Convert.ToDateTime(DateTime.ParseExact(aa, "yyyyMMdd", null, System.Globalization.DateTimeStyles.AllowWhiteSpaces).ToString("yyyy-MM-dd"));
|
||
string sql = "select * from pa_yysq where hospitalOrderId='{0}' and orderId='{1}'";
|
||
sql = string.Format(sql, hospitalOrderId, orderId);
|
||
DataTable dt1 = GetDataSet(sql);
|
||
|
||
if (dt1.Rows.Count == 0)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "500" });
|
||
}
|
||
|
||
string aa = dt1.Rows[0]["appointmentTime"].ToString().Substring(0, 8);
|
||
string isVIP = dt1.Rows[0]["isVip"].ToString();
|
||
DateTime dtAppointmentTime = Convert.ToDateTime(DateTime.ParseExact(aa, "yyyyMMdd", null, System.Globalization.DateTimeStyles.AllowWhiteSpaces).ToString("yyyy-MM-dd"));
|
||
|
||
sql = "select * from pa_yyrs where yyrq='" + dtAppointmentTime + "'";
|
||
DataTable dt2 = GetDataSet(sql);
|
||
if (dt2.Rows.Count != 0)
|
||
{
|
||
if (isVIP == "Y")
|
||
{
|
||
sql = "update pa_yyrs set vipOrderNum=vipOrderNum-1,orderNum=orderNum-1 where yyrq='" + dtAppointmentTime + "'";
|
||
}
|
||
else
|
||
{
|
||
sql = "update pa_yyrs set orderNum=orderNum-1 where yyrq='" + dtAppointmentTime + "'";
|
||
}
|
||
|
||
//创建SqlCommand对象
|
||
SqlCommand cmd2 = new SqlCommand(sql, Connection);
|
||
|
||
//执行SQL语句
|
||
int returnvalue2 = cmd2.ExecuteNonQuery();
|
||
|
||
//判断SQL语句是否执行成功
|
||
if (returnvalue2 < 0)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "500" });
|
||
}
|
||
}
|
||
|
||
sql = @"delete from pa_yysq where hospitalOrderId='{0}' and orderId='{1}'";
|
||
sql = string.Format(sql, hospitalOrderId, orderId);
|
||
//创建SqlCommand对象
|
||
SqlCommand cmd = new SqlCommand(sql, Connection);
|
||
//执行SQL语句
|
||
int returnvalue = cmd.ExecuteNonQuery();
|
||
//判断SQL语句是否执行成功
|
||
if (returnvalue != 0)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "200" });
|
||
}
|
||
else
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "400" });
|
||
}
|
||
}
|
||
catch (Exception ext)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "500" });
|
||
}
|
||
}
|
||
|
||
/// <summary>
|
||
/// 3.客户申请改期
|
||
/// </summary>
|
||
/// <param name="hospitalOrderId">医疗机构订单ID</param>
|
||
/// <param name="orderId">体检平台订单ID</param>
|
||
/// <param name="appointmentTime">预约时间</param>
|
||
/// <returns>status=状态码：正常：200，参数异常400，权限异常: 401未知错误: 500不能预约: 600预约人数已满: 601其他无法预约情况: 602</returns>
|
||
/// <returns>hospitalOrderId=医疗机构订单ID</returns>
|
||
[WebMethod]
|
||
public string khsqgq(string sign, string timestamp, string hospitalOrderId, string orderId, string appointmentTime)
|
||
{
|
||
try
|
||
{
|
||
if (JianQuan(sign, timestamp) == false)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "401", hospitalOrderId = hospitalOrderId });
|
||
}
|
||
|
||
string bb = appointmentTime.Substring(0, 8);
|
||
DateTime dt = Convert.ToDateTime(DateTime.ParseExact(bb, "yyyyMMdd", null, System.Globalization.DateTimeStyles.AllowWhiteSpaces).ToString("yyyy-MM-dd"));
|
||
if ((int)dt.DayOfWeek == 1)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "601", hospitalOrderId = hospitalOrderId });
|
||
}
|
||
|
||
string sql = "select * from pa_yysq where hospitalOrderId='{0}' and orderId='{1}'";
|
||
sql = string.Format(sql, hospitalOrderId, orderId);
|
||
DataTable dt1 = GetDataSet(sql);
|
||
|
||
if (dt1.Rows.Count == 0)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "500", hospitalOrderId = hospitalOrderId });
|
||
}
|
||
|
||
//释放预约
|
||
string aa = dt1.Rows[0]["appointmentTime"].ToString().Substring(0, 8);
|
||
string isVIP = dt1.Rows[0]["isVip"].ToString();
|
||
DateTime dtAppointmentTime = Convert.ToDateTime(DateTime.ParseExact(aa, "yyyyMMdd", null, System.Globalization.DateTimeStyles.AllowWhiteSpaces).ToString("yyyy-MM-dd"));
|
||
|
||
sql = "select * from pa_yyrs where yyrq='" + dtAppointmentTime + "'";
|
||
DataTable dt2 = GetDataSet(sql);
|
||
if (dt2.Rows.Count != 0)
|
||
{
|
||
if (isVIP == "Y")
|
||
{
|
||
sql = "update pa_yyrs set vipOrderNum=vipOrderNum-1,orderNum=orderNum-1 where yyrq='" + dtAppointmentTime + "'";
|
||
}
|
||
else
|
||
{
|
||
sql = "update pa_yyrs set orderNum=orderNum-1 where yyrq='" + dtAppointmentTime + "'";
|
||
}
|
||
|
||
//创建SqlCommand对象
|
||
SqlCommand cmd2 = new SqlCommand(sql, Connection);
|
||
|
||
//执行SQL语句
|
||
int returnvalue2 = cmd2.ExecuteNonQuery();
|
||
|
||
//判断SQL语句是否执行成功
|
||
if (returnvalue2 < 0)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "500", hospitalOrderId = hospitalOrderId });
|
||
}
|
||
}
|
||
|
||
//新的预约日期 填充预约
|
||
sql = "select * from pa_yyrs where yyrq='" + dt + "'";
|
||
DataTable dt3 = GetDataSet(sql);
|
||
if (dt3.Rows.Count == 0)
|
||
{
|
||
sql = @"INSERT INTO pa_yyrs
|
||
(yyrq
|
||
,maxNum
|
||
,orderNum
|
||
,vipMaxNum
|
||
,vipOrderNum
|
||
,canOrder
|
||
,provideVipData
|
||
) VALUES ('{0}',{1},{2},{3},{4},{5},{6})";
|
||
|
||
sql = string.Format(sql, dt
|
||
, 150
|
||
, 1
|
||
, 50
|
||
, isVIP == "Y" ? 1 : 0
|
||
, (int)dtAppointmentTime.DayOfWeek == 1 ? 0 : 1
|
||
,(int)dtAppointmentTime.DayOfWeek == 1 ? 0 : 1);
|
||
//创建SqlCommand对象
|
||
SqlCommand cmd1 = new SqlCommand(sql, Connection);
|
||
|
||
//执行SQL语句
|
||
int returnvalue1 = cmd1.ExecuteNonQuery();
|
||
|
||
//判断SQL语句是否执行成功
|
||
if (returnvalue1 < 0)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "500", hospitalOrderId = hospitalOrderId });
|
||
}
|
||
|
||
}
|
||
else
|
||
{
|
||
if (isVIP == "Y")
|
||
{
|
||
sql = "update pa_yyrs set vipOrderNum=vipOrderNum+1,orderNum=orderNum+1 where yyrq='" + dt + "'";
|
||
}
|
||
else
|
||
{
|
||
sql = "update pa_yyrs set orderNum=orderNum+1 where yyrq='" + dt + "'";
|
||
}
|
||
//创建SqlCommand对象
|
||
SqlCommand cmd3 = new SqlCommand(sql, Connection);
|
||
|
||
//执行SQL语句
|
||
int returnvalue3 = cmd3.ExecuteNonQuery();
|
||
|
||
//判断SQL语句是否执行成功
|
||
if (returnvalue3 < 0)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "500", hospitalOrderId = hospitalOrderId });
|
||
}
|
||
}
|
||
|
||
sql = @"update pa_yysq set appointmentTime='{0}',tjrq='{3}' where hospitalOrderId='{1}' and orderId='{2}'";
|
||
sql = string.Format(sql, appointmentTime, hospitalOrderId, orderId, DateTime.Now.ToString("yyyyMMdd HH:mm:ss"));
|
||
//创建SqlCommand对象
|
||
SqlCommand cmd = new SqlCommand(sql, Connection);
|
||
//执行SQL语句
|
||
int returnvalue = cmd.ExecuteNonQuery();
|
||
//判断SQL语句是否执行成功
|
||
if (returnvalue != 0)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "200", hospitalOrderId = hospitalOrderId });
|
||
}
|
||
else
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "400", hospitalOrderId = hospitalOrderId });
|
||
}
|
||
}
|
||
catch (Exception ext)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "500", hospitalOrderId = hospitalOrderId });
|
||
}
|
||
}
|
||
|
||
/// <summary>
|
||
/// 4.客户授权查看影像报告
|
||
/// </summary>
|
||
/// <param name="hospitalOrderId">医疗机构订单ID</param>
|
||
/// <param name="orderId">体检平台订单ID</param>
|
||
/// <returns>status=状态码：正常：200，参数异常400，权限异常: 401未知错误: 500不能预约: 600预约人数已满: 601其他无法预约情况: 602</returns>
|
||
[WebMethod]
|
||
public string khsqckyxbg(string sign, string timestamp, string hospitalOrderId, string orderId)
|
||
{
|
||
try
|
||
{
|
||
if (JianQuan(sign, timestamp) == false)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "401" });
|
||
}
|
||
|
||
string sql = "select * from pa_yysq where hospitalOrderId='{0}' and orderId='{1}'";
|
||
sql = string.Format(sql, hospitalOrderId, orderId);
|
||
DataTable dt1 = GetDataSet(sql);
|
||
|
||
if (dt1.Rows.Count == 0)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "500" });
|
||
}
|
||
|
||
sql = @"update pa_yysq set hasAuthorized='Y' where hospitalOrderId='{0}' and orderId='{1}'";
|
||
sql = string.Format(sql, hospitalOrderId, orderId);
|
||
//创建SqlCommand对象
|
||
SqlCommand cmd = new SqlCommand(sql, Connection);
|
||
//执行SQL语句
|
||
int returnvalue = cmd.ExecuteNonQuery();
|
||
//判断SQL语句是否执行成功
|
||
if (returnvalue != 0)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "200" });
|
||
}
|
||
else
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "400" });
|
||
}
|
||
}
|
||
catch (Exception ext)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "500" });
|
||
}
|
||
}
|
||
|
||
/// <summary>
|
||
/// 5.体检预约可用人数
|
||
/// </summary>
|
||
/// <param name="startDate">起始时间</param>
|
||
/// <param name="endDate">结束时间</param>
|
||
/// <param name="hospitalSubId">机构门店ID</param>
|
||
/// <returns>status=状态码：正常：200，参数异常400，权限异常: 401未知错误: 500不能预约: 600预约人数已满: 601其他无法预约情况: 602</returns>
|
||
/// <returns>results=
|
||
/// date 具体每一天的日期
|
||
/// canOrder 是否可预约：可预约： 1 不可预约： 0
|
||
/// provideVipData 是否提供VIP预约数据：提供：1 不提供：0
|
||
/// vipMaxNum VIP最大可体检人数
|
||
/// vipOrderNum VIP已预约人数
|
||
/// maxNum 最大可体检人数（包括vip和非vip）
|
||
/// orderNum 已预约人数（包括vip和非vip）</returns>
|
||
[WebMethod]
|
||
public string tjyykyrs(string sign, string timestamp, string startDate, string endDate, string hospitalSubId)
|
||
{
|
||
try
|
||
{
|
||
if (JianQuan(sign, timestamp) == false)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "401", results = "" });
|
||
}
|
||
|
||
DateTime dt1 = Convert.ToDateTime(DateTime.ParseExact(startDate, "yyyyMMdd", null, System.Globalization.DateTimeStyles.AllowWhiteSpaces).ToString("yyyy-MM-dd"));
|
||
DateTime dt2 = Convert.ToDateTime(DateTime.ParseExact(endDate, "yyyyMMdd", null, System.Globalization.DateTimeStyles.AllowWhiteSpaces).ToString("yyyy-MM-dd"));
|
||
|
||
string sql = "select * from pa_yyrs where yyrq between '" + dt1 + "' and '" + dt2 + "'";
|
||
DataTable dtSet = GetDataSet(sql);
|
||
|
||
//DateTime dt1 = Convert.ToDateTime(Convert.ToDateTime(startDate).ToShortDateString());
|
||
//DateTime dt2 = Convert.ToDateTime(Convert.ToDateTime(endDate).ToShortDateString());
|
||
TimeSpan sp = dt2.Subtract(dt1);
|
||
int count = sp.Days + 1;
|
||
results[] re = new results[count];
|
||
int compNum = 999;
|
||
|
||
DateTime dt = dt1.AddDays(-1);
|
||
|
||
for (int i = 0; i < count; i++)
|
||
{
|
||
dt = dt.AddDays(1);
|
||
if (dtSet.Rows.Count != 0)
|
||
{
|
||
foreach (DataRow dr in dtSet.Rows)
|
||
{
|
||
compNum = DateTime.Compare(dt, Convert.ToDateTime(dr["yyrq"]));
|
||
if (compNum == 0)
|
||
{
|
||
re[i] = new results { date = dt.ToString("yyyyMMdd"), canOrder = Convert.ToInt32(dr["canOrder"]), provideVipData = Convert.ToInt32(dr["provideVipData"]), vipMaxNum = Convert.ToInt32(dr["vipMaxNum"]), vipOrderNum = Convert.ToInt32(dr["vipOrderNum"]), maxNum = Convert.ToInt32(dr["maxNum"]), orderNum = Convert.ToInt32(dr["orderNum"]) };
|
||
|
||
break;
|
||
}
|
||
}
|
||
}
|
||
|
||
if (compNum != 0)
|
||
{
|
||
int xq = (int)dt.DayOfWeek;
|
||
if (xq == 1)
|
||
{
|
||
re[i] = new results { date = dt.ToString("yyyyMMdd"), canOrder = 0, provideVipData = 0, vipMaxNum = 50, vipOrderNum = 0, maxNum = 110, orderNum = 0 };
|
||
}
|
||
else
|
||
{
|
||
re[i] = new results { date = dt.ToString("yyyyMMdd"), canOrder = 1, provideVipData = 1, vipMaxNum = 50, vipOrderNum = 0, maxNum = 110, orderNum = 0 };
|
||
}
|
||
|
||
}
|
||
|
||
compNum = 999;
|
||
}
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "200", results = re });
|
||
|
||
}
|
||
catch (Exception e)
|
||
{
|
||
return Newtonsoft.Json.JsonConvert.SerializeObject(new { status = "500", results = "" });
|
||
}
|
||
}
|
||
|
||
public class results
|
||
{
|
||
public string date { get; set; }
|
||
public int canOrder { get; set; }
|
||
public int provideVipData { get; set; }
|
||
public int vipMaxNum { get; set; }
|
||
public int vipOrderNum { get; set; }
|
||
public int maxNum { get; set; }
|
||
public int orderNum { get; set; }
|
||
}
|
||
|
||
public static bool JianQuan(string sign, string timestamp)
|
||
{
|
||
if (string.IsNullOrEmpty(sign))
|
||
{
|
||
return false;
|
||
}
|
||
if (string.IsNullOrEmpty(timestamp))
|
||
{
|
||
return false;
|
||
}
|
||
DateTime dt1 = DateTime.ParseExact(timestamp, "yyyyMMddHHmmss", System.Globalization.CultureInfo.CurrentCulture);
|
||
DateTime dt2 = DateTime.Now;
|
||
TimeSpan timeSpan = dt2 - dt1;
|
||
if (timeSpan.TotalMinutes > 10)
|
||
{
|
||
return false;
|
||
}
|
||
|
||
string yzm = GenerateMD5("tianrui0871338ce2bddd34fd02a0c383d0b73a" + timestamp);
|
||
if (yzm.ToLower() != sign.ToLower())
|
||
{
|
||
return false;
|
||
}
|
||
|
||
return true;
|
||
}
|
||
|
||
public static string GenerateMD5(string txt)
|
||
{
|
||
using (MD5 mi = MD5.Create())
|
||
{
|
||
byte[] buffer = Encoding.Default.GetBytes(txt);
|
||
//开始加密
|
||
byte[] newBuffer = mi.ComputeHash(buffer);
|
||
StringBuilder sb = new StringBuilder();
|
||
for (int i = 0; i < newBuffer.Length; i++)
|
||
{
|
||
sb.Append(newBuffer[i].ToString("x2"));
|
||
}
|
||
return sb.ToString();
|
||
}
|
||
}
|
||
|
||
public static string Decrypt3Des1(string aStrString, string aStrKey, CipherMode mode = CipherMode.ECB, string iv = "")
|
||
{
|
||
try
|
||
{
|
||
var des = new TripleDESCryptoServiceProvider
|
||
{
|
||
Key = Encoding.UTF8.GetBytes(aStrKey),
|
||
Mode = mode,
|
||
Padding = PaddingMode.PKCS7
|
||
};
|
||
if (mode == CipherMode.CBC)
|
||
{
|
||
des.IV = Encoding.UTF8.GetBytes(iv);
|
||
}
|
||
var desDecrypt = des.CreateDecryptor();
|
||
var result = "";
|
||
byte[] buffer = Convert.FromBase64String(aStrString);
|
||
result = Encoding.UTF8.GetString(desDecrypt.TransformFinalBlock(buffer, 0, buffer.Length));
|
||
return result;
|
||
}
|
||
catch (Exception e)
|
||
{
|
||
return string.Empty;
|
||
}
|
||
}
|
||
|
||
|
||
public static SqlConnection Connection
|
||
{
|
||
get
|
||
{
|
||
string con = "";
|
||
//System.Configuration.Configuration cm = System.Configuration.ConfigurationManager.OpenExeConfiguration(AppDomain.CurrentDomain.BaseDirectory + "\\local.ext");
|
||
//con = cm.AppSettings.Settings["zbbodycheck"].Value;
|
||
con = System.Configuration.ConfigurationManager.ConnectionStrings["tjconn"].ConnectionString;
|
||
if (connection == null)
|
||
{
|
||
connection = new SqlConnection(con);
|
||
connection.Open();
|
||
}
|
||
else if (connection.State == System.Data.ConnectionState.Closed)
|
||
{
|
||
connection.Open();
|
||
}
|
||
else if (connection.State == System.Data.ConnectionState.Broken)
|
||
{
|
||
connection.Close();
|
||
connection.Open();
|
||
}
|
||
return connection;
|
||
|
||
}
|
||
}
|
||
|
||
public static DataTable GetDataSet(string safeSql)
|
||
{
|
||
DataSet ds = new DataSet();
|
||
SqlCommand cmd = new SqlCommand(safeSql, Connection);
|
||
SqlDataAdapter da = new SqlDataAdapter(cmd);
|
||
da.Fill(ds);
|
||
return ds.Tables[0];
|
||
}
|
||
}
|
||
}
|