protected override void OnLoad()
{
Neusoft.HISFC.BizProcess.Integrate.Manager doctMgr = new Neusoft.HISFC.BizProcess.Integrate.Manager();
ArrayList al = new ArrayList();
//医生
al = doctMgr.QueryEmployee(Neusoft.HISFC.Models.Base.EnumEmployeeType.D);
Neusoft.HISFC.Models.Base.Employee top = new Neusoft.HISFC.Models.Base.Employee();
top.ID = "ALL";
top.Name = "全 部";
top.SpellCode = "QB";
top.WBCode = "WU";
this.cmbDoc.Items.Add(top);
foreach (Neusoft.HISFC.Models.Base.Employee con in al)
{
cmbDoc.Items.Add(con);
}
this.cmbDoc.alItems.Add(top);
this.cmbDoc.alItems.AddRange(al);
if (cmbDoc.Items.Count > 0)
{
cmbDoc.SelectedIndex = 0;
doctCode = ((Neusoft.HISFC.Models.Base.Employee)cmbDoc.Items[0]).ID;
}
base.OnLoad();
}
/// <summary>
/// 添加一条资质
/// </summary>
private void NewAbility()
{
if (tv.SelectedNode.ToolTipText == "人员")
{
Neusoft.HISFC.Models.Base.Employee empls = new Neusoft.HISFC.Models.Base.Employee();
empls = tv.SelectedNode.Tag as Neusoft.HISFC.Models.Base.Employee;
this.tbEmplCode.Text = empls.ID;
this.tbEmplName.Text = empls.Name;
this.tbBirthday.Text = empls.Birthday.Year.ToString();
this.tbDept.Text = ehDept.GetName(empls.Dept.ID);
this.tbEducation.Text = ehEdu.GetName(empls.GraduateSchool.ID);
this.tbPost.Text = ehLevel.GetName(empls.Level.ID);
this.tbSex.Text = empls.Sex.Name;
this.tbRemark.Text = "";
this.tbAbilityCardNO.Text = "";
this.tbVocationArea.Text = "";
this.tbVocationCardNO.Text = "";
this.cbVocationType.SelectedIndex = -1;
this.cbSpeciality.SelectedIndex = -1;
this.happenNO = "-1";
}
else
{
MessageBox.Show("选择的不是人员节点，不能添加资质信息！");
}
}
protected override void OnLoad()
{
this.isAcross = true;
this.isSort = false;
this.Init();
base.OnLoad();
//填充数据
Neusoft.HISFC.BizProcess.Integrate.Manager doctMgr = new Neusoft.HISFC.BizProcess.Integrate.Manager();
System.Collections.ArrayList al = doctMgr.QueryRegDepartment();
al = doctMgr.QueryEmployee(Neusoft.HISFC.Models.Base.EnumEmployeeType.D);
//this.cmbDoct.AddItems(al);
Neusoft.HISFC.Models.Base.Employee top = new Neusoft.HISFC.Models.Base.Employee();
top.ID = "0";
top.Name = "全 部";
top.SpellCode = "QB";
top.WBCode = "WU";
this.neuComboBox1.Items.Add(top);
foreach (Neusoft.HISFC.Models.Base.Employee con in al)
{
neuComboBox1.Items.Add(con);
}
this.neuComboBox1.alItems.Add(top);
this.neuComboBox1.alItems.AddRange(al);
if (neuComboBox1.Items.Count > 0)
{
neuComboBox1.SelectedIndex = 0;
doctCode = ((Neusoft.HISFC.Models.Base.Employee)neuComboBox1.Items[0]).ID;
doctName = ((Neusoft.HISFC.Models.Base.Employee)neuComboBox1.Items[0]).Name;
}
}
public frmSetUserGroup(Neusoft.HISFC.Models.Base.Employee obj)
{
InitializeComponent();
this.employee = obj.Clone();
this.getPerson();
if (obj.ID == "")
{
this.UpdateOrAdd = "A";
this.lblEmployee.Visible = true;
}
else
{
this.UpdateOrAdd = "U";
this.lblEmployee.Visible = false;
}
this.employee = obj;
try
{
Neusoft.HISFC.BizLogic.Manager.Person managerPerson = new Neusoft.HISFC.BizLogic.Manager.Person();
form = new Neusoft.FrameWork.WinForms.Forms.frmEasyChoose(managerPerson.GetUserEmployeeAll());
form.SelectedItem += new Neusoft.FrameWork.WinForms.Forms.SelectedItemHandler(form_SelectedItem);
this.tvGroup1.DoubleClick += new EventHandler(this.treeView_DoubleClick);
this.lsvGroup.DoubleClick += new EventHandler(listView1_DoubleClick);
this.RefreshGroupList();
this.tvGroup1.Visible = true;
}
catch { }
}
/// <summary>
/// 获取留观患者信息
/// </summary>
/// <returns></returns>
private int LoadPatient()
{
if (this.tvPatient.Nodes.Count > 0)
{
tvPatient.Nodes.Clear();
}
TreeNode root = new TreeNode("留观患者");
root.ImageIndex = 0;
Neusoft.HISFC.Models.Base.Employee employee = Neusoft.FrameWork.Management.Connection.Operator as Neusoft.HISFC.Models.Base.Employee;
ArrayList al = registerIntegrate.PatientQueryByNurseCell(employee.Dept.ID, Neusoft.HISFC.Models.Base.EnumInState.I.ToString());
if (al == null)
{
MessageBox.Show("查询留观患者信息失败！" + registerIntegrate.Err);
return(-1);
}
foreach (Neusoft.HISFC.Models.Registration.Register r in al)
{
TreeNode node = new TreeNode(r.Name);
node.ImageIndex = 6;
node.SelectedImageIndex = 7;
node.Tag = r;
root.Nodes.Add(node);
}
this.tvPatient.Nodes.Add(root);
this.tvPatient.ExpandAll();
return(1);
}
protected override int OnRetrieve(params object[] objects)
{
if (textBox1.Text == null && textBox1.Text == "")
{
MessageBox.Show("请输入比较天数！");
this.textBox1.Focus();
return(-1);
}
int num = 0;
if (!int.TryParse(textBox1.Text, out num))
{
MessageBox.Show("只能输入数字");
this.textBox1.Focus();
return(-1);
}
if (Convert.ToInt32(textBox1.Text) > 999999)
{
MessageBox.Show("比较天数不能超过最大值999999天，请重新输入");
this.textBox1.Focus();
return(-1);
}
this.employee = (Neusoft.HISFC.Models.Base.Employee) this.dataBaseManager.Operator;
return(base.OnRetrieve(System.DateTime.Now, Convert.ToInt32(textBox1.Text), employee.Dept.ID));
}
/// <summary>
/// 急诊 感染 手术信息一览表
/// </summary>
/// <param name="Begin"></param>
/// <param name="End"></param>
/// <returns></returns>
public DataSet GetEmergencyOperation(string Begin, string End)
{
//手术信息一览表
System.Data.DataSet ds = new DataSet();
try
{
string strSql = string.Empty;
Neusoft.HISFC.Models.Base.Employee ee = (Neusoft.HISFC.Models.Base.Employee) this.Operator;
if (this.Sql.GetSql("Operator.OpsReport.GetEmergencyOperation", ref strSql) == -1)
{
this.Err = this.Sql.Err;
return(null);
}
else
{
strSql = string.Format(strSql, Begin, End, ee.Dept.ID);
}
this.ExecQuery(strSql, ref ds);
}
catch (Exception ee)
{
this.Err = ee.Message;
return(null);
}
return(ds);
}
/// <summary>
/// 刷新患者列表
/// </summary>
private void RefreshPatient()
{
try
{
TreeNode select = this.neuTreeView1.SelectedNode;
if (select == null)
{
return;
}
//没有选中
if (select.Tag == null)
{
return;
}
//未看诊患者
if (select.Tag.ToString() == "1")
{
this.QueryWait("ALL");
}
//已看诊患者
else if (select.Tag.ToString() == "2")
{
this.QueryAlready("ALL");
}
else if (select.Tag.GetType() == typeof(Neusoft.HISFC.Models.Base.Employee))
{
Neusoft.HISFC.Models.Base.Employee ps = (Neusoft.HISFC.Models.Base.Employee)select.Tag;
this.QueryAlready(ps.ID);
}
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
private void QueryOutPut()
{
try
{
Neusoft.FrameWork.WinForms.Classes.Function.ShowWaitForm(Language.Msg("正在查询，请稍候..."));
Application.DoEvents();
DataSet ds = new DataSet();
emp = (Neusoft.HISFC.Models.Base.Employee)dept.Operator;
//{3868F08C-D224-443b-94FB-FE4A493742B6} 出库查询中查询出所有出库数据
//if (this.itemManager.ExecQuery("Neusoft.Pha.Dispense", ref ds, this.dtpFrom.Value.ToString(), this.dtpTo.Value.ToString(), this.emp.Dept.ID, this.cbPhaName.SelectedItem.ID) == -1)
if (this.itemManager.ExecQuery("Neusoft.Pha.DispenseNew", ref ds, this.dtpFrom.Value.ToString(), this.dtpTo.Value.ToString(), this.emp.Dept.ID, this.cbPhaName.SelectedItem.ID) == -1)
{
MessageBox.Show(Language.Msg("数据查询失败，请与管理员联系！" + this.itemManager.Err));
return;
}
this.nfpStat.DataSource = ds;
this.nfpStat_Sheet1.SheetName = emp.Dept.Name + "出库信息明细";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm();
}
}
/// <summary>
/// 按时间段查询
/// </summary>
/// <returns></returns>
private int InitCalendarData(DateTime dtBegin, DateTime dtEnd)
{
ArrayList calendarLis =
Neusoft.HISFC.BizProcess.Factory.Function.IntegrateEPR.QueryCalendar(dtBegin, dtEnd);
if (calendarLis == null)
{
return(0);
}
if (this.neuSpread1_Sheet1.Rows.Count > 0)
{
this.neuSpread1_Sheet1.Rows.Remove(0, this.neuSpread1_Sheet1.Rows.Count);
}
foreach (Neusoft.HISFC.Models.Base.Calendar calendar in calendarLis)
{
this.neuSpread1_Sheet1.Rows.Add(this.neuSpread1_Sheet1.RowCount, 1);
int row = this.neuSpread1_Sheet1.RowCount - 1;
this.neuSpread1_Sheet1.SetValue(row, 0, calendar.CalendarDate);
this.neuSpread1_Sheet1.SetValue(row, 1, calendar.Name);
this.neuSpread1_Sheet1.SetValue(row, 2, calendar.Type);
Neusoft.HISFC.Models.Base.Employee oper = managerManager.GetPersonByID(calendar.Oper.ID);
this.neuSpread1_Sheet1.SetValue(row, 3, oper.Name);
this.neuSpread1_Sheet1.SetValue(row, 4, calendar.Oper.OperTime);
}
return(1);
}
/// <summary>
/// 获取界面信息，转化为实体
/// </summary>
public void GetRoom()
{
if (this.RoomInfo == null)
{
this.RoomInfo = new Neusoft.HISFC.Models.Nurse.Room();
}
//诊室代码
if (this.tbRoom.Tag != null)
{
this.RoomInfo.ID = this.tbRoom.Tag.ToString();
}
//诊室名称
this.RoomInfo.Name = this.tbRoom.Text;
//助记码
this.RoomInfo.InputCode = this.tbInput.Text.Trim().ToString();
//显示顺序
this.RoomInfo.Sort = Neusoft.FrameWork.Function.NConvert.ToInt32(this.tbSort.Text);
//是否有效
this.RoomInfo.IsValid = this.cmbValid.SelectedIndex.ToString();
// //备注
// this.RoomInfo.Memo = this.txtMemo.Text;
//操作员
this.RoomInfo.User01 = this.roomMgr.Operator.ID;
//护理站代码
if (this.roomInfo.Nurse.ID == null || this.roomInfo.Nurse.ID == "")
{
p = ps.GetEmployeeInfo(this.roomMgr.Operator.ID);
this.roomInfo.Nurse.ID = p.Nurse.ID.ToString();
}
}
/// <summary>
/// 队列
/// </summary>
private void timer2_Tick(object sender, EventArgs e)
{
//获取当前控件数量
ps = psMgr.GetEmployeeInfo(this.queMgr.Operator.ID);
DateTime currenttime = this.queMgr.GetDateTimeFromSysDateTime();
DateTime current = currenttime.Date;
string noonID = Nurse.Function.GetNoon(currenttime);//午别
this.alQueue = queMgr.Query(ps.Nurse.ID, current, noonID);
int intTmp = this.alQueue.Count;
if (intTmp <= 0)
{
this.Controls.Clear();
//设置出现以外情况的处理(没有维护队列)-------------------------------------??????????
}
//控件数量跟原来相比较
if (intTmp != queueNum && intTmp > 0)
{
if (queueNum > 0)
{
this.Controls.Clear();
}
//赋值一个新的控件/队列数量
this.queueNum = intTmp;
}
}
/// <summary>
/// 初始化表格
/// </summary>
/// <param name="arrayList"></param>
private void InitSheet(ArrayList arrayList)
{
this.SetSheetFormat();
Neusoft.HISFC.BizProcess.Integrate.Manager manager = new Neusoft.HISFC.BizProcess.Integrate.Manager();
Neusoft.HISFC.Models.Base.Employee emp = new Neusoft.HISFC.Models.Base.Employee();
Neusoft.HISFC.Models.Base.Department dept = new Neusoft.HISFC.Models.Base.Department();
if (arrayList != null && arrayList.Count > 0)
{
foreach (ArrayList al in arrayList)
{
this.neuSpread1_Sheet1.AddRows(this.neuSpread1_Sheet1.RowCount, 1);
this.neuSpread1_Sheet1.Cells[this.neuSpread1_Sheet1.RowCount - 1, 1].Text = al[1].ToString();//申请单号
emp = manager.GetEmployeeInfo(al[2].ToString());
if (emp != null && !string.IsNullOrEmpty(emp.ID))
{
this.neuSpread1_Sheet1.Cells[this.neuSpread1_Sheet1.RowCount - 1, 2].Text = emp.Name;
}
dept = manager.GetDepartment(al[3].ToString());
if (dept != null && !string.IsNullOrEmpty(dept.ID))
{
this.neuSpread1_Sheet1.Cells[this.neuSpread1_Sheet1.RowCount - 1, 3].Text = dept.Name;
}
this.neuSpread1_Sheet1.Cells[this.neuSpread1_Sheet1.RowCount - 1, 4].Text = al[4].ToString();
this.neuSpread1_Sheet1.Cells[this.neuSpread1_Sheet1.RowCount - 1, 5].Text = al[5].ToString();
this.neuSpread1_Sheet1.Cells[this.neuSpread1_Sheet1.RowCount - 1, 6].Text = al[6].ToString();
//主键
this.neuSpread1_Sheet1.Rows[this.neuSpread1_Sheet1.RowCount - 1].Tag = al;
}
this.neuSpread1_Sheet1.Columns[1, this.neuSpread1_Sheet1.ColumnCount - 1].Locked = true;
}
}
private void neuSpread1_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
try
{
Neusoft.HISFC.Models.Base.Employee person = (Neusoft.HISFC.Models.Base.Employee) this.neuSpread1.ActiveSheet.ActiveRow.Tag;
Neusoft.FrameWork.Management.Connection.Operator = person;
if (person.PermissionGroup == null || person.PermissionGroup.Count == 0)
{
}
else if (person.PermissionGroup.Count == 1)
{
person.CurrentGroup = (Neusoft.FrameWork.Models.NeuObject)person.PermissionGroup[0];
frmSelectGroup f = new frmSelectGroup();
f.ShowDialog();
}
else
{
frmSelectGroup f = new frmSelectGroup();
f.ShowDialog();
}
if (Program.mainForm == null)
{
Program.mainForm = new frmMain();
}
foreach (Form f in Program.mainForm.MdiChildren)
{
f.Close();
}
Program.mainForm.Show();
}
catch
{ }
}
/// <summary>
/// 初始化
/// </summary>
/// <returns>成功 1 失败 -1</returns>
protected virtual int Init()
{
Neusoft.FrameWork.WinForms.Classes.Function.ShowWaitForm("正在加载项目信息,请等待...");
Application.DoEvents();
//初始化医生信息
if (InitDoctors() == -1)
{
Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm();
return(-1);
}
//{7376038F-EFE8-46c8-BA63-3147C6EF67F0}
//初始化科室信息
if (InitDept() == -1)
{
Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm();
return(-1);
}
Neusoft.HISFC.Models.Base.Employee emplTemp = Neusoft.FrameWork.Management.Connection.Operator as Neusoft.HISFC.Models.Base.Employee;
//初始化项目批费控件
if (this.ucInpatientCharge_new1.Init(emplTemp.Dept.ID) == -1)
{
Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm();
return(-1);
}
this.ucInpatientCharge_new1.MessageType = this.MessageType;
Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm();
return(1);
}
private void QueryDetail()
{
try
{
Neusoft.FrameWork.WinForms.Classes.Function.ShowWaitForm(Language.Msg("正在查询，请稍候..."));
Application.DoEvents();
string deptCode;
DataSet ds = new DataSet();
emp = (Neusoft.HISFC.Models.Base.Employee)dept.Operator;
deptCode = this.nfpStat_Sheet1.Cells[this.nfpStat_Sheet1.ActiveRowIndex, 6].Text.ToString(); //this.nfpStat_Sheet1.Cells[this.nfpStat_Sheet1.ActiveRowIndex, this.nfpStat_Sheet1.Columns["科室编码"].Index].Text;
string phaname = this.nfpStat_Sheet1.Cells[this.nfpStat_Sheet1.ActiveRowIndex, 0].Text.ToString();
if (this.itemManager.ExecQuery("Neusoft.Pha.DispensePerPatient", ref ds, this.dtpFrom.Value.ToString(), this.dtpTo.Value.ToString(), this.emp.Dept.ID, phaname, deptCode) == -1)
{
MessageBox.Show(Language.Msg("数据查询失败，请与管理员联系！" + this.itemManager.Err));
return;
}
this.nfpDetail.DataSource = ds;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm();
}
}
protected virtual void Init()
{
person = Neusoft.FrameWork.Management.Connection.Operator as Neusoft.HISFC.Models.Base.Employee;
if (person == null)
{
return;
}
curGroup = new Neusoft.HISFC.Models.Admin.SysGroup();
if (person.IsManager)
{
curGroup.ID = "ROOT";
curGroup.Name = "系统组";
curGroup.ParentGroup.ID = "ROOT";
curGroup.ParentGroup.Name = "ROOT";
}
else
{
curGroup.ID = person.CurrentGroup.ID;
curGroup.Name = person.CurrentGroup.Name;
}
this.HideSelection = false;
TreeNode node = new TreeNode(curGroup.Name);
node.ImageIndex = 2;
node.SelectedImageIndex = 3;
node.Tag = curGroup;
this.Nodes.Add(node);
}
public ArrayList GetAllPeronList()
{
ArrayList al = new ArrayList();
try
{
string sql = "";
//接口说明 0 id ,1 name
if (this.Sql.GetSql("Manager.UserManager.GetAllPersonList", ref sql) == -1)
{
return(null);
}
if (this.ExecQuery(sql) == -1)
{
return(null);
}
while (this.Reader.Read())
{
Neusoft.HISFC.Models.Base.Employee obj = new Neusoft.HISFC.Models.Base.Employee();
obj.ID = this.Reader[0].ToString(); //id
obj.Name = this.Reader[1].ToString(); //name
al.Add(obj);
}
this.Reader.Close();
}
catch (Exception ee)
{
this.Err = ee.Message;
al = null;
}
return(al);
}
/// <summary>
/// 初始化
/// </summary>
private void init()
{
var = (Neusoft.HISFC.Models.Base.Employee)dataManager.Operator;
initDept();
this.initDataSet();
this.initType();
}
/// <summary>
/// 删除组
/// </summary>
/// <param name="Person"></param>
/// <param name="Group"></param>
/// <returns></returns>
public int DeletePersonGroup(Neusoft.HISFC.Models.Base.Employee Person, Neusoft.FrameWork.Models.NeuObject Group)
{
string strSql = "";
if (this.Sql.GetSql("Manager.UserManager.PersonGroup.Delete.1", ref strSql) == -1)
{
return(-1);
}
try
{
string[] s = new string[8];
s[0] = Group.ID;
s[1] = Group.Name;
s[2] = Person.ID;
s[3] = Person.Name;
s[4] = Person.Password;
s[5] = Person.User01;
s[6] = Neusoft.FrameWork.Function.NConvert.ToInt32(Person.IsManager).ToString();
s[7] = this.Operator.ID;
strSql = string.Format(strSql, s);
}
catch (Exception ex)
{
this.Err = "赋值时候出错！" + ex.Message;
this.WriteErr();
return(-1);
}
if (this.ExecNoQuery(strSql) <= 0) //insert
{
return(-1);
}
return(0);
}
public ArrayList GetReport06(DateTime BeginTime, DateTime EndTime)
{
ArrayList al = new ArrayList();
ArrayList alDataRow = new ArrayList();
string strDeptName = string.Empty;
string strDegree = string.Empty;
string strCount = string.Empty;
Neusoft.HISFC.Models.Base.Employee employee = new Neusoft.HISFC.Models.Base.Employee();
employee.ID = this.Operator.ID;
string strSql = string.Empty;
if (this.Sql.GetSql("Operator.OpsReport.GetReport06", ref strSql) == -1)
{
return(null);
}
try
{
strSql = string.Format(strSql, BeginTime.ToString(), EndTime.ToString(), employee.Dept.ID);
}
catch (Exception ex)
{
this.Err = "Operator.OpsReport.GetReport06";
this.ErrCode = ex.Message;
this.WriteErr();
return(null);
}
if (strSql == null)
{
return(null);
}
this.ExecQuery(strSql);
try
{
while (this.Reader.Read())
{
alDataRow.Clear();
strDeptName = Reader[0].ToString(); //手术医生所在科室
strDegree = Reader[1].ToString(); //手术规模
strCount = Reader[2].ToString(); //例数
//将当前行数据加载
alDataRow.Add(strDeptName);
alDataRow.Add(strDegree);
alDataRow.Add(strCount);
al.Add(alDataRow.Clone());
}
}
catch (Exception ex)
{
this.Err = "Operator.OpsReport.GetReport06";
this.ErrCode = ex.Message;
this.WriteErr();
return(null);
}
this.Reader.Close();
return(al);
}
protected override void OnLoad()
{
this.Init();
base.OnLoad();
//设置时间范围
DateTime now = DateTime.Now;
DateTime dt = new DateTime(DateTime.Now.Year, 1, 1);
this.dtpBeginTime.Value = dt;
//填充数据
Neusoft.HISFC.BizProcess.Integrate.Manager manager = new Neusoft.HISFC.BizProcess.Integrate.Manager();
constantList = manager.QueryEmployeeAll();
Neusoft.HISFC.Models.Base.Employee allPerson = new Neusoft.HISFC.Models.Base.Employee();
allPerson.ID = "%%";
allPerson.Name = "全部";
allPerson.SpellCode = "QB";
//cboPersonCode.Items.Insert(0, allPerson);
constantList.Insert(0, allPerson);
this.cboPersonCode.AddItems(constantList);
cboPersonCode.SelectedIndex = 0;
}
private void form_SelectedItem(Neusoft.FrameWork.Models.NeuObject sender)
{
try
{
Neusoft.HISFC.Models.Base.Employee p = sender as Neusoft.HISFC.Models.Base.Employee;
if (p != null)
{
this.employee = p;
Neusoft.HISFC.BizLogic.Manager.Spell sm = new Neusoft.HISFC.BizLogic.Manager.Spell();
if (this.txtLoginID.Text == "")
{
if (p.ID != "")
{
this.txtLoginID.Text = p.ID;
}
else
{
this.txtLoginID.Text = sm.Get(p.Name).SpellCode;
}
}
this.txtName.Text = p.Name;
this.employee.User01 = this.txtLoginID.Text;
}
}
catch { }
}
/// <summary>
/// 把数据存入实体中
/// </summary>
/// <returns></returns>
private Neusoft.HISFC.Models.Base.Message GetMessage()
{
Neusoft.HISFC.Models.Base.Message message = new Neusoft.HISFC.Models.Base.Message();
message.Receiver.Name = this.ComboBox1.Text;
message.Receiver.ID = this.ComboBox1.Tag.ToString();
Neusoft.HISFC.Models.Base.Employee receiver = managerManager.GetPersonByID(message.Receiver.ID);
message.ReceiverDept.ID = receiver.Dept.ID;
message.ReceiverDept.Name = receiver.Dept.Name;
message.Name = this.textBox1.Text.Trim();
message.Text = this.richTextBox1.Text.Trim();
message.Oper.OperTime = System.DateTime.Now;
message.Oper.Name = Neusoft.FrameWork.Management.Connection.Operator.Name;
message.Oper.ID = Neusoft.FrameWork.Management.Connection.Operator.ID;
Neusoft.HISFC.Models.Base.Employee oper = managerManager.GetPersonByID(message.Oper.ID);
message.SenderDept.ID = oper.Dept.ID;
message.SenderDept.Name = oper.Dept.Name;
message.ReplyType = -1;
return(message);
}
/// <summary>
/// 药品调剂查询的SQL
/// </summary>
// string sqlDrugTJ = @"SELECT (SELECT bb.dept_name FROM com_department bb WHERE bb.dept_code = aa.DRUG_STORAGE_CODE) AS dept,
// (SELECT cc.name FROM com_dictionary cc where cc.type = 'ITEMTYPE' AND cc.code = aa.Drug_Type) AS DRUGTYPE,
// SUM(aa.retail_price * aa.out_num/aa.pack_qty) AS retail_cost,
// SUM(aa.wholesale_price * aa.out_num/aa.pack_qty) AS wholesale_cost,
// (SUM(aa.retail_price * aa.out_num/aa.pack_qty) - SUM(aa.wholesale_price * aa.out_num/aa.pack_qty)) ce_cost
// FROM pha_com_output aa
// WHERE aa.Out_Type = '{2}'
// AND aa.drug_dept_code ='{3}'
// AND aa.oper_date BETWEEN to_date('{0}','yyyy-mm-dd hh24:mi:ss') AND to_date('{1}','yyyy-mm-dd hh24:mi:ss')
// AND aa.out_state = '2'
// GROUP BY aa.DRUG_STORAGE_CODE,aa.Drug_Type";
#endregion
#region 查询
protected override int OnQuery(object sender, object neuObject)
{
//List<string> alType = new List<string>();
//alType.Add("Z1");
//alType.Add("Z2");
//string[] inpatient = alType.ToArray();
Neusoft.HISFC.Models.Base.Employee employee = new Neusoft.HISFC.Models.Base.Employee();
employee = (Neusoft.HISFC.Models.Base.Employee) this.dataBaseManager.Operator;
//设置报表参数
this.QuerySqlTypeValue = QuerySqlType.id;
//this.QuerySql = this.sqlDrugTJ;
this.QuerySql = "Neusoft.WinForms.Report.Logistics.Pharmacy.ucPhadrugtj";
this.DataCrossValues = "3";
this.DataCrossColumns = "1|2";
this.DataCrossRows = "0";
QueryParams.Clear();
QueryParams.Add(new Neusoft.FrameWork.Models.NeuObject("", this.dtpBeginTime.Value.ToString(), ""));
QueryParams.Add(new Neusoft.FrameWork.Models.NeuObject("", this.dtpEndTime.Value.ToString(), ""));
QueryParams.Add(new Neusoft.FrameWork.Models.NeuObject("", outType, ""));
QueryParams.Add(new Neusoft.FrameWork.Models.NeuObject("", employee.Dept.ID, ""));
string deptName = employee.Dept.Name;
this.neuSpread1_Sheet1.SetText(1, 0, "科室：" + deptName);
return(base.OnQuery(sender, neuObject));
}
protected virtual void RefreshUserList()
{
//{1D7BC020-92AC-431b-B27B-1BFBEB0E566B}
Neusoft.HISFC.Models.Base.Employee person = Neusoft.FrameWork.Management.Connection.Operator as Neusoft.HISFC.Models.Base.Employee;
ArrayList al = new ArrayList();
//填充人员列表
if (person.IsManager)
{
al = userManager.GetPeronList();
}
else
{
//不是管理员获取该操作员所在科室的人员
al = userManager.GetPeronList(person.Dept.ID);
}
if (al == null)
{
MessageBox.Show(userManager.Err);
return;
}
AddDataIntoTable(ds.Tables[0], al); //填充数据
dv = new DataView(ds.Tables[0]); //初始化 DataView
this.spread1.DataSource = dv; // 绑定数据源
this.spread1_Sheet1.Columns[3].CellType = new FarPoint.Win.Spread.CellType.CheckBoxCellType();
}
/// <summary>
/// 加载事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ucFinIpbOutPatientReport_Load(object sender, EventArgs e)
{
DateTime nowTime = this.inpatientManager.GetDateTimeFromSysDateTime();
this.dtpEndTime.Value = new DateTime(nowTime.Year, nowTime.Month, nowTime.Day, 23, 59, 59);
this.dtpBeginTime.Value = new DateTime(nowTime.Year, nowTime.Month, nowTime.Day, 00, 00, 00);
//填充数据
Neusoft.HISFC.BizProcess.Integrate.Manager manager = new Neusoft.HISFC.BizProcess.Integrate.Manager();
alPersonconstantList = manager.QueryEmployeeAll();
Neusoft.HISFC.Models.Base.Employee allPerson = new Neusoft.HISFC.Models.Base.Employee();
allPerson.ID = "ALL";
allPerson.Name = "全部";
allPerson.SpellCode = "QB";
alPersonconstantList.Insert(0, allPerson);
this.cboPersonCode.AddItems(alPersonconstantList);
cboPersonCode.SelectedIndex = 0;
this.InitPact();
this.InitBalanceType();
}
private void radioButton1_CheckedChanged(object sender, EventArgs e)
{
string code = string.Empty;
string type = string.Empty;
curUser = Neusoft.FrameWork.Management.Connection.Operator as Neusoft.HISFC.Models.Base.Employee;
Neusoft.HISFC.BizLogic.Manager.UserText m = new Neusoft.HISFC.BizLogic.Manager.UserText();
if (this.radioButton1.Checked)
{
type = "1";
code = curUser.Dept.ID;
}
else
{
type = "0";
code = curUser.ID;
}
ArrayList al = m.GetGroupList(code, type);
if (txtMemo.Items.Count > 0)
{
this.txtMemo.Items.Clear();
txtMemo.Text = "";
}
this.txtMemo.AddItems(al);
}
/// <summary>
/// 保存操作员登陆信息
///
/// {DEA84BD8-882A-440c-AF5B-3C244D16211D}
/// </summary>
public static int SaveLoginInfo(Neusoft.HISFC.Models.Base.Employee oper)
{
if (LoginSessionID == "NULL") //首次登陆
{
string hosName = System.Net.Dns.GetHostName();
string ip = System.Net.Dns.GetHostEntry(hosName).AddressList[0].ToString();
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
Neusoft.HISFC.BizLogic.Manager.UserManager userManager = new Neusoft.HISFC.BizLogic.Manager.UserManager();
LoginSessionID = userManager.GetLoginSessionID();
if (userManager.InsertLoginLog(oper, LoginSessionID, ip, hosName) != 1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
return(-1);
}
Neusoft.FrameWork.Management.PublicTrans.Commit();
return(1);
}
return(1);
}
/// <summary>
/// 插入人员扩展信息
/// </summary>
/// <param name="emp">人员实体</param>
/// <returns>成功 1 失败 -1</returns>
public int InsertEmpExinfo(Neusoft.HISFC.Models.Base.Employee emp)
{
string strSql = "";
if (this.Sql.GetSql("Person.InsertPersonExinfo", ref strSql) == -1)
{
return(-1);
}
try
{
if (emp != null)
{
strSql = string.Format(strSql, emp.ID);
if (this.ExecNoQuery(strSql) == -1)
{
this.Err = "向人员扩展信息表中插入数据失败！";
return(-1);
}
}
}
catch (Exception ee)
{
this.Err = ee.Message;
return(-1);
}
return(1);
}