/// <summary>
/// 修改订单明细对应结果已出状态
/// </summary>
/// <param name="SQLlist"></param>
private void UpdateOutSpecimentest(SortedList SQLlist, DataTable dt, DataRow dr)
{
DAOutspecimentest _outspecimentest = new DAOutspecimentest();
if (dr["RequestCode"] != DBNull.Value)
{
_outspecimentest.Requestcode = dr["RequestCode"].ToString(); //更新条件
_outspecimentest.Status = "0"; //更新条件
}
SQLlist.Add(new Hashtable()
{
{ "UPDATE", "UpdateDAOutspecimentestStatus" }
}, _outspecimentest);
if (dt == null)
{
return;
}
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow drresult = dt.Rows[i];
DAOutspecimentest _test = new DAOutspecimentest();
if (dr["RequestCode"] != DBNull.Value)
{
_test.Requestcode = dr["RequestCode"].ToString();//更新条件
}
if (dt.Columns.Contains("testcode") && drresult["testcode"] != DBNull.Value)
{
_test.Datestcode = drresult["testcode"].ToString();//更新条件
}
_test.Status = "1";
SQLlist.Add(new Hashtable()
{
{ "UPDATE", "UpdateDAOutspecimentestStatus" }
}, _test);
}
}
// 扫描达安条码 插入订单
private void txtDaanBarcode_KeyPress(object sender, KeyPressEventArgs e)
{
//是否回车键
if (e.KeyChar != (char)Keys.Enter)
{
return;
}
string barcode = this.txtDaanBarcode.Text.Trim();
this.txtDaanBarcode.Text = string.Empty;
if (barcode == "")
{
ShowMessageHelper.ShowBoxMsg("达安条码不能为空！"); return;
}
Regex r = new Regex(@"^\d*00$|\:"); //正则12位数字尾数必须为0
//达安条码为12位
if (barcode.Length != 12)
{
ShowMessageHelper.ShowBoxMsg("请核对达安条码为12位数字！"); return;
}
//达安条码为数字
if (!r.IsMatch(barcode))
{
ShowMessageHelper.ShowBoxMsg("请核对达安条码后两位为0的12位数字！"); return;
}
if (gvLisrequest.RowCount == 0)
{
ShowMessageHelper.ShowBoxMsg("无医院相关信息！"); return;
}
BindingSource TestData = gvDaLis.DataSource as BindingSource;
if (TestData.Count == 0)
{
ShowMessageHelper.ShowBoxMsg("没有项目,不能添加！"); return;
}
try
{
#region >>>> zhouy 添加过滤
//选中的当前行
VDaLisrequest vda = (VDaLisrequest)gvLisrequest.Rows[gvLisrequest.CurrentCell.RowIndex].DataBoundItem;
//是否存在相同的达安条码
List <DAOutspecimen> daoutlist = outspecimenbll.GetOutspecimenList(new Hashtable()
{
{ "txtRequestcode", barcode }
});
if (daoutlist.Count > 0)
{
ShowMessageHelper.ShowBoxMsg("已存在相同的达安条码！"); return;
}
#endregion
#region >>>插入订单主表、从表、结果表
//项目列表 取列表项目，可见见即可得
List <VDaLisrequesttest> VTestList = ((BindingCollection <VDaLisrequesttest>)TestData.List).ToList().FindAll(c => c.IsSelect);
//项目是否匹配
if (VTestList.FindAll(c => c.Datestcode == "").Count != 0)
{
ShowMessageHelper.ShowBoxMsg("项目不匹配，数据添加失败！"); return;
}
SortedList SQLlist = new SortedList(new MySort());
#region >>>> zhouy 申请单
DAOutspecimen daoutspecimen = new DAOutspecimen();
int age = 0;
if (vda.Age != null && vda.Age != "")
{
if (!int.TryParse(vda.Age, out age))
{
ShowMessageHelper.ShowBoxMsg("年龄格式不对！"); return;
}
//如果年龄大于200岁
if (age > 200 && age < 0 && vda.Ageunit == "0")
{
ShowMessageHelper.ShowBoxMsg("年龄不能大于200岁！"); return;
}
}
daoutspecimen.Age = age;
daoutspecimen.Requestcode = barcode;
daoutspecimen.Hospsampleid = vda.Hospsampleid;
// if (chxHosNumer.Checked) {
daoutspecimen.Hospsamplenumber = vda.Hospsamplenumber;
// }
daoutspecimen.Customercode = SystemConfig.Config.Username;
daoutspecimen.Remark = "";
daoutspecimen.Patientnumber = vda.Patientnumber;
daoutspecimen.Bednumber = vda.Bednumber;
daoutspecimen.Samplingdate = vda.Samplingdate;
daoutspecimen.Patientsource = vda.Patientnumber;
daoutspecimen.Patientname = vda.Pname;
daoutspecimen.Bodystyle = vda.Bodystyle;
daoutspecimen.Sex = vda.Sex;
daoutspecimen.Patienttel = vda.Patienttel;
daoutspecimen.Location = vda.Sectionoffice;
daoutspecimen.Doctor = vda.Doctor;
daoutspecimen.Doctortel = vda.Doctortel;
daoutspecimen.Birthday = vda.Birthday;
daoutspecimen.Ageunit = vda.Ageunit;
daoutspecimen.Diagnostication = vda.Diagnostication;
daoutspecimen.Status = "0";
daoutspecimen.Babycount = vda.Babycount;
daoutspecimen.Lmp = vda.Lmp;
daoutspecimen.Lmpdate = vda.Lmpdate;
daoutspecimen.Uninevolumn = vda.Uninevolumn.ToString();
daoutspecimen.Weight = vda.Weight.ToString();
daoutspecimen.Height = vda.Height.ToString();
daoutspecimen.Bultrasonic = vda.Bultrasonic;
daoutspecimen.Pregnant = vda.Pregnant;
daoutspecimen.Enterby = SystemConfig.UserInfo.UserCode; //"";//录单人
daoutspecimen.Enterbydate = DateTime.Now;
daoutspecimen.Lastupdatedate1 = DateTime.Now;
daoutspecimen.Createdate = DateTime.Now;
daoutspecimen.Usertype = SystemConfig.UserInfo.UserType.ToString();
#endregion
//显示校验医院项目是否与达安项目匹配
List <string> strCoustomercode = new List <string>(); //客户项目代码
List <string> strCoustomername = new List <string>(); //客户项目名称
List <string> strDatecode = new List <string>(); //达安项目代码
List <string> strDatename = new List <string>(); //达安项目名称
//查询系统中 医院中的所有项目
Hashtable ht = new Hashtable();
ht.Add("Hospsampleid", daoutspecimen.Hospsampleid);
List <DAResult> _daresult = new DAResultBLL().GetDAResultList(ht); //显示基本信息
foreach (VDaLisrequesttest vdl in VTestList)
{
string[] dacodearr = vdl.Datestcode.Split(',');
#region >>>> 申请单项目表
for (int i = 0; i < dacodearr.Length; i++)
{
string dacode = dacodearr[i].Trim();
string daname = "";
IEnumerable <string> IEdaname = from a in DaTestList
where a.Datestcode.Trim() == dacode
select a.Datestname;
if (IEdaname.Count() == 0)
{
//dacode = daname = "";
ShowMessageHelper.ShowBoxMsg(string.Format("达安项目中不存在编号为[{0}]的项目！", dacode)); return;
}
// else { daname = IEdaname.First(); }
DAOutspecimentest daouttest = new DAOutspecimentest();
daouttest.Hospsampleid = vda.Hospsampleid;
//if (chxHosNumer.Checked) {
daouttest.Hospsamplenumber = vda.Hospsamplenumber;
// }
daouttest.Requestcode = barcode;
daouttest.Customertestcode = vdl.Testcode;
daouttest.Customertestname = vdl.Testname;
daouttest.Datestcode = dacode;
daouttest.Datestname = daname;
daouttest.Createdate = DateTime.Now;
SQLlist.Add(new Hashtable()
{
{ "INSERT", "Da.InsertDAOutspecimentest" }
}, daouttest);
}
#endregion
//保存重复过的项目名称
string testnamelist = "";
#region >>>> 插入结果表
List <VDAListests> vdalisttest = new VDAListestsBLL().GetVDaListestsresultByCode(new Hashtable()
{
{ "Testcode", vdl.Testcode }
});
foreach (VDAListests item in vdalisttest)
{
DAResult daResult = new DAResult();
daResult.Requestcode = barcode;
daResult.Hospsampleid = vda.Hospsampleid;
//if (chxHosNumer.Checked) {
daResult.Hospsamplenumber = vda.Hospsamplenumber;
// }
daResult.Testtype = item.Testtype;
daResult.Customergroupcode = item.CustomerGroupCode; //医院组合代码
daResult.Customergroupname = item.CustomerGroupName; //医院组合名称
daResult.Customertestcode = item.Subtestcode; //医院单项代码
daResult.Customertestname = item.Subtestname; //医院单项名称
//不存在单项名 取组合名
if (item.Subtestcode == null || item.Subtestcode == "")
{
daResult.Customertestcode = item.CustomerGroupCode; //医院单项代码
daResult.Customertestname = item.CustomerGroupName; //医院单项名称
}
//如果已经插入系统的项目 再次扫描不允许插入
if (_daresult.FindAll(c => c.Customertestcode.Trim() == daResult.Customertestcode.Trim()).Count > 0)
{
testnamelist += daResult.Customertestname + ",";
continue;
}
daResult.Dagroupcode = string.Empty;
daResult.Dagroupname = string.Empty;
daResult.Datestcode = string.Empty; //达安单项代码
daResult.Datestname = string.Empty; //达安单项名称
SQLlist.Add(new Hashtable()
{
{ "INSERT", "InsertDAResult" }
}, daResult);
}
#endregion
//同意医院条码有重复项目
if (testnamelist != "")
{
ShowMessageHelper.ShowBoxMsg(
string.Format("送检人【{0}】医院条码[{1}]的项目[{2}]已经添加到系统中,分开条码请先删除已添加的项目，或者去掉勾选",
daoutspecimen.Patientname, daoutspecimen.Hospsampleid, testnamelist.TrimEnd(',')));
return;
}
daoutspecimen.Customertestcodes += vdl.Testcode + ",";
daoutspecimen.Customertestnames += vdl.Testname + ",";
daoutspecimen.Datestcodes += vdl.Datestcode + ",";
daoutspecimen.Datestnames += vdl.Datestname + ",";
}
daoutspecimen.Customertestcodes = daoutspecimen.Customertestcodes.TrimEnd(',');
daoutspecimen.Customertestnames = daoutspecimen.Customertestnames.TrimEnd(',');
daoutspecimen.Datestcodes = daoutspecimen.Datestcodes.TrimEnd(',');
daoutspecimen.Datestnames = daoutspecimen.Datestnames.TrimEnd(',');
SQLlist.Add(new Hashtable()
{
{ "INSERT", "Da.InsertDAOutspecimen" }
}, daoutspecimen);
#region >>>> 写操作日志
DAOperationlog daoperationlog = new DAOperationlog();
daoperationlog.Dictuserid = SystemConfig.UserInfo.UserId == "" ? 0 : Convert.ToDecimal(SystemConfig.UserInfo.UserId);
daoperationlog.Usercode = SystemConfig.UserInfo.UserCode;
daoperationlog.Username = SystemConfig.UserInfo.UserName;
daoperationlog.Usertype = SystemConfig.UserInfo.UserType.ToString();
daoperationlog.Optype = "新增订单信息";
daoperationlog.Createdate = DateTime.Now;
daoperationlog.Opcontent = "生成订单号：" + barcode;
daoperationlog.Requestcode = barcode;
daoperationlog.Hospsampleid = vda.Hospsampleid;
// if (chxHosNumer.Checked) {
daoperationlog.Hospsamplenumber = vda.Hospsamplenumber;
// }
SQLlist.Add(new Hashtable()
{
{ "INSERT", "InsertDAOperationlog" }
}, daoperationlog);
#endregion
string errmsg = "";
if (!outspecimenbll.ExecuteSqlTran(SQLlist, ref errmsg))
{
ShowMessageHelper.ShowBoxMsg("添加失败！:" + errmsg); return;
}
DataBind(daoutspecimen);
this.txtBarcode.Focus();
#endregion
}
catch (Exception Ex)
{
ShowMessageHelper.ShowBoxMsg("添加订单异常:" + Ex.Message);
return;
}
}
