/// <summary>
/// 查询完WebService之后更新记录表
/// </summary>
/// <param name="cq">记录表对象</param>
/// <param name="msg">查询之后的消息</param>
private void ChangeQueryRecordStatu(BLL.Request.Request cq, string msg)
{
Model.QueryRecoder queryRecoder = cq.QueryRecoderModel;
int queryDateInterval = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["QueryDateInterval"].Trim());
if (queryRecoder != null)
{
try
{
if ((DateTime.Now - queryRecoder.AddDate).Days > queryDateInterval)
{
//超时数据
queryRecoder.LastQueryDate = DateTime.Now;
queryRecoder.IsDel = true;
}
else
{
//不超时数据
queryRecoder.LastQueryDate = DateTime.Now;
}
queryRecoder.QueryResult = (" " + DateTime.Now.ToLocalTime() + " " + msg + queryRecoder.QueryResult);
QueryRecoder q = new QueryRecoder();
q.Update(queryRecoder);
}
catch (Exception ex)
{
Common.LogHelper.WriteError(ex);
}
}
}
public List <Model.QueryRecoder> CheckQueryRecord(Model.QueryRecoder model)
{
BLL.QueryRecoder qr = new BLL.QueryRecoder();
QueryRecoder queryRecoder = new QueryRecoder();
//查询本地数据库有没有数据
StringBuilder strWhere = new StringBuilder();
if (!string.IsNullOrEmpty(model.Uname))
{
strWhere.AppendFormat("Uname = {0} and ", "'" + model.Uname + "'");
}
if (!string.IsNullOrEmpty(model.Code))
{
strWhere.AppendFormat("Code = {0} and ", "'" + model.Code + "'");
}
if (!string.IsNullOrEmpty(model.CodeType))
{
strWhere.AppendFormat("CodeType = {0} and ", "'" + model.CodeType + "'");
}
if (!string.IsNullOrEmpty(model.QueryType))
{
strWhere.AppendFormat("QueryType = {0} and ", "'" + model.QueryType + "'");
}
if (!model.IsDel)
{
strWhere.AppendFormat("IsDel = {0}", "'" + model.IsDel + "'");
}
//查询条件是，当前用户添加的卡号为X的卡号类型为Y的没有标记删除的并且临床数据类型为Z的数据
return(qr.GetModelList(strWhere.ToString()));
}
public List<Model.QueryRecoder> CheckQueryRecord(Model.QueryRecoder model)
{
BLL.QueryRecoder qr = new BLL.QueryRecoder();
QueryRecoder queryRecoder = new QueryRecoder();
//查询本地数据库有没有数据
StringBuilder strWhere = new StringBuilder();
if (!string.IsNullOrEmpty(model.Uname))
{
strWhere.AppendFormat("Uname = {0} and ", "'" + model.Uname + "'");
}
if (!string.IsNullOrEmpty(model.Code))
{
strWhere.AppendFormat("Code = {0} and ", "'" + model.Code + "'");
}
if (!string.IsNullOrEmpty(model.CodeType))
{
strWhere.AppendFormat("CodeType = {0} and ", "'" + model.CodeType + "'");
}
if (!string.IsNullOrEmpty(model.QueryType))
{
strWhere.AppendFormat("QueryType = {0} and ", "'" + model.QueryType + "'");
}
if (!model.IsDel)
{
strWhere.AppendFormat("IsDel = {0}", "'" + model.IsDel + "'");
}
//查询条件是，当前用户添加的卡号为X的卡号类型为Y的没有标记删除的并且临床数据类型为Z的数据
return qr.GetModelList(strWhere.ToString());
}
/// <summary>
/// 删除数据
/// </summary>
/// <param name="context"></param>
private static void DeleteData(HttpContext context)
{
string mes = "";
if (context.Request["pk"] != null)
{
string pk = context.Request["pk"];
string[] ArrayPk = pk.Split(',');
ArrayList list = new ArrayList();
for (int i = 0; i < ArrayPk.Length - 1; i++)
{
string strnull = ArrayPk[i];
if (strnull != "")
{
list.Add(ArrayPk[i]);
}
}
RuRo.BLL.QueryRecoder bll_QueryRecoder = new BLL.QueryRecoder();
int successNumber = 0;
string errorMessage = "";
foreach (string strPk in list)
{
if (bll_QueryRecoder.Delete(int.Parse(strPk)))
{
successNumber += 1;
}
}
mes = "成功删除[" + successNumber.ToString() + "/" + ArrayPk.Length.ToString() + "]条数据;" + errorMessage;
}
else
{
mes = "PK字段为Null";
}
context.Response.Write(mes);
}
/// <summary>
/// 查询数据
/// </summary>
/// <param name="context"></param>
private static void QueryData(HttpContext context)
{
string adddate = context.Request.Params["adddate"].ToString();
string username = Common.CookieHelper.GetCookieValue("username");
RuRo.BLL.QueryRecoder bll = new BLL.QueryRecoder();
List <Model.QueryRecoder> list = bll.GetModelList("IsDel=0 and AddDate!='" + adddate + "' and Uname='" + username + "'");
string mes = FreezerProUtility.Fp_Common.FpJsonHelper.ObjectToJsonStr(list);
context.Response.Write(mes);
}
/// <summary>
/// 检查数据是否存在，会检测添加日期 true存在
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool CheckRecord(Model.QueryRecoder model)
{
BLL.QueryRecoder qr = new BLL.QueryRecoder();
QueryRecoder queryRecoder = new QueryRecoder();
//查询本地数据库有没有数据
StringBuilder strWhere = new StringBuilder();
if (!string.IsNullOrEmpty(model.Uname))
{
strWhere.AppendFormat("Uname = {0} and ", "'" + model.Uname + "'");
}
if (!string.IsNullOrEmpty(model.Code))
{
strWhere.AppendFormat("Code = {0} and ", "'" + model.Code + "'");
}
if (!string.IsNullOrEmpty(model.CodeType))
{
strWhere.AppendFormat("CodeType = {0} and ", "'" + model.CodeType + "'");
}
if (!string.IsNullOrEmpty(model.QueryType))
{
strWhere.AppendFormat("QueryType = {0} and ", "'" + model.QueryType + "'");
}
if (!model.IsDel)
{
strWhere.AppendFormat("IsDel = {0} and ", "'" + model.IsDel + "'");
}
DateTime date = new DateTime();
if (DateTime.TryParse(model.AddDate.ToString("yyyy-MM-dd"), out date))
{
// select * from dbo.QueryRecoder where REPLACE(CONVERT(Char(10),AddDate,111),'/','-')='2015-08-06'
strWhere.AppendFormat("REPLACE(CONVERT(Char(10),AddDate,111),'/','-')={0}", "'" + model.AddDate.ToString("yyyy-MM-dd") + "'");
//strWhere.AppendFormat("AddDate = {0}", "'" + model.AddDate + "'");
}
//查询条件是，当前用户添加的卡号为X的卡号类型为Y的没有标记删除的并且临床数据类型为Z的数据
List <Model.QueryRecoder> list = new List <Model.QueryRecoder>();
list = qr.GetModelList(strWhere.ToString());
if (list != null && list.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
//private bool SaveQueryRecord(ref Model.DTO.NormalLisItemsRequest resquet, string Msg, string codeType)
//{
// bool result = false;
// QueryRecoder queryRecoder = new QueryRecoder();
// //根据传入的查询字符串创建的当此查询的记录model
// Model.QueryRecoder model = new Model.QueryRecoder();
// //model.AddDate = DateTime.Now;
// model.Code = request.hospnum;
// model.CodeType = codeType;
// model.QueryType = "NormalLisItems";
// model.Uname = Common.CookieHelper.GetCookieValue("username");
// model.IsDel = false;
// List<Model.QueryRecoder> list = CheckQueryRecord(model);
// if (list != null && list.Count > 0)
// {
// //判断查询出来的数据是否满足要求（时间差距lastdate<dateNow-5）
// Model.QueryRecoder oldModel = list.OrderByDescending(a => a.LastQueryDate).FirstOrDefault();
// model.AddDate = oldModel.AddDate;
// model.Id = oldModel.Id;
// DateTime dtAdd = Convert.ToDateTime(oldModel.AddDate);
// DateTime dtLastQuery = Convert.ToDateTime(oldModel.LastQueryDate);
// DateTime dt = DateTime.Now;//当前时间
// int days = (dt - dtAdd).Days;//获取当前日期与添加日期时间差
// int getDays = 0;
// if (days > getDays)
// {
// model.IsDel = true;
// model.LastQueryDate = dtAdd.AddDays(5);
// }
// else
// {
// int chaday = (dtLastQuery - dtAdd).Days;//获取最后查询日期与添加日期时间差
// int nowday = (dt - dtLastQuery).Days;//当前时间与最后查询时间差
// int addnowDay = (dt - dtAdd).Days;//当前时间与添加时间差
// if (nowday == 0)
// {
// //resquet.jsrq00 = "";
// //resquet.ksrq00 = "";
// result = true;
// model.IsDel = false;
// model.QueryResult += " " + DateTime.Now.ToLocalTime() + " " + Msg + oldModel.QueryResult;
// }
// if (nowday > 0)//当前时间与最后查询时间差大于0
// {
// if (addnowDay == 0)
// {
// result = true;
// model.IsDel = false;
// model.QueryResult += " " + DateTime.Now.ToLocalTime() + " " + Msg + oldModel.QueryResult;
// }
// if (chaday >= getDays)
// {
// model.IsDel = true;
// }
// else
// {
// resquet.ksrq00 = dtLastQuery.ToString("yyyy-MM-dd");
// resquet.jsrq00 = dtLastQuery.AddDays(1).ToString("yyyy-MM-dd");
// result = true;
// //添加日期是距离添加日期是5天内的
// model.IsDel = false;
// model.QueryResult += " " + DateTime.Now.ToLocalTime() + " " + Msg + oldModel.QueryResult;
// }
// }
// }
// //本地数据库有数据
// result = queryRecoder.Update(model);
// }
// else
// {
// model.QueryResult += " " + DateTime.Now.ToLocalTime() + " " + Msg.Trim();
// model.AddDate = DateTime.Now;
// model.LastQueryDate = DateTime.Now;
// bool bo = queryRecoder.Add(model) > 0;
// model.QueryType = "PatientDiagnose";
// bool boo = queryRecoder.Add(model) > 0;
// if (bo && boo)
// {
// result = true;
// }
// else { result = false; }
// }
// return result;
//}
private List <Model.QueryRecoder> CheckQueryRecord(Model.QueryRecoder model)
{
QueryRecoder queryRecoder = new QueryRecoder();
//查询本地数据库有没有数据
StringBuilder strWhere = new StringBuilder();
strWhere.AppendFormat("Uname = {0} and ", "'" + model.Uname + "'");
strWhere.AppendFormat("Code = {0} and ", "'" + model.Code + "'");
strWhere.AppendFormat("CodeType = {0} and ", "'" + model.CodeType + "'");
strWhere.AppendFormat("IsDel = {0} and ", "'" + model.IsDel + "'");
strWhere.AppendFormat("QueryType = {0} and ", "'" + model.QueryType + "'");
strWhere.AppendFormat("IsDel = {0}", "'" + false + "'");
//查询条件是，当前用户添加的卡号为X的卡号类型为Y的没有标记删除的并且临床数据类型为Z的数据
return(queryRecoder.GetModelList(strWhere.ToString()));
}
/// <summary>
/// 检查数据是否存在，会检测添加日期 true存在
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool CheckRecord(Model.QueryRecoder model)
{
BLL.QueryRecoder qr = new BLL.QueryRecoder();
QueryRecoder queryRecoder = new QueryRecoder();
//查询本地数据库有没有数据
StringBuilder strWhere = new StringBuilder();
if (!string.IsNullOrEmpty(model.Uname))
{
strWhere.AppendFormat("Uname = {0} and ", "'" + model.Uname + "'");
}
if (!string.IsNullOrEmpty(model.Code))
{
strWhere.AppendFormat("Code = {0} and ", "'" + model.Code + "'");
}
if (!string.IsNullOrEmpty(model.CodeType))
{
strWhere.AppendFormat("CodeType = {0} and ", "'" + model.CodeType + "'");
}
if (!string.IsNullOrEmpty(model.QueryType))
{
strWhere.AppendFormat("QueryType = {0} and ", "'" + model.QueryType + "'");
}
if (!model.IsDel)
{
strWhere.AppendFormat("IsDel = {0} and ", "'" + model.IsDel + "'");
}
DateTime date = new DateTime();
if (DateTime.TryParse(model.AddDate.ToString("yyyy-MM-dd"), out date))
{
// select * from dbo.QueryRecoder where REPLACE(CONVERT(Char(10),AddDate,111),'/','-')='2015-08-06'
strWhere.AppendFormat("REPLACE(CONVERT(Char(10),AddDate,111),'/','-')={0}", "'" + model.AddDate.ToString("yyyy-MM-dd") + "'");
//strWhere.AppendFormat("AddDate = {0}", "'" + model.AddDate + "'");
}
//查询条件是，当前用户添加的卡号为X的卡号类型为Y的没有标记删除的并且临床数据类型为Z的数据
List<Model.QueryRecoder> list = new List<Model.QueryRecoder>();
list = qr.GetModelList(strWhere.ToString());
if (list != null && list.Count > 0)
{
return true;
}
else
{
return false;
}
}
private void ChangeQueryRecordStatu(Model.QueryRecoder queryRecoder, string msg)
{
int queryDateInterval = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["QueryDateInterval"].Trim());
if (queryRecoder != null)
{
try
{
if ((DateTime.Now - queryRecoder.AddDate).Days > queryDateInterval)
{
//超时数据
queryRecoder.LastQueryDate = DateTime.Now;
queryRecoder.IsDel = true;
}
else
{
//不超时数据
queryRecoder.LastQueryDate = DateTime.Now;
}
if (!string.IsNullOrEmpty(msg))
{
queryRecoder.QueryResult = ("   " + DateTime.Now.ToLocalTime() + " " + msg + queryRecoder.QueryResult);
}
QueryRecoder q = new QueryRecoder();
q.Update(queryRecoder);
}
catch (Exception ex)
{
Common.LogHelper.WriteError(ex);
}
}
}
//private bool SaveQueryRecord(ref Model.DTO.NormalLisItemsRequest resquet, string Msg, string codeType)
//{
// bool result = false;
// QueryRecoder queryRecoder = new QueryRecoder();
// //根据传入的查询字符串创建的当此查询的记录model
// Model.QueryRecoder model = new Model.QueryRecoder();
// //model.AddDate = DateTime.Now;
// model.Code = request.hospnum;
// model.CodeType = codeType;
// model.QueryType = "NormalLisItems";
// model.Uname = Common.CookieHelper.GetCookieValue("username");
// model.IsDel = false;
// List<Model.QueryRecoder> list = CheckQueryRecord(model);
// if (list != null && list.Count > 0)
// {
// //判断查询出来的数据是否满足要求（时间差距lastdate<dateNow-5）
// Model.QueryRecoder oldModel = list.OrderByDescending(a => a.LastQueryDate).FirstOrDefault();
// model.AddDate = oldModel.AddDate;
// model.Id = oldModel.Id;
// DateTime dtAdd = Convert.ToDateTime(oldModel.AddDate);
// DateTime dtLastQuery = Convert.ToDateTime(oldModel.LastQueryDate);
// DateTime dt = DateTime.Now;//当前时间
// int days = (dt - dtAdd).Days;//获取当前日期与添加日期时间差
// int getDays = 0;
// if (days > getDays)
// {
// model.IsDel = true;
// model.LastQueryDate = dtAdd.AddDays(5);
// }
// else
// {
// int chaday = (dtLastQuery - dtAdd).Days;//获取最后查询日期与添加日期时间差
// int nowday = (dt - dtLastQuery).Days;//当前时间与最后查询时间差
// int addnowDay = (dt - dtAdd).Days;//当前时间与添加时间差
// if (nowday == 0)
// {
// //resquet.jsrq00 = "";
// //resquet.ksrq00 = "";
// result = true;
// model.IsDel = false;
// model.QueryResult += " " + DateTime.Now.ToLocalTime() + " " + Msg + oldModel.QueryResult;
// }
// if (nowday > 0)//当前时间与最后查询时间差大于0
// {
// if (addnowDay == 0)
// {
// result = true;
// model.IsDel = false;
// model.QueryResult += " " + DateTime.Now.ToLocalTime() + " " + Msg + oldModel.QueryResult;
// }
// if (chaday >= getDays)
// {
// model.IsDel = true;
// }
// else
// {
// resquet.ksrq00 = dtLastQuery.ToString("yyyy-MM-dd");
// resquet.jsrq00 = dtLastQuery.AddDays(1).ToString("yyyy-MM-dd");
// result = true;
// //添加日期是距离添加日期是5天内的
// model.IsDel = false;
// model.QueryResult += " " + DateTime.Now.ToLocalTime() + " " + Msg + oldModel.QueryResult;
// }
// }
// }
// //本地数据库有数据
// result = queryRecoder.Update(model);
// }
// else
// {
// model.QueryResult += " " + DateTime.Now.ToLocalTime() + " " + Msg.Trim();
// model.AddDate = DateTime.Now;
// model.LastQueryDate = DateTime.Now;
// bool bo = queryRecoder.Add(model) > 0;
// model.QueryType = "PatientDiagnose";
// bool boo = queryRecoder.Add(model) > 0;
// if (bo && boo)
// {
// result = true;
// }
// else { result = false; }
// }
// return result;
//}
private List<Model.QueryRecoder> CheckQueryRecord(Model.QueryRecoder model)
{
QueryRecoder queryRecoder = new QueryRecoder();
//查询本地数据库有没有数据
StringBuilder strWhere = new StringBuilder();
strWhere.AppendFormat("Uname = {0} and ", "'" + model.Uname + "'");
strWhere.AppendFormat("Code = {0} and ", "'" + model.Code + "'");
strWhere.AppendFormat("CodeType = {0} and ", "'" + model.CodeType + "'");
strWhere.AppendFormat("IsDel = {0} and ", "'" + model.IsDel + "'");
strWhere.AppendFormat("QueryType = {0} and ", "'" + model.QueryType + "'");
strWhere.AppendFormat("IsDel = {0}", "'" + false + "'");
//查询条件是，当前用户添加的卡号为X的卡号类型为Y的没有标记删除的并且临床数据类型为Z的数据
return queryRecoder.GetModelList(strWhere.ToString());
}
/// <summary>
/// ɾ������
/// </summary>
/// <param name="context"></param>
private static void DeleteData(HttpContext context)
{
string mes = "";
if (context.Request["pk"] != null)
{
string pk = context.Request["pk"];
string[] ArrayPk = pk.Split(',');
ArrayList list = new ArrayList();
for (int i = 0; i < ArrayPk.Length - 1; i++)
{
string strnull = ArrayPk[i];
if (strnull != "")
{
list.Add(ArrayPk[i]);
}
}
RuRo.BLL.QueryRecoder bll_QueryRecoder = new BLL.QueryRecoder();
int successNumber = 0;
string errorMessage = "";
foreach (string strPk in list)
{
if (bll_QueryRecoder.Delete(int.Parse(strPk)))
{
successNumber += 1;
}
}
mes = "�ɹ�ɾ��[" + successNumber.ToString() + "/" + ArrayPk.Length.ToString() + "]������;" + errorMessage;
}
else
{
mes = "PK�ֶ�ΪNull";
}
context.Response.Write(mes);
}
/// <summary>
/// ��ѯ����
/// </summary>
/// <param name="context"></param>
private static void QueryData(HttpContext context)
{
string adddate = context.Request.Params["adddate"].ToString();
string username = Common.CookieHelper.GetCookieValue("username");
RuRo.BLL.QueryRecoder bll = new BLL.QueryRecoder();
List<Model.QueryRecoder> list = bll.GetModelList("IsDel=0 and AddDate!='" + adddate + "' and Uname='" + username + "'");
string mes = FreezerProUtility.Fp_Common.FpJsonHelper.ObjectToJsonStr(list);
context.Response.Write(mes);
}