/// <summary>上传体检订单
///
/// </summary>
/// <param name="xmlStr"></param>
/// <returns></returns>
public static string UploadOrderInfo(string xmlStr)
{
xmlStr = xmlStr.TrimStart('');
string str = "<?xml version='1.0' encoding='utf-8'?>" + StringToXML(xmlStr);
string strMessage = string.Empty;
DataTable dt = new DataTable();
try
{
dt = GetDataTable(str);
}
catch (Exception ex)
{
return(String.Format("{0} {1}", ErrorCode.Up_0001, ex.Message));
}
if (dt == null || dt.Rows.Count == 0 || dt.Columns.Count != 20)
{
return(ErrorCode.Up_0002);
}
List <Dicttestitem> TestItemList = loginservice.GetLoginDicttestitemList(); //项目字典表
List <Dictproductdetail> ProductDetail = loginservice.GetLoginDictproductdetail(); //套餐组合字典
string _productname = string.Empty;
foreach (DataRow dr in dt.Rows)
{
#region 必填项
//套餐代码
string productTestCode = dr["uniquecode"].ToString().Replace('_', ' ').Trim();
//客户代码
string dictcustomerid = dr["dictcustomerid"].ToString().Trim();
//姓名
string realname = dr["realname"].ToString().Trim();
//性别
string sex = dr["sex"].ToString().Replace('_', ' ').Trim() == "女" ? "F" : (dr["sex"].ToString().Replace('_', ' ').Trim() == "男" ? "M" : "U");
//婚否
string ismarried = dr["ismarried"].ToString().Trim();
//手机
string mobile = dr["mobile"].ToString().Trim();
//住址
string address = dr["address"].ToString().Trim();
//省
string province = dr["province"].ToString().Trim();
//市
string city = dr["city"].ToString().Trim();
//分点实验室
string dictlabid = dr["dictlabid"].ToString().Trim();
//条码号
string barcode = dr["barcode"].ToString().Trim();
if (string.IsNullOrEmpty(productTestCode) || string.IsNullOrEmpty(dictcustomerid) || string.IsNullOrEmpty(dictlabid) || string.IsNullOrEmpty(barcode) ||
string.IsNullOrEmpty(realname) || string.IsNullOrEmpty(sex) || string.IsNullOrEmpty(ismarried) ||
string.IsNullOrEmpty(mobile) || string.IsNullOrEmpty(address) || string.IsNullOrEmpty(province) || string.IsNullOrEmpty(city))
{
strMessage = ErrorCode.Up_0003;
break;
}
#endregion
#region 二者不可都为空
//出生日期
string birthday = dr["birthday"].ToString().Trim();
//年龄
string age = dr["age"].ToString().Trim();
if (string.IsNullOrEmpty(birthday) && string.IsNullOrEmpty(age))
{
strMessage = ErrorCode.Up_0004;
break;
}
#endregion
#region 可空字段
//身份证
string idnumber = dr["idnumber"].ToString().Trim();
//部门
string section = dr["section"].ToString().Trim();
//备注
string remark = dr["remark"].ToString().Trim();
//电话
string phone = dr["phone"].ToString().Trim();
//邮箱
string email = dr["email"].ToString().Trim();
//采样日期
string samplingdate = dr["samplingdate"].ToString().Trim();
//区
string county = dr["county"].ToString().Trim();
#endregion
DateTime datebirthday;
bool datebirthdayb = DateTime.TryParse(birthday, out datebirthday);
DateTime datesamplingdate;
bool datesamplingdateb = DateTime.TryParse(samplingdate, out datesamplingdate);
if ((birthday != string.Empty && !datebirthdayb) || (samplingdate != string.Empty && !datesamplingdateb))
{
strMessage = ErrorCode.Up_0010;
break;
}
//检查单位是否在体检系统中有维护
try
{
using (DataTable d = customerservice.CheckHasCustomer(dictcustomerid))
{
if (d == null || d.Rows.Count == 0 || d.Rows.Count > 1)
{
strMessage = ErrorCode.Up_0011;
break;
}
}
}
catch (Exception ee)
{
strMessage = ErrorCode.Up_0015 + " " + ee.Message;
break;
}
#region 添加套餐
//查询分点+公用套餐
List <Dicttestitem> productlistTemp = new DicttestitemService().GetProduct(TypeParse.StrToDouble(dictcustomerid, 0));
List <Dicttestitem> productList = productlistTemp.Where <Dicttestitem>(c => c.Testcode == productTestCode && (c.Forsex == sex || c.Forsex == "B")).ToList <Dicttestitem>();
List <Dicttestitem> grouptestList = new List <Dicttestitem>();
Dicttestitem productinfo = null;
if (productList.Count == 0)
{
strMessage = ErrorCode.Up_0005;
break;
}
else if (productList.Count > 1)
{
strMessage = ErrorCode.Up_0006;
break;
}
else
{
productinfo = productList.First <Dicttestitem>();
List <OrderRegister> _gridtestList = null;
#region 添加套餐
string msg = registerservice.AddProduct(ref _gridtestList, sex, productinfo.Dicttestitemid, false, null, ref _productname, null);
if (msg != string.Empty)
{
strMessage = ErrorCode.Up_0014;
break;
}
#endregion
if (barcode != string.Empty && barcode.Length != 12)//条码号必须为12位数字
{
strMessage = ErrorCode.Up_0007;
break;
}
if (barcode != string.Empty && barcode.Substring(barcode.Length - 2) != "00")//条码号必须以00结尾
{
strMessage = ErrorCode.Up_0008;
break;
}
//检验条码号是否合格且存在于体检系统
DataTable dtBarcode = barcodeservice.CheckBarCode2(barcode);
if (dtBarcode != null && dtBarcode.Rows.Count > 0)
{
//判断已存在的条码是否来自大众平台
if (!dtBarcode.Rows[0]["enterby"].ToString().Contains("大众平台"))
{
//条码已存在且不是通过大众平台上传
strMessage = ErrorCode.Up_0009;
break;
}
else
{
//判断该条码是否已经上传到康源系统，否则不允许修改；
if (dtBarcode.Rows[0]["transed"].ToString() == "1")
{
strMessage = ErrorCode.Update_0005;
break;
}
//删除该体检系统中订单
string ordernum = dtBarcode.Rows[0]["ordernum"].ToString();
Hashtable ht = new Hashtable();
ht["ordernum"] = ordernum;
new ProCentralizedManagementService().DeleteOrders(ht);
}
}
//套餐下组合项目
IEnumerable <Dictproductdetail> IEgroup = ProductDetail.Where <Dictproductdetail>(c => c.Productid == productinfo.Dicttestitemid);
bool iscontinue = true;
int count = IEgroup.Count <Dictproductdetail>();
int k = 0;
foreach (Dictproductdetail item in IEgroup)
{
IEnumerable <Dicttestitem> IEgruptest = TestItemList.Where <Dicttestitem>(c => c.Dicttestitemid == item.Testgroupid);
if (IEgruptest.Count() <= 0)
{
//没有找到套餐下组合
k++;
continue;
}
Dicttestitem groupinfo = IEgruptest.First <Dicttestitem>();
//校验性别是否符合
string res = registerservice.checkSex(groupinfo.Dicttestitemid, sex);
if (res != string.Empty)
{
//性别项目不合
strMessage = ErrorCode.Up_0012;
iscontinue = false;
break;
}
groupinfo.Productid = productinfo.Dicttestitemid;
groupinfo.Productname = productinfo.Testname; ///套餐名
groupinfo.IsActive = "1"; //是否停止测试
groupinfo.Isadd = "0"; ///是否追加
groupinfo.Billed = "0";
groupinfo.Sendbilled = "0";
groupinfo.Adduserid = null;//追加人ID
if (barcode == string.Empty)
{
IEnumerable <Dicttestitem> IEtempbarcodeList = grouptestList.Where <Dicttestitem>(c => c.Tubegroup == groupinfo.Tubegroup);
if (IEtempbarcodeList.Count() > 0)
{
groupinfo.Barcode = IEtempbarcodeList.First <Dicttestitem>().Barcode;
}
else
{
groupinfo.Barcode = registerservice.GetBarCode();
}
}
else
{
groupinfo.Barcode = barcode;
}
//获取外包客户
Dictproductdetail detail = ProductDetail.Where <Dictproductdetail>(c => c.Productid == productinfo.Dicttestitemid && c.Testgroupid == groupinfo.Dicttestitemid).First <Dictproductdetail>();
groupinfo.Sendoutcustomerid = detail.Sendoutcustomerid;
grouptestList.Add(groupinfo);
}
if (!iscontinue)
{
continue;
}
else
{
if (k >= count)
{
strMessage = ErrorCode.Up_0013;
break;
}
}
}
#endregion
#region 添加会员信息
Dictmember member = new Dictmember()
{
Realname = realname, Idnumber = idnumber
};
registerservice.checkmember(null, ref member);
if (datebirthdayb)
{
member.Birthday = datebirthday;
}
member.Nickname = member.Realname;
member.Sex = sex;
member.Addres = address;
member.Phone = phone;
member.Mobile = mobile;
member.Email = email;
#endregion
#region 添加订单
double year = 0, month = 0, day = 0;
double hours = 0;
double aged = 0;
string agestr = age;
bool ageb = double.TryParse(agestr, out aged);
if (member.Birthday == null)
{
if (agestr != string.Empty && ageb)
{
year = aged;
day = aged * 365;
member.Birthday = datebirthday = DateTime.Now.AddDays((0 - day));
}
else
{
strMessage = ErrorCode.Up_0004;
break;
}
}
TimeSpan ts = DateTime.Now - Convert.ToDateTime(member.Birthday);//时间差
year = Math.Truncate((double)(ts.Days / 365));
month = (ts.Days % 365) / 30;
day = (ts.Days % 365) % 30;
hours = ts.TotalHours;
Orders _orders = new Orders()
{
Ordernum = new ProRegisterService().GetOrderNum(),
Dictmemberid = member.Dictmemberid,
Dictcustomerid = Convert.ToDouble(dictcustomerid),
Realname = realname,
Sex = sex,
Caculatedage = hours,
Remarks = remark,
Age = string.Format("{0}岁{1}月{2}日{3}时", year, month, day, 0),
Enterby = enterby,
Ordertestlst = _productname + ",",
Dictlabid = Convert.ToDouble(dictlabid),
Ordersource = "1",
Ismarried = ismarried == "未婚" ? "0" : (ismarried == "已婚" ? "1" : "2"),
Section = section,
Status = ((int)daan.service.common.ParamStatus.OrdersStatus.BarCodePrint).ToString(),
Province = province,
City = city,
County = county
};
if (datesamplingdateb)
{
_orders.SamplingDate = datesamplingdate;
}
string errstr = string.Empty;
System.Collections.Hashtable htScan = new System.Collections.Hashtable();
htScan.Add("isScan", true);
htScan.Add("EnterByID", enterbyID);
htScan.Add("EnterBy", enterby);
bool b = registerservice.insertUpdateOrders("大众健康平台对接订单", "", true, productList, grouptestList, member, _orders, "", ref errstr, htScan);
if (!b)
{
strMessage = String.Format("{0} {1}", ErrorCode.Up_0015, errstr);
break;
}
#endregion
}
return(strMessage);
}
/// <summary>
/// 接收数据
/// </summary>
/// <param name="SID"></param>
/// <param name="XML"></param>
/// <returns></returns>
public static string ReceiveXMLData(string SID, string xmlStr)
{
xmlStr = xmlStr.TrimStart('');
// if (xmlStr == string.Empty)
// {
// xmlStr = @"
// <data><datarow>
// <uniquecode >TY0008</uniquecode >
// <dictcustomerid>1396</dictcustomerid>
// <barcode>380003772900</barcode>
// <realname>马昌武3</realname>
// <sex>男</sex>
// <birthday></birthday>
// <age>41</age>
// <ismarried>未知</ismarried>
// <mobile>13096786113</mobile>
// <idnumber></idnumber>
// <address>地址</address>
// <section>遵义</section>
// <remark>备注</remark>
// <phone></phone>
// <email></email>
// <samplingdate>2014-12-18</samplingdate>
// <province>广东</province>
// <city>广州市</city>
// <county>天河区</county>
// <dictlabid>3</dictlabid>
// </datarow></data>
// ";
// }
string str = "<?xml version='1.0' encoding='utf-8'?>" + StringToXML(xmlStr);
string strMessage = string.Empty;
//缓存取登录用户
Cache cache = new Cache();
CacheInfo info = cache.GetCacheData(SID);
DataTable dt = new DataTable();
try
{
dt = GetDataTable(str);
}
catch (Exception ex)
{
return(String.Format("{0} {1}", ErrorCode.Rec_1002, ex.Message));
}
if (dt == null || dt.Rows.Count == 0 || dt.Columns.Count != 20)
{
return(ErrorCode.Rec_1003);
}
List <Dicttestitem> TestItemList = loginservice.GetLoginDicttestitemList(); //项目字典表
List <Dictproductdetail> ProductDetail = loginservice.GetLoginDictproductdetail(); //套餐组合字典
string _productname = string.Empty;
foreach (DataRow dr in dt.Rows)
{
#region 必填项
//套餐代码
string productTestCode = dr["uniquecode"].ToString().Replace('_', ' ').Trim();
//客户代码
string dictcustomercode = dr["dictcustomerid"].ToString().Trim();
//条码号
string barcode = dr["barcode"].ToString().Trim();
//姓名
string realname = dr["realname"].ToString().Trim();
//性别
string sex = dr["sex"].ToString().Replace('_', ' ').Trim() == "女" ? "F" : (dr["sex"].ToString().Replace('_', ' ').Trim() == "男" ? "M" : "U");
//婚否
string ismarried = dr["ismarried"].ToString().Trim();
//手机
string mobile = dr["mobile"].ToString().Trim();
//住址
string address = dr["address"].ToString().Trim();
//省
string province = dr["province"].ToString().Trim();
//市
string city = dr["city"].ToString().Trim();
//分点实验室
string dictlabid = dr["dictlabid"].ToString().Trim();
if (string.IsNullOrEmpty(productTestCode) || string.IsNullOrEmpty(dictcustomercode) || string.IsNullOrEmpty(dictlabid) ||
string.IsNullOrEmpty(realname) || string.IsNullOrEmpty(sex) || string.IsNullOrEmpty(ismarried) ||
string.IsNullOrEmpty(mobile) || string.IsNullOrEmpty(address) || string.IsNullOrEmpty(province) || string.IsNullOrEmpty(city))
{
strMessage = ErrorCode.Rec_1005;
break;
}
#endregion
#region 二者不可都为空
//出生日期
string birthday = dr["birthday"].ToString().Trim();
//年龄
string age = dr["age"].ToString().Trim();
if (string.IsNullOrEmpty(birthday) && string.IsNullOrEmpty(age))
{
strMessage = ErrorCode.Rec_1006;
break;
}
#endregion
#region 可空字段
//身份证
string idnumber = dr["idnumber"].ToString().Trim();
//部门
string section = dr["section"].ToString().Trim();
//备注
string remark = dr["remark"].ToString().Trim();
//电话
string phone = dr["phone"].ToString().Trim();
//邮箱
string email = dr["email"].ToString().Trim();
//采样日期
string samplingdate = dr["samplingdate"].ToString().Trim();
//区
string county = dr["county"].ToString().Trim();
#endregion
DateTime datebirthday;
bool datebirthdayb = DateTime.TryParse(birthday, out datebirthday);
DateTime datesamplingdate;
bool datesamplingdateb = DateTime.TryParse(samplingdate, out datesamplingdate);
if ((birthday != string.Empty && !datebirthdayb) || (samplingdate != string.Empty && !datesamplingdateb))
{
strMessage = ErrorCode.Rec_1013;
break;
}
//检查单位是否在体检系统中有维护
string dictcustomerid = string.Empty;
try
{
using (DataTable d = customerservice.CheckHasCustomer(dictcustomercode))
{
if (d == null || d.Rows.Count == 0 || d.Rows.Count > 1)
{
strMessage = ErrorCode.Up_0011;
break;
}
else
{
dictcustomerid = d.Rows[0][0].ToString();
}
}
}
catch (Exception ee)
{
strMessage = ErrorCode.Up_0015 + " " + ee.Message;
break;
}
#region 添加套餐
//查询分点+公用套餐
List <Dicttestitem> productlistTemp = new DicttestitemService().GetProduct(TypeParse.StrToDouble(dictcustomerid, 0));
List <Dicttestitem> productList = productlistTemp.Where <Dicttestitem>(c => c.Testcode == productTestCode && (c.Forsex == sex || c.Forsex == "B")).ToList <Dicttestitem>();
List <Dicttestitem> grouptestList = new List <Dicttestitem>();
Dicttestitem productinfo = null;
if (productList.Count == 0)
{
strMessage = ErrorCode.Rec_1008;
break;
}
else if (productList.Count > 1)
{
strMessage = ErrorCode.Rec_1009;
break;
}
else
{
productinfo = productList.First <Dicttestitem>();
List <OrderRegister> _gridtestList = null;
#region 添加套餐
string msg = registerservice.AddProduct(ref _gridtestList, sex, productinfo.Dicttestitemid, false, null, ref _productname, null);
if (msg != string.Empty)
{
strMessage = ErrorCode.Rec_1017;
break;
}
#endregion
if (barcode != string.Empty && barcode.Length != 12)//条码号必须为12位数字
{
strMessage = ErrorCode.Rec_1010;
break;
}
if (barcode != string.Empty && barcode.Substring(barcode.Length - 2) != "00")//条码号必须以00结尾
{
strMessage = ErrorCode.Rec_1011;
break;
}
if (barcodeservice.CheckBarCode(barcode))//条码号已在系统中存在
{
strMessage = ErrorCode.Rec_1012;
break;
}
//套餐下组合项目
IEnumerable <Dictproductdetail> IEgroup = ProductDetail.Where <Dictproductdetail>(c => c.Productid == productinfo.Dicttestitemid);
bool iscontinue = true;
int count = IEgroup.Count <Dictproductdetail>();
int k = 0;
foreach (Dictproductdetail item in IEgroup)
{
IEnumerable <Dicttestitem> IEgruptest = TestItemList.Where <Dicttestitem>(c => c.Dicttestitemid == item.Testgroupid);
if (IEgruptest.Count() <= 0)
{
//没有找到套餐下组合
k++;
continue;
}
Dicttestitem groupinfo = IEgruptest.First <Dicttestitem>();
//校验性别是否符合
string res = registerservice.checkSex(groupinfo.Dicttestitemid, sex);
if (res != string.Empty)
{
//性别项目不合
strMessage = ErrorCode.Rec_1015;
iscontinue = false;
break;
}
groupinfo.Productid = productinfo.Dicttestitemid;
groupinfo.Productname = productinfo.Testname; ///套餐名
groupinfo.IsActive = "1"; //是否停止测试
groupinfo.Isadd = "0"; ///是否追加
groupinfo.Billed = "0";
groupinfo.Sendbilled = "0";
groupinfo.Adduserid = null;//追加人ID
if (barcode == string.Empty)
{
IEnumerable <Dicttestitem> IEtempbarcodeList = grouptestList.Where <Dicttestitem>(c => c.Tubegroup == groupinfo.Tubegroup);
if (IEtempbarcodeList.Count() > 0)
{
groupinfo.Barcode = IEtempbarcodeList.First <Dicttestitem>().Barcode;
}
else
{
groupinfo.Barcode = registerservice.GetBarCode();
}
}
else
{
groupinfo.Barcode = barcode;
}
//获取外包客户
Dictproductdetail detail = ProductDetail.Where <Dictproductdetail>(c => c.Productid == productinfo.Dicttestitemid && c.Testgroupid == groupinfo.Dicttestitemid).First <Dictproductdetail>();
groupinfo.Sendoutcustomerid = detail.Sendoutcustomerid;
grouptestList.Add(groupinfo);
}
if (!iscontinue)
{
continue;
}
else
{
if (k >= count)
{
strMessage = ErrorCode.Rec_1016;
break;
}
}
}
#endregion
#region 添加会员
Dictmember member = new Dictmember()
{
Realname = realname, Idnumber = idnumber, Nickname = realname, Sex = sex, Addres = address,
Phone = phone, Mobile = mobile, Email = email
};
if (datebirthdayb)
{
member.Birthday = datebirthday;
}
registerservice.checkmember(null, ref member);
#endregion
#region 添加订单
double year = 0, month = 0, day = 0;
double hours = 0;
double aged = 0;
string agestr = age;
bool ageb = double.TryParse(agestr, out aged);
if (member.Birthday == null)
{
if (agestr != string.Empty && ageb)
{
year = aged;
day = aged * 365;
member.Birthday = datebirthday = DateTime.Now.AddDays((0 - day));
}
else
{
strMessage = ErrorCode.Rec_1006;
break;
}
}
TimeSpan ts = DateTime.Now - Convert.ToDateTime(member.Birthday);//时间差
year = Math.Truncate((double)(ts.Days / 365));
month = (ts.Days % 365) / 30;
day = (ts.Days % 365) % 30;
hours = ts.TotalHours;
Orders _orders = new Orders()
{
Ordernum = new ProRegisterService().GetOrderNum(),
Dictmemberid = member.Dictmemberid, Dictcustomerid = Convert.ToDouble(dictcustomerid),
Realname = realname, Sex = sex, Caculatedage = hours, Remarks = remark,
Age = string.Format("{0}岁{1}月{2}日{3}时", year, month, day, 0), Enterby = "admin",
Ordertestlst = _productname + ",", Dictlabid = Convert.ToDouble(dictlabid), Ordersource = "1",
Ismarried = ismarried == "未婚" ? "0" : (ismarried == "已婚" ? "1" : "2"), Section = section,
Status = ((int)daan.service.common.ParamStatus.OrdersStatus.BarCodePrint).ToString(),
Province = province, City = city, County = county
};
if (datesamplingdateb)
{
_orders.SamplingDate = datesamplingdate;
}
string errstr = string.Empty;
bool b = registerservice.insertUpdateOrders("易感基因对接订单", "", true, productList, grouptestList, member, _orders, "", ref errstr);
if (!b)
{
strMessage = String.Format("{0} {1}", ErrorCode.Rec_1018, errstr);
}
#endregion
}
return(strMessage);
}