public FrmEdtMachineInfo(Int64 id) { InitializeComponent(); db = new Database("XE"); _id = id; vALUEGROUPBindingSource.DataSource = db.Fetch<VALUE_GROUP>("where FATHERID = @0", 15); vALUECODEBindingSource1.DataSource = db.Fetch<VALUE_CODE>("where GROUPNAME = @0", 17); // 耗材供应商 ConditionValidationRule ruleNoEmpty = new ConditionValidationRule(); ruleNoEmpty.ConditionOperator = ConditionOperator.IsNotBlank; ruleNoEmpty.ErrorText = "该项不能为空。"; dxValidationProvider1.SetValidationRule(MACHINETYPETextEdit, ruleNoEmpty); // 设备类型 dxValidationProvider1.SetValidationRule(MODELTextEdit, ruleNoEmpty); // 设备型号 dxValidationProvider1.SetValidationRule(SNTextEdit, ruleNoEmpty); // 设备序列号 dxValidationProvider1.SetValidationRule(BED_NOTextEdit, ruleNoEmpty); // 所在床位号 mach = db.Single<MACHINE_INFO>("where ID = @0", _id); mACHINEINFOBindingSource.DataSource = mach; }
private void SaveData() { mACHINEINFOBindingSource.EndEdit(); mACHINEINFOBindingSource.CurrencyManager.EndCurrentEdit(); var layout = db.Single<MACHINE_LAYOUT>(_baseID); var info = db.Fetch<MACHINE_INFO>("where FLOOR_ID = @0 and AREA_ID = @1 and BED_NO = @2", new object[] { layout .FLOORID, layout.AREAID, mach.BED_NO}); if (info != null && info.Count > 0) throw new Exception("该床位号已存在于该区域, 请确认."); mach.LAYOUT_ID = _baseID; mach.LOG_TIME = DateTime.Now; mach.OPERATOR = ClsFrmMng.WorkerID; mach.FLOOR_ID = layout.FLOORID; mach.AREA_ID = layout.AREAID; db.Insert(mach); if (NewRegistEvt != null) NewRegistEvt(); mach = new MACHINE_INFO(); mACHINEINFOBindingSource.DataSource = mach; }