/// <summary> /// 更新不良反应项目 /// </summary> /// <param name="kb">实体</param> /// <returns>-1失败,1成功</returns> public int UpdateKBItem(Neusoft.HISFC.Models.Nurse.Kickback kb) { string strsql = ""; if (this.Sql.GetSql("INJECT.KICKBACK.UPDATEITEM_ID", ref strsql) == -1) { return(-1); } try { strsql = string.Format(strsql, kb.Name, kb.SpellCode, kb.WBCode, kb.UserCode, (kb.IsValid ? "1" : "0"), kb.OperEnv.ID, kb.OperEnv.Name, kb.OperEnv.OperTime.ToString(), kb.Memo, kb.ID); } catch (Exception ex) { this.Err = ex.Message; return(-1); } if (this.ExecNoQuery(strsql) <= 0) { return(-1); } return(1); }
private void neuSpread1_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e) { Neusoft.HISFC.Models.Nurse.Kickback kb = new Neusoft.HISFC.Models.Nurse.Kickback(); kb.ID = this.neuSpread1_Sheet1.GetText(e.Row, 0); kb.Name = this.neuSpread1_Sheet1.GetText(e.Row, 1).Replace("\r\n", ""); kb.SpellCode = this.neuSpread1_Sheet1.GetText(e.Row, 2); kb.WBCode = this.neuSpread1_Sheet1.GetText(e.Row, 3); kb.UserCode = this.neuSpread1_Sheet1.GetText(e.Row, 4); if (this.neuSpread1_Sheet1.GetText(e.Row, 5).Trim().Equals("是")) { kb.IsValid = true; } else { kb.IsValid = false; } kb.Memo = this.neuSpread1_Sheet1.GetText(e.Row, 6).Replace("\r\n", ""); kb.OperEnv.ID = ((Neusoft.HISFC.Models.Base.Employee)Neusoft.FrameWork.Management.Connection.Operator).ID; kb.OperEnv.Name = ((Neusoft.HISFC.Models.Base.Employee)Neusoft.FrameWork.Management.Connection.Operator).Name; kb.OperEnv.OperTime = this.kbManager.GetDateTimeFromSysDateTime(); ucKBHandler uc = new ucKBHandler(); uc.IsAdd = false; uc.UpdateItem(kb); uc.UpdateEvent += new UpdateSuccessHandler(uc_UpdateEvent); Neusoft.FrameWork.WinForms.Classes.Function.PopShowControl(uc); }
public void UpdateItem(Neusoft.HISFC.Models.Nurse.Kickback kb) { this.tbID.Text = kb.ID; this.tbID.ReadOnly = true; this.tbName.Text = kb.Name; this.tbSpell.Text = kb.SpellCode; this.tbWb.Text = kb.WBCode; this.tbUser.Text = kb.UserCode; this.tbMemo.Text = kb.Memo; }
private Neusoft.HISFC.Models.Nurse.Kickback GetForm() { Neusoft.HISFC.Models.Nurse.Kickback kb = new Neusoft.HISFC.Models.Nurse.Kickback(); kb.ID = this.tbID.Text; kb.Name = this.tbName.Text; kb.SpellCode = this.tbSpell.Text; kb.WBCode = this.tbWb.Text; kb.UserCode = this.tbUser.Text; kb.Memo = this.tbMemo.Text; kb.IsValid = this.chkValid.Checked; kb.OperEnv.ID = ((Neusoft.HISFC.Models.Base.Employee)Neusoft.FrameWork.Management.Connection.Operator).ID; kb.OperEnv.Name = ((Neusoft.HISFC.Models.Base.Employee)Neusoft.FrameWork.Management.Connection.Operator).Name; kb.OperEnv.OperTime = this.kbManager.GetDateTimeFromSysDateTime(); return(kb); }
/// <summary> /// 修改行 /// </summary> /// <param name="kb">实体</param> /// <returns>-1失败,1成功</returns> private int Modify(Neusoft.HISFC.Models.Nurse.Kickback kb) { Neusoft.FrameWork.Management.PublicTrans.BeginTransaction(); //Neusoft.FrameWork.Management.Transaction t = new Neusoft.FrameWork.Management.Transaction(Neusoft.FrameWork.Management.Connection.Instance); //t.BeginTransaction(); this.kbManager.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans); if (this.kbManager.UpdateKBItem(kb) == -1) { Neusoft.FrameWork.Management.PublicTrans.RollBack(); return(-1); } Neusoft.FrameWork.Management.PublicTrans.Commit(); return(1); }
private void FillTable(DataRow dr, Neusoft.HISFC.Models.Nurse.Kickback kb) { dr["ID"] = kb.ID; dr["名称"] = kb.Name; dr["拼音码"] = kb.SpellCode; dr["五笔码"] = kb.WBCode; dr["自定义码"] = kb.UserCode; if (kb.IsValid) { dr["是否有效"] = "是"; } else { dr["是否有效"] = "否"; } dr["备注"] = kb.Memo; }
/// <summary> /// 获取所有不良反应信息 /// </summary> /// <returns>null失败</returns> public List <Neusoft.HISFC.Models.Nurse.Kickback> QueryKickback() { string strsql = ""; if (this.Sql.GetSql("INJECT.KICKBACK.SELECTALL", ref strsql) == -1) { this.Err = "读取 INJECT.KICKBACK.SELECTALL " + "失败"; return(null); } if (this.ExecQuery(strsql) == -1) { return(null); } List <Neusoft.HISFC.Models.Nurse.Kickback> kbList = new List <Neusoft.HISFC.Models.Nurse.Kickback>(); while (this.Reader.Read()) { Neusoft.HISFC.Models.Nurse.Kickback kb = new Neusoft.HISFC.Models.Nurse.Kickback(); kb.ID = this.Reader.IsDBNull(0) ? "" : this.Reader[0].ToString(); //编码 kb.Name = this.Reader.IsDBNull(1) ? "" : this.Reader[1].ToString(); //名称 kb.SpellCode = this.Reader.IsDBNull(2) ? "" : this.Reader[2].ToString(); //拼音码 kb.WBCode = this.Reader.IsDBNull(3) ? "" : this.Reader[3].ToString();//五笔码 kb.UserCode = this.Reader.IsDBNull(4) ? "" : this.Reader[4].ToString();//自定义码 if (this.Reader.IsDBNull(5)) { kb.IsValid = false; } else { if (this.Reader[5].ToString().Trim().Equals("1")) { kb.IsValid = true; } else { kb.IsValid = false; } } kb.Memo = this.Reader.IsDBNull(6) ? "" : this.Reader[6].ToString();//备注 kbList.Add(kb); } return(kbList); }