示例#1
0
        /// <summary>
        /// 保存
        /// </summary>
        void btnSave_Click(object sender, EventArgs e)
        {
            if (_isPrint)
            {
                //修改  本界面的 事务中插入数据
            }
            else
            {
                //新增yzgl里面的事务中插入数据
                try
                {
                    myEntity.Clear();
                    foreach (DataRow dr in _dtKss.Rows)
                    {
                        //特殊级药物
                        if (!dr["MEMO"].ToString().Equals("3"))
                        {
                            continue;
                        }

                        Entity_KjSq entity = new Entity_KjSq();

                        entity.drYzInfo = dr;

                        entity.DJID         = TrasenClasses.GeneralClasses.PubStaticFun.NewGuid().ToString();
                        entity.INPATIENT_ID = "";
                        entity.baby_id      = "";
                        entity.order_id     = dr["ID"].ToString();
                        entity.group_id     = dr["嘱号"].ToString();
                        entity.dept_id      = InstanceForm._currentDept.DeptId.ToString();
                        entity.zyzd         = txtZyZd.Text;
                        entity.shyj         = txtShyj.Text;
                        entity.apply_id     = InstanceForm._currentUser.EmployeeId.ToString();
                        entity.apply_time   = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
                        entity.shr          = cmbDept.SelectedValue == null ? "-1" : cmbDept.SelectedValue.ToString();//审核人未取
                        entity.shsj         = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");

                        //申请用药理由
                        UcApplyInfo ucSqly = ucApplyInfos1.myCts[entity.order_id];

                        //1、用药目的
                        entity.purp_1      = ucSqly.rbtYfxyy.Checked ? "1" : ucSqly.rbtZlxyy.Checked ? "0" : "";
                        entity.purp_1_memo = ucSqly.rbtZlxyy.Checked ? ucSqly.txtYymdZl.Text : "";

                        //2、是否已送病原学检查
                        entity.purp_2      = ucSqly.rbtByjcYes.Checked ? "1" : ucSqly.rbtByjcNo.Checked ? "0" : "";
                        entity.purp_2_memo = "";

                        //3、是否已有细菌培养及药敏结果
                        entity.purp_3      = ucSqly.rbtXjpyYes.Checked ? "1" : ucSqly.rbtXjpyNo.Checked ? "0" : "";
                        entity.purp_3_memo = ucSqly.rbtXjpyYes.Checked ? ucSqly.txtByj.Text : "";

                        //4、所申请药物是否对该病原菌敏感
                        entity.purp_4      = ucSqly.rbtYjmgYes.Checked ? "1" : ucSqly.rbtYjmgNo.Checked ? "0" : "";
                        entity.purp_4_memo = "";

                        //5、其他
                        entity.purp_5_memo = ucSqly.txtMemo.Text;

                        myEntity.Add(dr["ID"].ToString(), entity);

                        #region "sql"
                        //                    string strSql = string.Format(@"insert into zy_kss_sqb(DJID
                        //                                                                           INPATIENT_ID
                        //                                                                           baby_id
                        //                                                                           order_id
                        //                                                                           group_id
                        //                                                                           dept_id
                        //                                                                           zyzd
                        //                                                                           shyj
                        //                                                                           apply_id
                        //                                                                           apply_time
                        //                                                                           shr
                        //                                                                           shsj
                        //                                                                           purp_1
                        //                                                                           purp_1_memo
                        //                                                                           purp_2
                        //                                                                           purp_2_memo
                        //                                                                           purp_3
                        //                                                                           purp_3_memo
                        //                                                                           purp_4
                        //                                                                           purp_4_memo
                        //                                                                           purp_5_memo) VALUES
                        //                                                                        ('{0}','{1}',{2},'{3}','{4}','{5}',{6},'{7}','{8}','{9}',{10},'{11}','{12}','{13}',{14},'{15}','{16}','{17}',{18},'{19}','{20}')",
                        //                                                   entity.DJID, entity.INPATIENT_ID, entity.baby_id, entity.order_id, entity.group_id, entity.dept_id, entity.zyzd, entity.shyj, entity.apply_id, entity.apply_time,
                        //                                                   entity.shr, entity.shsj, entity.purp_1, entity.purp_1_memo, entity.purp_2, entity.purp_2_memo, entity.purp_3, entity.purp_3_memo, entity.purp_4, entity.purp_4_memo, entity.purp_5_memo);

                        #endregion
                    }
                    _isOk = true;
                    if (MessageBox.Show("操作成功,是否打印!", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
                    {
                        btnPrint_Click(null, null);
                    }
                }
                catch
                {
                    _isOk = false;
                    MessageBox.Show("操作失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return;
                }
            }
        }
示例#2
0
        private DataTable DoGetPrintData()
        {
            try
            {
                if (_dtKss.Rows.Count <= 0)
                {
                    return(null);
                }

                DataTable dtPrint = new DataTable();
                dtPrint.Columns.Add("zyh", typeof(string));
                dtPrint.Columns.Add("age", typeof(string));
                dtPrint.Columns.Add("name", typeof(string));
                dtPrint.Columns.Add("sex", typeof(string));
                dtPrint.Columns.Add("bed", typeof(string));
                dtPrint.Columns.Add("zyzd", typeof(string));
                dtPrint.Columns.Add("mc", typeof(string));
                dtPrint.Columns.Add("yf", typeof(string));
                dtPrint.Columns.Add("gg", typeof(string));
                dtPrint.Columns.Add("num", typeof(string));
                dtPrint.Columns.Add("yfxyy", typeof(string));
                dtPrint.Columns.Add("zlxyy", typeof(string));
                dtPrint.Columns.Add("grzd", typeof(string));
                dtPrint.Columns.Add("byjcyes", typeof(string));
                dtPrint.Columns.Add("byjcno", typeof(string));
                dtPrint.Columns.Add("ymjgyes", typeof(string));
                dtPrint.Columns.Add("ymjgno", typeof(string));
                dtPrint.Columns.Add("byj", typeof(string));
                dtPrint.Columns.Add("byjmgyes", typeof(string));
                dtPrint.Columns.Add("byjmgno", typeof(string));
                dtPrint.Columns.Add("memo", typeof(string));
                dtPrint.Columns.Add("applyer", typeof(string));
                dtPrint.Columns.Add("kszr", typeof(string));
                dtPrint.Columns.Add("sqrq", typeof(string));
                dtPrint.Columns.Add("shyj", typeof(string));

                foreach (KeyValuePair <string, Entity_KjSq> kvp in myEntity)
                {
                    DataRow dr = dtPrint.NewRow();

                    Entity_KjSq entity = kvp.Value;
                    string      id     = kvp.Key;
                    string      grpId  = entity.group_id;

                    DataTable dtGrp = dataGrid_LongOrder.DataSource as DataTable;
                    dr["gg"] = entity.drYzInfo["单位"];
                    for (int i = 0; i < dtGrp.Rows.Count; i++)
                    {
                        if (id.Equals(dtGrp.Rows[i]["ID"].ToString()))
                        {
                            if (dtGrp.Columns.Contains("规格"))
                            {
                                dr["gg"] = dtGrp.Rows[i]["规格"].ToString();
                            }
                        }

                        if (dtGrp.Rows[i]["嘱号"].ToString().Equals(grpId))
                        {
                            if (!dtGrp.Rows[i]["用法"].ToString().Trim().Equals(""))
                            {
                                dr["yf"] = dtGrp.Rows[i]["用法"].ToString().Trim();
                            }
                        }
                    }

                    dr["zyh"]  = _patientInfo.lbID.Text;
                    dr["age"]  = _patientInfo.lbAge.Text;
                    dr["name"] = _patientInfo.lbName.Text;
                    dr["sex"]  = _patientInfo.lbSex.Text;
                    dr["bed"]  = _patientInfo.lbBed.Text;
                    dr["zyzd"] = txtZyZd.Text;

                    dr["mc"]  = entity.drYzInfo["医嘱内容"];
                    dr["num"] = entity.drYzInfo["剂量"];

                    dr["yfxyy"] = entity.purp_1.Equals("1") ? "√" : "";
                    dr["zlxyy"] = entity.purp_1.Equals("0") ? "√" : "";
                    dr["grzd"]  = entity.purp_1_memo;

                    dr["byjcyes"] = entity.purp_2.Equals("1") ? "√" : "";
                    dr["byjcno"]  = entity.purp_2.Equals("0") ? "√" : "";

                    dr["ymjgyes"] = entity.purp_3.Equals("1") ? "√" : "";
                    dr["ymjgno"]  = entity.purp_3.Equals("0") ? "√" : "";
                    dr["byj"]     = entity.purp_3_memo;

                    dr["byjmgyes"] = entity.purp_4.Equals("1") ? "√" : "";
                    dr["byjmgno"]  = entity.purp_4.Equals("0") ? "√" : "";

                    dr["memo"] = entity.purp_5_memo;

                    dr["applyer"] = txtSqYs.Text;
                    dr["kszr"]    = cmbDept.Text;
                    dr["sqrq"]    = dtpDate.Value.ToString("yyyy年MM月dd日");
                    dr["shyj"]    = txtShyj.Text;

                    dtPrint.Rows.Add(dr);
                }

                return(dtPrint);
            }
            catch { return(null); }
        }
示例#3
0
        private void FrmKssSpecialApply_Load(object sender, EventArgs e)
        {
            //绑定主任医生
            try
            {
                string sql = string.Format(@"select distinct b.py_code 拼音码, b.name as 姓名, b.wb_code 五笔码,a.doc_id 数字码,b.employee_id 
                                              from jc_role_doctor a ,jc_employee_property b,jc_EMP_DEPT_ROLE c 
                                             where a.employee_id=b.employee_id and c.employee_id=b.employee_id 
                                                   and c.dept_id='{0}'
                                                   and b.delete_bit=0", InstanceForm._currentDept.DeptId);

                DataTable dt = InstanceForm._database.GetDataTable(sql);

                cmbDept.DataSource    = dt;
                cmbDept.DisplayMember = "姓名";
                cmbDept.ValueMember   = "employee_id";
                cmbDept.SelectedIndex = 0;
            }
            catch { }

            try
            {
                txtZyZd.ReadOnly = false;

                dataGrid_LongOrder.ReadOnly = true;
                //初始化申请用药目的控件
                ucApplyInfos1.DoIniCt(_dtKss);

                lblDept.Text = InstanceForm._currentDept.DeptName;

                txtXm.Text   = _patientInfo.lbName.Text;
                txtZyh.Text  = _patientInfo.lbID.Text;
                txtNn.Text   = _patientInfo.lbAge.Text;
                txtXb.Text   = _patientInfo.lbSex.Text;
                txtCh.Text   = _patientInfo.lbBed.Text;
                txtZyZd.Text = _patientInfo.lbRYZD.Text;

                txtSqYs.Text = InstanceForm._currentUser.Name;

                //dataGridView1.DataSource = _dtKss;
                InitGrd_LongOrder();  //长期医嘱网格
                loadGrid_LongOrder();
            }
            catch { }

            try
            {
                //如果是打印界面
                if (_isPrint)
                {
                    myEntity.Clear();
                    foreach (DataRow dr in _dtKss.Rows)
                    {
                        //特殊级药物
                        if (!dr["MEMO"].ToString().Equals("3"))
                        {
                            continue;
                        }

                        string id    = dr["ID"].ToString();
                        string grpId = "";// dr[""].ToString();
                        if (_dtKss.Columns.Contains("嘱号"))
                        {
                            grpId = dr["嘱号"].ToString();
                        }
                        else if (_dtKss.Columns.Contains("group_id".ToUpper()))
                        {
                            grpId = dr["group_id".ToUpper()].ToString();
                        }

                        //申请用药理由
                        UcApplyInfo ucSqly = ucApplyInfos1.myCts[id];

                        //查询初始化给控件赋值
                        ucSqly.rbtYfxyy.Checked = dr["purp_1".ToUpper()].ToString().Equals("1");
                        ucSqly.rbtZlxyy.Checked = dr["purp_1".ToUpper()].ToString().Equals("0");
                        ucSqly.txtYymdZl.Text   = dr["purp_1_memo".ToUpper()].ToString();

                        ucSqly.rbtByjcYes.Checked = dr["purp_2".ToUpper()].ToString().Equals("1");
                        ucSqly.rbtByjcNo.Checked  = dr["purp_2".ToUpper()].ToString().Equals("0");

                        ucSqly.rbtXjpyYes.Checked = dr["purp_3".ToUpper()].ToString().Equals("1");
                        ucSqly.rbtXjpyNo.Checked  = dr["purp_3".ToUpper()].ToString().Equals("0");
                        ucSqly.txtByj.Text        = dr["purp_3_memo".ToUpper()].ToString();

                        ucSqly.rbtYjmgYes.Checked = dr["purp_4".ToUpper()].ToString().Equals("1");
                        ucSqly.rbtYjmgNo.Checked  = dr["purp_4".ToUpper()].ToString().Equals("0");

                        ucSqly.txtMemo.Text = dr["purp_5_memo".ToUpper()].ToString();

                        //打印界面初始化参数变量
                        Entity_KjSq entity = new Entity_KjSq();

                        entity.drYzInfo = dr;
                        entity.order_id = id;
                        entity.group_id = grpId;

                        //1、用药目的
                        entity.purp_1      = ucSqly.rbtYfxyy.Checked ? "1" : ucSqly.rbtZlxyy.Checked ? "0" : "";
                        entity.purp_1_memo = ucSqly.rbtZlxyy.Checked ? ucSqly.txtYymdZl.Text : "";

                        //2、是否已送病原学检查
                        entity.purp_2      = ucSqly.rbtByjcYes.Checked ? "1" : ucSqly.rbtByjcNo.Checked ? "0" : "";
                        entity.purp_2_memo = "";

                        //3、是否已有细菌培养及药敏结果
                        entity.purp_3      = ucSqly.rbtXjpyYes.Checked ? "1" : ucSqly.rbtXjpyNo.Checked ? "0" : "";
                        entity.purp_3_memo = ucSqly.rbtXjpyYes.Checked ? ucSqly.txtByj.Text : "";

                        //4、所申请药物是否对该病原菌敏感
                        entity.purp_4      = ucSqly.rbtYjmgYes.Checked ? "1" : ucSqly.rbtYjmgNo.Checked ? "0" : "";
                        entity.purp_4_memo = "";

                        //5、其他
                        entity.purp_5_memo = ucSqly.txtMemo.Text;

                        myEntity.Add(dr["ID"].ToString(), entity);
                    }
                }
            }
            catch { }
        }