/// <summary>
/// 更新已经预约的注射项目状态为报到状态
/// </summary>
/// <param name="inject">注射实体</param>
/// <returns>-1失败，1成功</returns>
public int UpdateAlreadyPrecontractInjectItem(Neusoft.HISFC.Models.Nurse.InjectInfo inject)
{
string strsql = "";
if (this.Sql.GetSql("INJECT_UPDATE_ALREADYPRECONTRACTITEM", ref strsql) == -1)
{
return(-1);
}
try
{
strsql = string.Format(strsql,
inject.Order.ReciptNO,
inject.Order.ReciptSequence);
}
catch (Exception ex)
{
this.Err = ex.Message;
return(-1);
}
if (this.ExecNoQuery(strsql) <= 0)
{
return(-1);
}
return(1);
}
/// <summary>
/// 更新已经配药的注射项目的状态，状态为：2[注射窗口使用]
/// 注射状态 0预约,1配药,2注射,3取消,4报到,5巡视,6拔针
/// </summary>
/// <param name="inject">实体</param>
/// <returns>-1失败，1成功</returns>
public int UpdateAlreadyDosageInjectItemState(Neusoft.HISFC.Models.Nurse.InjectInfo inject)
{
string strsql = "";
if (this.Sql.GetSql("INJECT.INJECTCONFIRM.UPDATE", ref strsql) == -1)
{
return(-1);
}
try
{
strsql = string.Format(strsql,
inject.Order.ReciptNO,
inject.Order.ReciptSequence);
}
catch (Exception ex)
{
this.Err = ex.Message;
return(-1);
}
if (this.ExecNoQuery(strsql) <= 0)
{
return(-1);
}
return(1);
}
private void FillNeuspread2(Neusoft.HISFC.Models.Nurse.InjectInfo inject, int number, int rowspan)
{
if (inject == null)
{
return;
}
int rowIndex = this.neuSpread2_Sheet1.Rows.Count;
this.neuSpread2_Sheet1.Rows.Add(rowIndex, 1);
this.neuSpread2_Sheet1.SetText(rowIndex, 0, ""); //ID
this.neuSpread2_Sheet1.SetText(rowIndex, 1, ""); //注射单号
this.neuSpread2_Sheet1.SetText(rowIndex, 4, number.ToString()); //注射次数
this.neuSpread2_Sheet1.SetText(rowIndex, 7, inject.Order.Item.Name); //项目名称
this.neuSpread2_Sheet1.SetText(rowIndex, 9, inject.Order.Item.Specs.ToString()); //规格
this.neuSpread2_Sheet1.SetText(rowIndex, 10, inject.Order.Item.Qty.ToString()); //数量
this.neuSpread2_Sheet1.SetText(rowIndex, 11, inject.Order.Frequency.Name); //频次名称
this.neuSpread2_Sheet1.SetText(rowIndex, 12, inject.Order.Usage.Name); //用法名称
this.neuSpread2_Sheet1.SetText(rowIndex, 13, inject.Order.InjectCount.ToString()); //院注次数
this.neuSpread2_Sheet1.SetText(rowIndex, 14, inject.Order.DoseOnce.ToString()); //一次用量
this.neuSpread2_Sheet1.SetText(rowIndex, 15, inject.Order.DoseUnit); //一次用量单位
//每行的第0列存放对象
this.neuSpread2_Sheet1.Rows[rowIndex].Tag = inject;
//this.neuSpread2_Sheet1.SetTag(rowIndex, 0, inject);
}
private List <Neusoft.HISFC.Models.Nurse.InjectInfo> QueryConfirmItem()
{
if (this.neuSpread1_Sheet1.Rows.Count <= 0)
{
return(null);
}
List <Neusoft.HISFC.Models.Nurse.InjectInfo> injectList = new List <Neusoft.HISFC.Models.Nurse.InjectInfo>();
for (int i = 0; i < this.neuSpread1_Sheet1.Rows.Count; i++)
{
Neusoft.HISFC.Models.Nurse.InjectInfo inject = this.neuSpread1_Sheet1.Rows[i].Tag as Neusoft.HISFC.Models.Nurse.InjectInfo;
if (inject == null)
{
return(null);
}
int temp = 0;
int temp1 = Neusoft.FrameWork.Function.NConvert.ToInt32(inject.User01); //可退数量
int temp2 = Neusoft.FrameWork.Function.NConvert.ToInt32(inject.User02); //已确认数量
/*--------------------------------------*/
if (temp1 > 0)
{
temp1 -= 1;
}
else
{
temp1 = 0;
}
/*--------------------------------------*/
if (temp2 < inject.Order.InjectCount)
{
temp2 += 1;
}
else
{
temp2 = inject.Order.InjectCount;
}
/*--------------------------------------*/
inject.User01 = temp1.ToString();
inject.User02 = temp2.ToString();
injectList.Add(inject);
}
return(injectList);
}
private Neusoft.HISFC.Models.Nurse.InjectRecord Get(Neusoft.HISFC.Models.Nurse.InjectInfo inject)
{
Neusoft.HISFC.Models.Nurse.InjectRecord record = new Neusoft.HISFC.Models.Nurse.InjectRecord();
record.ID = inject.Memo;//注射单号
record.OperEnv.ID = ((Neusoft.HISFC.Models.Base.Employee)Neusoft.FrameWork.Management.Connection.Operator).ID;
record.OperEnv.Name = ((Neusoft.HISFC.Models.Base.Employee)Neusoft.FrameWork.Management.Connection.Operator).Name;
record.OperEnv.OperTime = this.irManager.GetDateTimeFromSysDateTime();
record.OperType = 4;
/* 这几行暂时不用，以后用时再整 */
//record.KBack.ID = "";
//record.KBack.Name = "";
//record.Memo = "";
/*------------------------------*/
return(record);
}
private List <Neusoft.HISFC.Models.Nurse.InjectInfo> QueryConfirmItem()
{
if (this.neuSpread1_Sheet1.Rows.Count <= 0)
{
return(null);
}
List <Neusoft.HISFC.Models.Nurse.InjectInfo> injectList = new List <Neusoft.HISFC.Models.Nurse.InjectInfo>();
for (int i = 0; i < this.neuSpread1_Sheet1.Rows.Count; i++)
{
Neusoft.HISFC.Models.Nurse.InjectInfo inject = this.neuSpread1_Sheet1.Rows[i].Tag as Neusoft.HISFC.Models.Nurse.InjectInfo;
if (inject == null)
{
return(null);
}
injectList.Add(inject);
}
return(injectList);
}
private void ShowPatientInfo(Neusoft.HISFC.Models.Nurse.InjectInfo patient)
{
this.lbName.Text = patient.Order.Patient.Name;
this.lbSex.Text = patient.Order.Patient.Sex.Name;
this.lbBirthday.Text = patient.Order.Patient.Birthday.ToShortDateString();
}
/// <summary>
/// 根据病历号，日期得到已经预约的患者的次注射信息,状态为：0
/// 注射状态 0预约,1配药,2注射,3取消,4报到,5巡视,6拔针
/// </summary>
/// <param name="cardNo">病历号</param>
/// <param name="date">注射日期</param>
/// <returns>null失败</returns>
public List <Neusoft.HISFC.Models.Nurse.InjectInfo> QueryAlreadyPrecontractInjectItem(string cardNo, DateTime date)
{
string strsql = "";
if (this.Sql.GetSql("INJECT_GETAlreadyPrecontractPatient_BY_CARDNO_DATE", ref strsql) == -1)
{
this.Err = "得到INJECT_GETAlreadyPrecontractPatient_BY_CARDNO_DATE语句失败";
return(null);
}
try
{
strsql = string.Format(strsql, cardNo, date.ToShortDateString());
}
catch (Exception ex)
{
this.Err = ex.Message;
return(null);
}
if (this.ExecQuery(strsql) == -1)
{
return(null);
}
List <Neusoft.HISFC.Models.Nurse.InjectInfo> itemList = new List <Neusoft.HISFC.Models.Nurse.InjectInfo>();
try
{
while (this.Reader.Read())
{
Neusoft.HISFC.Models.Nurse.InjectInfo inject = new Neusoft.HISFC.Models.Nurse.InjectInfo();
inject.ID = this.Reader.IsDBNull(0) ? "" : this.Reader[0].ToString(); //表流水号
inject.Memo = this.Reader.IsDBNull(1) ? "" : this.Reader[1].ToString(); //注射单号
inject.Order.Patient.Name = this.Reader.IsDBNull(2) ? "" : this.Reader[2].ToString(); //患者姓名
inject.Order.Patient.Sex.Name = this.Reader.IsDBNull(3) ? "" : this.Reader[3].ToString();//性别
inject.Order.Patient.Birthday = this.Reader.IsDBNull(4) ? DateTime.MinValue : Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[4].ToString());
inject.Name = this.Reader.IsDBNull(5) ? "" : this.Reader[5].ToString();//注射次数，比如第一次注射，没有地方，用NAME存
inject.PrecontractDate = this.Reader.IsDBNull(6) ? DateTime.MinValue : Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[6].ToString()); //预约注射日期
inject.PrecontractOrder = this.Reader.IsDBNull(7) ? "" : this.Reader[7].ToString(); //预约注射序号
inject.InjectType = this.Reader.IsDBNull(8) ? "" : this.Reader[8].ToString(); //注射类型
inject.InjectTypeNumber = this.Reader.IsDBNull(9) ? "" : this.Reader[9].ToString(); //注射类型序号
inject.Order.Item.Name = this.Reader.IsDBNull(10) ? "" : this.Reader[10].ToString(); //项目名称
inject.Order.Item.Specs = this.Reader.IsDBNull(11) ? "" : this.Reader[11].ToString(); //规格
inject.Order.DoseOnce = this.Reader.IsDBNull(12) ? 0 : Neusoft.FrameWork.Function.NConvert.ToDecimal(this.Reader[12].ToString()); //一次用量
inject.Order.DoseUnit = this.Reader.IsDBNull(13) ? "" : this.Reader[13].ToString();//一次用量单位
inject.GlassNum = this.Reader.IsDBNull(14) ? 0 : Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[14].ToString());//接瓶数
inject.Order.Usage.Name = this.Reader.IsDBNull(15) ? "" : this.Reader[15].ToString(); // 用法名称
inject.Order.Frequency.ID = this.Reader.IsDBNull(16) ? "" : this.Reader[16].ToString(); //频次代码
inject.Order.Frequency.Name = this.Reader.IsDBNull(17) ? "" : this.Reader[17].ToString(); //频次名称
inject.Order.Qty = this.Reader.IsDBNull(18) ? 0 : Neusoft.FrameWork.Function.NConvert.ToDecimal(this.Reader[18].ToString()); //开立数量
inject.BaseDose = this.Reader.IsDBNull(19) ? 0 : Neusoft.FrameWork.Function.NConvert.ToDecimal(this.Reader[19].ToString()); //基本剂量
inject.Order.Item.PackQty = this.Reader.IsDBNull(20) ? 0 : Neusoft.FrameWork.Function.NConvert.ToDecimal(this.Reader[20].ToString()); //包装数量
inject.Quality.Name = this.Reader.IsDBNull(21) ? "" : this.Reader[21].ToString(); //药品性质
inject.Dosage.Name = this.Reader.IsDBNull(22) ? "" : this.Reader[22].ToString(); //剂型
inject.IsMainDrug = this.Reader.IsDBNull(23) ? false : Neusoft.FrameWork.Function.NConvert.ToBoolean(this.Reader[23].ToString()); //是否主药
inject.Order.ReciptNO = this.Reader.IsDBNull(24) ? "" : this.Reader[24].ToString(); //处方号
inject.Order.ReciptSequence = this.Reader.IsDBNull(25) ? "" : this.Reader[25].ToString(); //处方内流水号
inject.Order.Patient.PID.CaseNO = this.Reader.IsDBNull(26) ? "" : this.Reader[26].ToString(); //病历号
inject.Order.Patient.PID.CardNO = this.Reader.IsDBNull(27) ? "" : this.Reader[27].ToString();//门诊号
inject.User01 = this.Reader.IsDBNull(28) ? "" : this.Reader[28].ToString(); //可退数量
inject.User02 = this.Reader.IsDBNull(29) ? "" : this.Reader[29].ToString(); //已确认数量
inject.Order.InjectCount = this.Reader.IsDBNull(30) ? 0 : Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[30].ToString());//院注次数
itemList.Add(inject);
}
}
catch (Exception ex)
{
this.Err = ex.Message;
this.Reader.Close();
return(null);
}
this.Reader.Close();
return(itemList);
}
/// <summary>
/// 获取注射项目
/// </summary>
/// <param name="cardNo">病历号</param>
/// <param name="clinicCode">门诊号</param>
/// <returns>null失败</returns>
public List <Neusoft.HISFC.Models.Nurse.InjectInfo> QueryItemListByCardNoAndClinicCode(string cardNo, string clinicCode)
{
if (cardNo == null || clinicCode == null)
{
return(null);
}
string strsql = "";
if (this.Sql.GetSql("INJECT_QUERY_CARD_CLINIC", ref strsql) == -1)
{
this.Err = "INJECT_QUERY_CARD_CLINIC " + this.Sql.Err;
return(null);
}
try
{
strsql = string.Format(strsql, cardNo, clinicCode);
}
catch (Exception ex)
{
this.Err = ex.Message;
return(null);
}
if (this.ExecQuery(strsql) == -1)
{
return(null);
}
Neusoft.HISFC.Models.Nurse.InjectInfo items;
List <Neusoft.HISFC.Models.Nurse.InjectInfo> itemList = new List <Neusoft.HISFC.Models.Nurse.InjectInfo>();
try
{
while (this.Reader.Read())
{
items = new Neusoft.HISFC.Models.Nurse.InjectInfo();
items.Order.ReciptNO = this.Reader.IsDBNull(0) ? "" : this.Reader[0].ToString();//处方号
items.Order.SequenceNO = this.Reader.IsDBNull(2) ? 1 : Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[1].ToString());//处方内顺号
items.Order.ID = this.Reader.IsDBNull(1) ? "" : this.Reader[2].ToString(); //医嘱流水号MO_Order
items.Order.Combo.ID = this.Reader.IsDBNull(3) ? "" : this.Reader[3].ToString(); //组合号
items.Order.Item.ID = this.Reader.IsDBNull(4) ? "" : this.Reader[4].ToString(); //项目编码
items.Order.Item.Name = this.Reader.IsDBNull(5) ? "" : this.Reader[5].ToString(); //项目名称
items.Order.Item.Specs = this.Reader.IsDBNull(6) ? "" : this.Reader[6].ToString(); //规格
items.Order.Item.Qty = this.Reader.IsDBNull(7) ? 0 : Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[7].ToString()); //数量
items.Quality.ID = this.Reader.IsDBNull(8) ? "" : this.Reader[8].ToString(); //药品性质
items.Quality.Name = this.Reader.IsDBNull(9) ? "" : this.Reader[9].ToString(); //药品性质名称
items.Dosage.ID = this.Reader.IsDBNull(10) ? "" : this.Reader[10].ToString(); //剂型
items.Dosage.Name = this.Reader.IsDBNull(11) ? "" : this.Reader[11].ToString(); //剂型名称
items.Order.Frequency.ID = this.Reader.IsDBNull(12) ? "" : this.Reader[12].ToString(); //频次编码
items.Order.Frequency.Name = this.Reader.IsDBNull(13) ? "" : this.Reader[13].ToString(); //频次名称
items.Order.Usage.ID = this.Reader.IsDBNull(14) ? "" : this.Reader[14].ToString(); //用法编码
items.Order.Usage.Name = this.Reader.IsDBNull(15) ? "" : this.Reader[15].ToString(); //用法名称
items.Order.InjectCount = this.Reader.IsDBNull(16) ? 0 : Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[16].ToString()); //院注次数
items.Order.DoseOnce = this.Reader.IsDBNull(17) ? 0 : Neusoft.FrameWork.Function.NConvert.ToDecimal(this.Reader[17].ToString()); //一次用量
items.Order.DoseUnit = this.Reader.IsDBNull(18) ? "" : this.Reader[18].ToString(); //一次用量单位
items.BaseDose = this.Reader.IsDBNull(19) ? 0 : Neusoft.FrameWork.Function.NConvert.ToDecimal(this.Reader[19].ToString()); //基本剂量
items.Order.Item.PackQty = this.Reader.IsDBNull(20) ? 0 : Neusoft.FrameWork.Function.NConvert.ToDecimal(this.Reader[20].ToString()); //包装数量
items.IsMainDrug = this.Reader.IsDBNull(21) ? false : Neusoft.FrameWork.Function.NConvert.ToBoolean(this.Reader[21].ToString()); //是否主药
items.GlassNum = this.Reader.IsDBNull(22) ? 0 : Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[22].ToString()); //分瓶数量
items.User01 = items.Order.InjectCount.ToString(); //可退数量
items.User02 = "0"; //已经确认数量
//items.Order.Patient.PID.CardNO = this.Reader.IsDBNull(23) ? "" : this.Reader[23].ToString();//病历号
//items.Order.Patient.PID.CaseNO = this.Reader.IsDBNull(24) ? "" : this.Reader[24].ToString();//门诊流水号
itemList.Add(items);
}
}
catch (Exception ex)
{
this.Reader.Close();
this.Err = ex.Message;
return(null);
}
this.Reader.Close();
return(itemList);
}