public FrmEdtBloodCeanupBase(Int64 id)
{
InitializeComponent();
////string sPwd = Des.Decrypt(ClsFrmMng.KEY, ConfigurationManager.AppSettings["DbPwd"]);
db = new Database("XE");
_id = id;
bloodCleanup = db.Single<BLOODCLEANUP>("where ID = @0", _id);
bLOODCLEANUPBindingSource.DataSource = bloodCleanup;
//EPOTextEdit.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
EPOTextEdit.Properties.DataSource = db.Fetch<VALUE_CODE>("");
EPOTextEdit.Properties.DisplayMember = "DSP_MEMBER";
EPOTextEdit.Properties.ValueMember = "VALUE_MEMBER";
MACH_TYPTextEdit.Properties.DataSource = db.Fetch<VALUE_CODE>("where GROUPNAME = @0", new object[] {3});
MACH_TYPTextEdit.Properties.DisplayMember = "DSP_MEMBER";
MACH_TYPTextEdit.Properties.ValueMember = "VALUE_MEMBER";
vALUECODEBindingSource.DataSource = db.Fetch<VALUE_CODE>("where GROUPNAME = @0", 101);
vALUECODEBindingSource1.DataSource = db.Fetch<VALUE_CODE>("where GROUPNAME = @0", 44);
vALUECODEBindingSource2.DataSource = db.Fetch<VALUE_CODE>("where GROUPNAME = @0", 102);
vALUECODEBindingSource3.DataSource = db.Fetch<VALUE_CODE>("where GROUPNAME = @0", 161);
aCCOUNTBindingSource.DataSource = db.Fetch<ACCOUNT>("");
bindingSource1.DataSource = db.Fetch<VALUE_CODE>("where GROUPNAME = @0", 193); // 通路类型
bindingSource2.DataSource = db.Fetch<VALUE_CODE>("where GROUPNAME = @0", 47); // 管路
bindingSource3.DataSource = db.Fetch<VALUE_CODE>("where GROUPNAME = @0", 43); // 穿刺针
bindingSource4.DataSource = db.Fetch<VALUE_CODE>("where GROUPNAME = @0", 171); // 敷贴
bindingSource5.DataSource = db.Fetch<VALUE_CODE>("where GROUPNAME = @0", 166); // 护理包
bindingSource6.DataSource = db.Fetch<VALUE_CODE>("where GROUPNAME = @0", 169); // 肝素帽
// 血管通路类型
if (bloodCleanup.FISTULA_TYPE == 519 || bloodCleanup.FISTULA_TYPE == 520)
{
ItemForAPPLICATOR.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
ItemForAPPLICATOR_NUM.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
ItemForHEPARIN_CAP.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
ItemForHEPARIN_CAP_NUM.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
}
else if (bloodCleanup.FISTULA_TYPE == 704 || bloodCleanup.FISTULA_TYPE == 705)
{
ItemForFISTULA_NEEDLE.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
ItemForFISTULA_NEEDLE_NUM.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
ItemForFISTULA_CARE_PACKAGES.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
ItemForFISTULA_CARE_PACKAGES_NUM.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
}
}
public Rpt_bloodCleanup(string Name, int Age, string Sex,List<BLOODCLEANUP_PROCESS> lstProcess, BLOODCLEANUP Blood, List<VALUE_CODE> lstCode)
{
InitializeComponent();
//string sPwd = Des.Decrypt(ClsFrmMng.KEY, ConfigurationManager.AppSettings["DbPwd"]);
db = new Database("XE");
lblName.Text = Name;
lblAge.Text = Age.ToString();
lblSex.Text = Sex;
_lstCode = lstCode;
bindingSource1.DataSource = Blood;
bindingSource2.DataSource = lstProcess;
}
public FrmEdtBloodCleanup_Summary(Int64 id)
{
InitializeComponent();
//string sPwd = Des.Decrypt(ClsFrmMng.KEY, ConfigurationManager.AppSettings["DbPwd"]);
db = new Database("XE");
_id = id;
cleanup = db.Single<BLOODCLEANUP>("where ID = @0", _id);
bLOODCLEANUPBindingSource.DataSource = cleanup;
CLEANUP_TYPETextEdit.Properties.DataSource = db.Fetch<VALUE_CODE>("select DSP_MEMBER, VALUE_MEMBER from VALUE_CODE where GROUPNAME = @0", new object[] { 1 });
CLEANUP_TYPETextEdit.Properties.DisplayMember = "DSP_MEMBER";
CLEANUP_TYPETextEdit.Properties.ValueMember = "VALUE_MEMBER";
SYMPTOMTextEdit.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;
SYMPTOMTextEdit.Properties.DataSource = ClsFrmMng.lstHaveOrNull;
SYMPTOMTextEdit.Properties.DisplayMember = "MEMO";
SYMPTOMTextEdit.Properties.ValueMember = "ID";
BLOOD_PASSTextEdit.Properties.DataSource = db.Fetch<VALUE_CODE>("select DSP_MEMBER, VALUE_MEMBER from VALUE_CODE where GROUPNAME = @0", new object[] { 2 });
BLOOD_PASSTextEdit.Properties.DisplayMember = "DSP_MEMBER";
BLOOD_PASSTextEdit.Properties.ValueMember = "VALUE_MEMBER";
}
private void btnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (XtraMessageBox.Show("确定保存该信息？", "操作确认", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK)
{
bLOODCLEANUPBindingSource.EndEdit();
bLOODCLEANUPBindingSource.CurrencyManager.EndCurrentEdit();
try
{
blookCaeanup.LOG_TIME = DateTime.Now;
object oID = db.Insert(blookCaeanup);
blookCaeanup = new BLOODCLEANUP();
blookCaeanup.REG_ID = _regID;
blookCaeanup.BASE_INFO_ID = _baseID;
blookCaeanup.OPERATOR = ClsFrmMng.WorkerID;
bLOODCLEANUPBindingSource.DataSource = blookCaeanup;
if (NewRegistEvt != null)
NewRegistEvt();
MACHINE_INFO mi = db.SingleOrDefault<MACHINE_INFO>("where FLOOR_ID = @0 and AREA_ID = @1 and BED_NO= @2",
new object[]{ms.FLOOR_ID, ms.AREA_ID, ms.BED_NO});
if (mi == null || string.IsNullOrWhiteSpace(mi.COMMIP))
throw new Exception("该床位可能没有配置透析机信息, 或该床位所用透析机串口号未配置, 请确认.");
else
{
BLOODCLEANUP_TEMP bt = new BLOODCLEANUP_TEMP();
bt.BLOOD_CLEANUP_ID = Convert.ToDecimal(oID);
bt.ANA_DATE = DateTime.Now;
bt.SERIAL_PORT_NUM = mi.COMMIP;
db.Insert(bt);
}
}
catch (Exception err)
{
XtraMessageBox.Show(err.Message, "错误提示", MessageBoxButtons.OK);
}
}
}
