public bool InsertEmpowerOper(Neusoft.HISFC.Models.Fee.EmpowerFeeOper empowerFeeOper) { string sql = string.Empty; if (this.Sql.GetSql("Fee.Inpatient.InsertEmpowerOper", ref sql) == -1) { this.Err = "查询索引为Fee.Inpatient.InsertEmpowerOper的SQL语句失败!"; return(false); } string [] objs = { empowerFeeOper.FeeOperCode, empowerFeeOper.StatNo, empowerFeeOper.DayBalanceDate.ToString(), empowerFeeOper.OperCode, empowerFeeOper.OperDate.ToString(), empowerFeeOper.Valid ? "1":"0" }; sql = string.Format(sql, objs); int returnValue = Neusoft.FrameWork.Function.NConvert.ToInt32(this.ExecNoQuery(sql)); if (returnValue <= 0) { return(false); } return(true); }
/// <summary> /// Toolbar上的【授权】按钮单击事件 /// </summary> private void Authorized() { if (fpUnauthorized_Sheet1 == null || fpUnauthorized_Sheet1.RowCount <= 0) { MessageBox.Show("没用任何记录可以操作!"); return; } else { Neusoft.HISFC.Models.Fee.EmpowerFeeOper empowerFeeOper = new Neusoft.HISFC.Models.Fee.EmpowerFeeOper(); int ridx = fpUnauthorized_Sheet1.ActiveRowIndex; empowerFeeOper.FeeOperCode = fpUnauthorized_Sheet1.Cells[ridx, 4].Value.ToString(); empowerFeeOper.StatNo = fpUnauthorized_Sheet1.Cells[ridx, 5].Value.ToString(); empowerFeeOper.DayBalanceDate = Convert.ToDateTime(fpUnauthorized_Sheet1.Cells[ridx, 1].Value); empowerFeeOper.OperCode = empowerFeeManager.Operator.ID; empowerFeeOper.OperDate = empowerFeeManager.GetDateTimeFromSysDateTime(); empowerFeeOper.Valid = true; if (empowerFeeManager.InsertEmpowerOper(empowerFeeOper)) { QueryAllDayBalance(); QueryAllEmpowered(); } } }