/// <summary>
///
/// </summary>
/// <param name="al">打印数组</param>
/// <param name="current">当前页面数</param>
/// <param name="total">总页数</param>
private void Print(ArrayList al, int current, int total)
{
if (this.neuSpread1_Sheet1.RowCount > 0)
{
this.neuSpread1_Sheet1.RemoveRows(0, this.neuSpread1_Sheet1.RowCount);
}
Neusoft.HISFC.Models.Nurse.Inject info = null;
//接瓶次数
int jpNum = 1;
//赋值并打印
for (int i = 0; i < al.Count; i++)
{
info = (Neusoft.HISFC.Models.Nurse.Inject)al[i];
this.neuSpread1_Sheet1.Rows.Add(0, 1);
if (info.Item.Order.Combo.ID.Length <= 2)
{
this.neuSpread1_Sheet1.Cells[0, 0].Text =
info.Item.Order.Combo.ID;
}
else
{
this.neuSpread1_Sheet1.Cells[0, 0].Text =
info.Item.Order.Combo.ID.Substring(info.Item.Order.Combo.ID.Length - 2, 2);
}
//this.neuSpread1_Sheet1.Cells[0, 0].Text = info.Item.Order.Combo.ID;
if (info.Item.Item.Name != null && info.Item.Item.Name != "")
{
this.neuSpread1_Sheet1.Cells[0, 1].Text = info.Item.Item.Name;
}
else
{
this.neuSpread1_Sheet1.Cells[0, 1].Text = info.Item.Name;
}
jpNum = Neusoft.FrameWork.Function.NConvert.ToInt32(info.Memo);
if (jpNum == 0)
{
jpNum = 1;
}
this.neuSpread1_Sheet1.Cells[0, 2].Text =
Math.Round(info.Item.Order.DoseOnce / jpNum, 3).ToString() + info.Item.Order.DoseUnit.ToString();
this.neuSpread1_Sheet1.Cells[0, 3].Text = "";
this.neuSpread1_Sheet1.Cells[0, 4].Text = "";
this.neuSpread1_Sheet1.Cells[0, 5].Text = " ";
this.neuSpread1_Sheet1.Cells[0, 6].Text = " ";
}
info = (Neusoft.HISFC.Models.Nurse.Inject)al[0];
this.lbCard.Text = info.Patient.PID.CardNO;
this.lbName.Text = info.Patient.Name;
this.lbTime.Text = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
this.lbAge.Text = this.injectMgr.GetAge(info.Patient.Birthday, System.DateTime.Now);
if (info.Patient.Sex.ID.ToString() == "M")
{
this.lbSex.Text = "男";
}
else if (info.Patient.Sex.ID.ToString() == "F")
{
this.lbSex.Text = "女";
}
else
{
this.lbSex.Text = "";
}
this.lbPage.Text = "第" + current.ToString()
+ "页" + "/" + "共" + total.ToString() + "页";
this.neuSpread1_Sheet1.Rows.Add(this.neuSpread1_Sheet1.RowCount, 1);
this.neuSpread1_Sheet1.Cells[this.neuSpread1_Sheet1.RowCount - 1, 1].Text = "拔针";
for (int i = 0; i < this.neuSpread1_Sheet1.RowCount; i++)
{
this.neuSpread1_Sheet1.Columns[2].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right;
}
this.Print();
}
public void Init(ArrayList al)
{
if (this.neuSpread1_Sheet1.RowCount > 0)
{
this.neuSpread1_Sheet1.RemoveRows(0, this.neuSpread1_Sheet1.RowCount);
}
Neusoft.HISFC.Models.Nurse.Inject info = null;
for (int i = 0; i < al.Count; i++)
{
info = (Neusoft.HISFC.Models.Nurse.Inject)al[i];
this.neuSpread1_Sheet1.Rows.Add(0, 1);
this.neuSpread1_Sheet1.Cells[0, 0].Text = info.Item.Order.Combo.ID;
if (info.Item.Item.Name != null && info.Item.Item.Name != "")
{
this.neuSpread1_Sheet1.Cells[0, 1].Text = info.Item.Item.Name;
}
else
{
this.neuSpread1_Sheet1.Cells[0, 1].Text = info.Item.Name;
}
this.neuSpread1_Sheet1.Cells[0, 1].Text = info.Item.Item.Name;
this.neuSpread1_Sheet1.Cells[0, 2].Text = info.Item.Order.Item.Specs;
this.neuSpread1_Sheet1.Cells[0, 3].Text = info.Item.Order.Frequency.ID;
this.neuSpread1_Sheet1.Cells[0, 4].Text = info.Item.Order.Usage.Name;//info.Item.DoseOnce.ToString() + info.Item.DoseUnit.ToString();
this.neuSpread1_Sheet1.Cells[0, 5].Text = " ";
this.neuSpread1_Sheet1.Cells[0, 6].Text = " ";
this.neuSpread1_Sheet1.Cells[0, 7].Text = " ";
}
info = (Neusoft.HISFC.Models.Nurse.Inject)al[0];
this.lbCard.Text = info.Patient.PID.CardNO;
this.lbName.Text = info.Patient.Name;
this.lbTime.Text = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
this.lbAge.Text = this.injectMgr.GetAge(info.Patient.Birthday, System.DateTime.Now);
if (info.Patient.Sex.ID.ToString() == "M")
{
this.lbSex.Text = "男";
}
else if (info.Patient.Sex.ID.ToString() == "F")
{
this.lbSex.Text = "女";
}
else
{
this.lbSex.Text = "";
}
this.neuSpread1_Sheet1.Rows.Add(this.neuSpread1_Sheet1.RowCount, 1);
this.neuSpread1_Sheet1.Cells[this.neuSpread1_Sheet1.RowCount - 1, 0].Text = "拔针";
#region 设置界面用来配合打印
System.Windows.Forms.Control c = this;
c.Width = this.Width;
c.Height = this.Height;
#endregion
//打印机
Neusoft.FrameWork.WinForms.Classes.Print p = new Neusoft.FrameWork.WinForms.Classes.Print();
//neusoft.Common.Class.Function.GetPageSize("Inject4", ref p);
p.PrintPage(40, 0, c);
}
private void Print(ArrayList al, int current, int total)
{
try
{
//有备注的集合
ArrayList alMemo = new ArrayList();
Neusoft.HISFC.BizProcess.Integrate.Order orderMgr = new Neusoft.HISFC.BizProcess.Integrate.Order();
//Neusoft.HISFC.BizLogic.Order.OutPatient.Order orderMgr
// = new Neusoft.HISFC.BizLogic.Order.OutPatient.Order();
if (this.neuSpread1_Sheet1.RowCount > 0)
{
this.neuSpread1_Sheet1.RemoveRows(0, this.neuSpread1_Sheet1.RowCount);
}
Neusoft.HISFC.Models.Nurse.Inject info = null;
//接瓶次数
int jpNum = 1;
//赋值并打印
for (int i = 0; i < al.Count; i++)
{
info = (Neusoft.HISFC.Models.Nurse.Inject)al[i];
Neusoft.HISFC.Models.Order.OutPatient.Order orderinfo =
new Neusoft.HISFC.Models.Order.OutPatient.Order();
orderinfo = orderMgr.GetOneOrder(info.Item.Order.ID);
if (orderinfo != null && orderinfo.Memo != null)
{
info.Item.Memo = orderinfo.Memo;
alMemo.Add(info);
}
this.neuSpread1_Sheet1.Rows.Add(0, 1);
if (info.Item.Order.Combo.ID.Length <= 2)
{
this.neuSpread1_Sheet1.Cells[0, 0].Text =
info.Item.Order.Combo.ID;
}
else
{
this.neuSpread1_Sheet1.Cells[0, 0].Text =
info.Item.Order.Combo.ID.Substring(info.Item.Order.Combo.ID.Length - 2, 2);
}
if (info.Item.Item.Name != null && info.Item.Item.Name != "")
{
this.neuSpread1_Sheet1.Cells[0, 1].Text = info.Item.Item.Name;
}
else
{
this.neuSpread1_Sheet1.Cells[0, 1].Text = info.Item.Name;
}
jpNum = Neusoft.FrameWork.Function.NConvert.ToInt32(info.Memo);
if (jpNum == 0)
{
jpNum = 1;
}
this.neuSpread1_Sheet1.Cells[0, 2].Text = info.Item.Order.DoseOnce.ToString() + info.Item.Order.DoseUnit.ToString();
//Math.Round(info.Item.DoseOnce/jpNum,3).ToString() + info.Item.DoseUnit.ToString();
this.neuSpread1_Sheet1.Cells[0, 3].Text = info.Item.Order.Frequency.ID;
this.neuSpread1_Sheet1.Cells[0, 4].Text = info.Item.InjectCount.ToString();
this.neuSpread1_Sheet1.Cells[0, 5].Text = info.Item.Order.Usage.Name;
this.neuSpread1_Sheet1.Cells[0, 6].Text = info.Item.Memo.ToString();
}
#region 医嘱备注添加打印
//if (alMemo.Count > 0)
//{
// for (int i = 0; i < alMemo.Count; i++)
// {
// Neusoft.HISFC.Models.Nurse.Inject temp = (Neusoft.HISFC.Models.Nurse.Inject)alMemo[i];
// // string strtemp = temp.Item.Name + ":" + temp.Item.Memo;
// string strtemp = "";
// if (temp.Item.Order.Combo.ID.Length <= 2)
// {
// strtemp = temp.Item.Order.Combo.ID.TrimStart('0') + "组:"
// + temp.Item.Memo;
// }
// else
// {
// strtemp = temp.Item.Order.Combo.ID.Substring(temp.Item.Order.Combo.ID.Length - 2, 2).TrimStart('0') + "组:"
// + temp.Item.Memo;
// }
// this.neuSpread1_Sheet1.AddRows(this.neuSpread1_Sheet1.RowCount, 1);
// this.neuSpread1_Sheet1.Cells[this.neuSpread1_Sheet1.RowCount - 1, 0].ColumnSpan = 5;
// this.neuSpread1_Sheet1.Cells[this.neuSpread1_Sheet1.RowCount - 1, 0].Text = strtemp;
// }
//}
#endregion
info = (Neusoft.HISFC.Models.Nurse.Inject)al[0];
this.lbCard.Text = info.Patient.PID.CardNO;
this.lbName.Text = info.Patient.Name;
this.lbTime.Text = "打印时间:" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
//this.lbAge.Text = this.injectMgr.GetAge(info.Patient.Birthday, System.DateTime.Now);
this.lbAge.Text = Neusoft.HISFC.BizProcess.Integrate.Function.GetAge(info.Patient.Birthday);
if (info.Patient.Sex.ID.ToString() == "M")
{
this.lbSex.Text = "男";
}
else if (info.Patient.Sex.ID.ToString() == "F")
{
this.lbSex.Text = "女";
}
else
{
this.lbSex.Text = "";
}
this.lbPage.Text = "第" + current.ToString()
+ "页" + "/" + "共" + total.ToString() + "页";
this.Print();
}
catch { }
}
/// <summary>
/// 取消登记//1.必须是当事人取消 2.已经配药，注射的不能取消登记 3.只取消打对勾的
/// </summary>
private void Save()
{
if (this.neuSpread1_Sheet1.RowCount <= 0)
{
MessageBox.Show("没有需要保存的数据!");
return;
}
int selectNum = 0;
for (int i = 0; i < this.neuSpread1_Sheet1.RowCount; i++)
{
if (this.neuSpread1_Sheet1.GetValue(i, 0).ToString().ToUpper() == "FALSE" || this.neuSpread1_Sheet1.GetValue(i, 0).ToString() == "")
{
selectNum++;
}
}
if (selectNum >= this.neuSpread1_Sheet1.RowCount)
{
MessageBox.Show("请选择数据", "提示");
return;
}
if (MessageBox.Show("您是否要删除所选择的登记信息？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
this.neuSpread1.StopCellEditing();
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
//Neusoft.FrameWork.Management.Transaction SQLCA = new Neusoft.FrameWork.Management.Transaction(Neusoft.FrameWork.Management.Connection.Instance);
//SQLCA.BeginTransaction();
this.injMgr.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
this.patientMgr.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
try
{
for (int i = 0; i < this.neuSpread1_Sheet1.RowCount; i++)
{
Neusoft.HISFC.Models.Nurse.Inject info =
(Neusoft.HISFC.Models.Nurse.Inject) this.neuSpread1_Sheet1.Rows[i].Tag;
#region 效条件判断
if (this.neuSpread1_Sheet1.GetValue(i, 0).ToString().ToUpper() == "FALSE")
{
continue;
}
if (info.MixOperInfo.ID != null && info.MixOperInfo.ID != "")
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show("第" + (i + 1).ToString() + "行数据已经配药确认，不能取消登记!");
return;
}
if (info.InjectOperInfo.ID != null && info.InjectOperInfo.ID != "")
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show("第" + (i + 1).ToString() + "行数据已经注射确认，不能取消登记!");
return;
}
if (info.Booker.ID != Neusoft.FrameWork.Management.Connection.Operator.ID)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
Neusoft.HISFC.BizProcess.Integrate.Manager PsMgr = new Neusoft.HISFC.BizProcess.Integrate.Manager();
Neusoft.HISFC.Models.Base.Employee ps = PsMgr.GetEmployeeInfo(info.Booker.ID);
MessageBox.Show("您不是第" + (i + 1).ToString() + "行记录的登记人，不能取消登记!",
"只有[" + ps.Name + "]才能取消这条记录!");
return;
}
#endregion
//1.删除met_nuo_inject记录
if (this.injMgr.Delete(info.ID) == -1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show(this.patientMgr.Err, "提示");
return;
}
//2.fin_ipb_feeitemlist中，减少数量------------没有考虑并发的问题,以后再说吧----表中没有moorder,郁闷!
if (this.patientMgr.UpdateConfirmInject("ALL", info.Item.RecipeNO, info.Item.SequenceNO.ToString(), -1) == -1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show(this.patientMgr.Err, "提示");
return;
}
}
Neusoft.FrameWork.Management.PublicTrans.Commit();
for (int i = this.neuSpread1_Sheet1.RowCount - 1; i >= 0; i--)
{
if (this.neuSpread1_Sheet1.GetValue(i, 0).ToString().ToUpper() == "TRUE")
{
this.neuSpread1_Sheet1.Rows[i].Remove();
}
}
MessageBox.Show("取消登记成功!", "提示");
}
catch (Exception e)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show(e.Message);
return;
}
}
}
/// <summary>
///
/// </summary>
/// <param name="al"></param>
public void Init(ArrayList tmp)
{
try
{
//ArrayList sortList = new ArrayList();
//while (al.Count > 0)
//{
// Neusoft.HISFC.Models.Nurse.Inject temp = al[0] as Neusoft.HISFC.Models.Nurse.Inject;
// ArrayList sameList = new ArrayList();
// foreach (Neusoft.HISFC.Models.Nurse.Inject obj in al)
// {
// if (obj.InjectOrder == null || obj.InjectOrder == "")//.Item.CombNo
// {
// sameList.Add(obj);
// break;
// }
// if (obj.InjectOrder == temp.InjectOrder)
// {
// sameList.Add(obj);
// }
// }
// sortList.Add(sameList);
// foreach (Neusoft.HISFC.Models.Nurse.Inject obj in sameList)
// {
// al.Remove(obj);
// }
//}
//foreach (ArrayList tmp in sortList)
//{
if (this.neuSpread1_Sheet1.RowCount > 0)
{
this.neuSpread1_Sheet1.RemoveRows(0, this.neuSpread1_Sheet1.RowCount);
}
Neusoft.HISFC.Models.Nurse.Inject info = null;
//接瓶次数
int jpNum = 1;
//赋值并打印
for (int i = 0; i < tmp.Count; i++)
{
info = (Neusoft.HISFC.Models.Nurse.Inject)tmp[i];
this.neuSpread1_Sheet1.Rows.Add(0, 1);
jpNum = Neusoft.FrameWork.Function.NConvert.ToInt32(info.Memo);
if (jpNum == 0)
{
jpNum = 1;
}
if (info.Item.Item.Name != null && info.Item.Item.Name != "")
{
this.neuSpread1_Sheet1.Cells[0, 0].Text = info.Item.Item.Name;
}
else
{
this.neuSpread1_Sheet1.Cells[0, 0].Text = info.Item.Name;
}
this.neuSpread1_Sheet1.Cells[0, 1].Text = "[" +
Math.Round(info.Item.Order.DoseOnce / jpNum, 3).ToString() + info.Item.Order.DoseUnit + "]";
this.neuSpread1_Sheet1.Cells[0, 2].Text = info.Item.Order.Frequency.ID;
}
info = (Neusoft.HISFC.Models.Nurse.Inject)tmp[0];
this.lbName.Text = info.Patient.Name;
this.lbNumber.Text = "注射顺序" + info.InjectOrder;
this.lbCard.Text = info.Patient.PID.CardNO;
this.lbTime.Text = System.DateTime.Now.ToString();
this.lbOrder.Text = info.OrderNO;
this.lbAge.Text = this.injectMgr.GetAge(info.Patient.Birthday, System.DateTime.Now);
if (info.Patient.Sex.ID.ToString() == "M")
{
this.lbSex.Text = "男";
}
else if (info.Patient.Sex.ID.ToString() == "F")
{
this.lbSex.Text = "女";
}
else
{
this.lbSex.Text = "";
}
this.neuSpread1_Sheet1.Rows.Add(this.neuSpread1_Sheet1.RowCount, 3);
//this.Print();
}
//}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
/// <summary>
///
/// </summary>
/// <param name="al"></param>
public void Init(ArrayList al)
{
try
{
#region 分组
ArrayList sortList = new ArrayList();
while (al.Count > 0)
{
Neusoft.HISFC.Models.Nurse.Inject temp = al[0] as Neusoft.HISFC.Models.Nurse.Inject;
ArrayList sameList = new ArrayList();
foreach (Neusoft.HISFC.Models.Nurse.Inject obj in al)
{
if (obj.InjectOrder == null || obj.InjectOrder == "")//.Item.CombNo
{
sameList.Add(obj);
break;
}
if (obj.InjectOrder == temp.InjectOrder)
{
sameList.Add(obj);
}
}
sortList.Add(sameList);
foreach (Neusoft.HISFC.Models.Nurse.Inject obj in sameList)
{
al.Remove(obj);
}
}
#endregion
#region 改成加载uc了
bool newPage = true;
Point p = new Point();
int rowIdx = 0;
int colIdx = 0;
ucPrintCureBase pcb = null;
for (int i = 0; i < sortList.Count; i++)
{
if ((i % 12) == 0)
{
newPage = true;
}
else
{
newPage = false;
}
if (newPage == true)
{
this.pnlPrint.Controls.Clear();
}
colIdx = ((i % 12) / 4);
rowIdx = ((i % 12) % 4);
pcb = new ucPrintCureBase();
//算坐标
p.X = colIdx * pcb.Width;
p.Y = rowIdx * pcb.Height;
pcb.Init(sortList[i] as ArrayList);
this.pnlPrint.Controls.Add(pcb);
pcb.Location = p;
if ((i % 12) == 11)
{
this.Print();
}
}
if (((sortList.Count - 1) % 12) != 11)
{
this.Print();
}
this.Width = pcb.Width * 3;
this.Height = pcb.Height * 4;
// foreach (ArrayList tmp in sortList)
//{
//if (this.neuSpread1_Sheet1.RowCount > 0)
//{
// this.neuSpread1_Sheet1.RemoveRows(0, this.neuSpread1_Sheet1.RowCount);
//}
//Neusoft.HISFC.Models.Nurse.Inject info = null;
////接瓶次数
//int jpNum = 1;
////赋值并打印
//for (int i = 0; i < tmp.Count; i++)
//{
// info = (Neusoft.HISFC.Models.Nurse.Inject)tmp[i];
// this.neuSpread1_Sheet1.Rows.Add(0, 1);
// jpNum = Neusoft.FrameWork.Function.NConvert.ToInt32(info.Memo);
// if (jpNum == 0)
// {
// jpNum = 1;
// }
// if (info.Item.Item.Name != null && info.Item.Item.Name != "")
// {
// this.neuSpread1_Sheet1.Cells[0, 0].Text = info.Item.Item.Name + "[" +
// Math.Round(info.Item.Order.DoseOnce / jpNum, 3).ToString() + info.Item.Order.DoseUnit + "]";
// }
// else
// {
// this.neuSpread1_Sheet1.Cells[0, 0].Text = info.Item.Name + "[" +
// Math.Round(info.Item.Order.DoseOnce / jpNum, 3).ToString() + info.Item.Order.DoseUnit + "]";
// }
//}
//info = (Neusoft.HISFC.Models.Nurse.Inject)tmp[0];
//this.lbName.Text = info.Patient.Name;
//this.lbNumber.Text = "注射顺序" + info.InjectOrder;
//this.lbCard.Text = info.Patient.PID.CardNO;
//this.lbTime.Text = System.DateTime.Now.ToString();
//this.lbOrder.Text = info.OrderNO;
//this.lbAge.Text = this.injectMgr.GetAge(info.Patient.Birthday, System.DateTime.Now);
//if (info.Patient.Sex.ID.ToString() == "M")
//{
// this.lbSex.Text = "男";
//}
//else if (info.Patient.Sex.ID.ToString() == "F")
//{
// this.lbSex.Text = "女";
//}
//else
//{
// this.lbSex.Text = "";
//}
//this.neuSpread1_Sheet1.Rows.Add(this.neuSpread1_Sheet1.RowCount, 3);
//this.Print();
//}
#endregion
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
