using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data; using System.Data.Sql; using System.Data.SqlClient; using NetWing.Common.Data.SQLServer; using System.Text; using System.Configuration; using System.Web.Configuration; namespace HisAPI { /// <summary> /// hisapi 的摘要说明 /// </summary> public class hisapi : IHttpHandler { public void ProcessRequest(HttpContext context) { //string serverIP= context.Request.ServerVariables.Get("Local_Addr").ToString(); string clientIP = (context.Request.ServerVariables["HTTP_VIA"] != null) ? context.Request.ServerVariables["HTTP_X_FORWARDED_FOR"].ToString() : context.Request.ServerVariables["REMOTE_ADDR"].ToString(); //context.Response.Write(clientIP); string allowIP = ConfigurationManager.ConnectionStrings["allowIP"].ConnectionString; //如果是网站用这个// if (allowIP.IndexOf(clientIP)>-1) { } else { context.Response.Write("{\"status\": 0, \"msg\": \"对不起,您的IP"+ clientIP + "不在允许的范围内!\"}"); context.Response.End(); } string yuedate = context.Request["yuedate"];//预约日期 string truename = context.Request["truename"];//真实姓名 string depid = context.Request["depid"];//号别 string sex = context.Request["sex"];//性别 string address = context.Request["address"];//地址 string age = context.Request["age"];//年龄 string idcard = context.Request["idcard"];//身份证号 if (string.IsNullOrEmpty(yuedate) || string.IsNullOrEmpty(truename) || string.IsNullOrEmpty(depid) || string.IsNullOrEmpty(sex) || string.IsNullOrEmpty(age) || string.IsNullOrEmpty(address) || string.IsNullOrEmpty(idcard)) { context.Response.Write("{\"status\": 0, \"msg\": \"对不起,信息不完整,请重新提交!\"}"); context.Response.End(); } //context.Response.ContentType = "text/plain"; //context.Response.Write("Hello World"); try { string oid = getPRE_ID(DateTime.Parse(yuedate));//得到预约单号 StringBuilder sb = new StringBuilder(); sb.Append(" insert into CLINICPRECONTRACT "); //sb.Append(" (PRE_ID,CLINIC_DATE,CLINIC_ID,ST_ID,PA_ID,PA_NAME,SHEET_PSID,SHEET_PSDATE,SHEET_STATUS,IF_CHECK,REG_ID,jy_lsh,zf_flag,SEX_ID,ID_CARD,ADDRESS,PA_AGE)"); sb.Append(" (PRE_ID,CLINIC_DATE,CLINIC_ID,ST_ID,PA_NAME,SHEET_PSID,SHEET_PSDATE,SHEET_STATUS,IF_CHECK,jy_lsh,zf_flag,SEX_ID,ID_CARD,ADDRESS,PA_AGE)"); //REG_ID PA_ID 传null 值 所以省略 sb.Append(" values ("); sb.Append("'" + oid + "',");//PRE_ID预约单号 sb.Append("'" + yuedate + "',");//预约日期 sb.Append("'" + depid + "',");//clinic_id sb.Append("'system',");//st_id //sb.Append("'"+null+"',");//pa_id sb.Append("'" + truename + "',");//pa_name sb.Append("'system',");//sheet_psid 制单人 sb.Append("'" + DateTime.Now.ToString() + "',");//sheet_psdate 制单日期 sb.Append("'3',");//SHEET_STATUS sb.Append("'1',");//IF_CHECK //sb.Append("'',");//REG_ID sb.Append("'000123',");//jy_lsh 流水号 sb.Append("'0',");//zf_flag sb.Append("'" + sex + "',");//性别1男2女 sb.Append("'" + idcard + "',");//身份证号 sb.Append("'" + address + "',");//地址 sb.Append("" + age + "");//年龄 sb.Append(")"); SqlEasy.ExecuteNonQuery(sb.ToString()); context.Response.Write("{\"status\": 1, \"msg\": \"恭喜!预约成功!\", \"oid\": \""+oid+"\"}"); context.Response.End(); //context.Response.Write(sb.ToString()); } catch (Exception err) { //context.Response.Write("{\"status\": -1, \"msg\": \"系统错误!可能是数据库连接不上或其他原因。请联系管理员!\"}"); //context.Response.End(); throw err; } } /// <summary> /// 算法得到预约单号 /// </summary> public string getPRE_ID(DateTime CLINIC_DATE) { string tempid = ""; //先判断数据库里面有没有当天预约 string sql = "select top 1 * from CLINICPRECONTRACT where year(CLINIC_DATE)=" + CLINIC_DATE.ToString("yyyy") + " and month(CLINIC_DATE)=" + CLINIC_DATE.ToString("MM") + " and day(CLINIC_DATE)=" + CLINIC_DATE.ToString("dd") + " order by PRE_ID desc "; SqlDataReader sdr = SqlEasy.ExecuteDataReader(sql); if (sdr.Read())//如果有 { tempid = sdr["PRE_ID"].ToString(); string temp = tempid.Substring(0, 8); tempid = tempid.Substring(tempid.Length - 4, 4); //tempid=(int.Parse(tempid)+1).ToString(); tempid = (int.Parse(tempid) + 1).ToString("0000"); tempid = temp + tempid; } else//如果没有 { tempid = "YY" + CLINIC_DATE.ToString("yyMMdd") + "0001"; } return tempid; } public bool IsReusable { get { return false; } } } }
Copyright © 2004-2024 Ynicp.com 版权所有 法律顾问:建纬(昆明)律师事务所 昆明市网翼通科技有限公司 滇ICP备08002592号-4