/// <summary> /// ²åÈëеIJ¡Àú¸ü»»ÉêÇë /// </summary> /// <param name="change">²¡Àú¸ü»»ÊµÌå</param> /// <returns>-1ʧ°Ü; 1³É¹¦</returns> public int InsertApply(Neusoft.HISFC.Models.HealthRecord.Case.CaseChange change) { string strsql = ""; if (this.Sql.GetSql("CaseManager.CaseChange.InsertApply", ref strsql) == -1) { this.Err = "»ñÈ¡ CaseManager.CaseChange.InsertApply ʧ°Ü"; return(-1); } try { strsql = string.Format(strsql, change.ID, change.OldCardNO, change.NewCardNO, change.DoctorEnv.ID, change.DoctorEnv.OperTime.ToString(), change.Memo); } catch (Exception ex) { this.Err = "InsertApply ×é×Ö·û´®Ê§°ÜÄ˳ɹ¦Ö®Ä¸" + ex.Message; return(-1); } if (this.ExecNoQuery(strsql) <= 0) { return(-1); } return(1); }
/// <summary> /// È·Èϲ¡Àú¸ü»»ÉêÇë /// </summary> /// <param name="change">²¡Àú¸ü»»ÊµÌå</param> /// <returns>-1ʧ°Ü, 1³É¹¦</returns> public int UpdateApply(Neusoft.HISFC.Models.HealthRecord.Case.CaseChange change) { string strsql = ""; if (this.Sql.GetSql("CaseManager.CaseChange.UpdateApply", ref strsql) == -1) { this.Err = "»ñÈ¡ CaseManager.CaseChange.UpdateApply ʧ°Ü"; return(-1); } try { strsql = string.Format(strsql, change.OperEnv.ID, change.OperEnv.OperTime.ToString(), "1",/*change.IsValid*/ change.ChargeCost.ToString(), change.ID, change.OldCardNO); } catch (Exception ex) { this.Err = "UpdateApply ×é×Ö·û´®Ê§°Ü" + ex.Message; return(-1); } if (this.ExecNoQuery(strsql) <= 0) { return(-1); } return(1); }
private void btnOK_Click(object sender, EventArgs e) { Neusoft.HISFC.BizLogic.HealthRecord.Case.CaseChangeManager changeManager = new Neusoft.HISFC.BizLogic.HealthRecord.Case.CaseChangeManager(); Neusoft.HISFC.Models.HealthRecord.Case.CaseChange change = changeManager.GetChangeApplyByOldCode(this.tbCard.Text.Trim()); if (change == null) { MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("没有找到病历更换申请信息")); return; } }
/// <summary> /// ¸ù¾Ý¾É²¡ÀúºÅÈ¡µÃ²¡Àú¸ü»»ÉêÇë /// </summary> /// <param name="oldCode">¾É²¡ÀúºÅ</param> /// <returns>null ʧ°Ü</returns> public Neusoft.HISFC.Models.HealthRecord.Case.CaseChange GetChangeApplyByOldCode(string oldCode) { string strsql = ""; if (this.Sql.GetSql("CaseManager.CaseChange.SelectApplyByID", ref strsql) == -1) { this.Err = "»ñÈ¡ CaseManager.CaseChange.SelectApplyByID ʧ°Ü"; return(null); } try { strsql = string.Format(strsql, oldCode); } catch (Exception ex) { this.Err = "GetChangeApplyByOldCode ×é×Ö·û´®Ê§°Ü" + ex.Message; return(null); } if (this.ExecQuery(strsql) == -1) { this.Err = "GetChangeApplyByOldCodeÖ´ÐÐʧ°ÜÄ˳ɹ¦Ö®Ä¸"; return(null); } if (this.Reader.Read()) { Neusoft.HISFC.Models.HealthRecord.Case.CaseChange change = new Neusoft.HISFC.Models.HealthRecord.Case.CaseChange(); change.ID = this.Reader[0].ToString(); change.OldCardNO = this.Reader[1].ToString(); change.NewCardNO = this.Reader[2].ToString(); change.DoctorEnv.ID = this.Reader[3].ToString(); change.DoctorEnv.Name = this.Reader[4].ToString(); change.DoctorEnv.OperTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[5].ToString()); change.Memo = this.Reader[6].ToString(); this.Reader.Close(); return(change); } return(null); }
private void btnOK_Click(object sender, EventArgs e) { Neusoft.HISFC.BizLogic.HealthRecord.Case.CaseChangeManager changManager = new Neusoft.HISFC.BizLogic.HealthRecord.Case.CaseChangeManager(); Neusoft.HISFC.Models.HealthRecord.Case.CaseChange change = new Neusoft.HISFC.Models.HealthRecord.Case.CaseChange(); change.ID = changManager.GetChangeID(); change.OldCardNO = this.register.PID.CaseNO; //¾É²¡ÀúºÅ change.NewCardNO = this.register.PID.CaseNO; //в¡ÀúºÅ change.DoctorEnv.ID = ((Neusoft.HISFC.Models.Base.Employee)changManager.Operator).ID; change.DoctorEnv.OperTime = changManager.GetDateTimeFromSysDateTime(); change.Memo = this.tbMemo.Text; if (changManager.IsApplyExist(change.OldCardNO)) { MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("¸Ã²¡ÀúºÅµÄ²¡Àú¸ü»»ÉêÇëÒѾ´æÔÚ")); return; } Neusoft.FrameWork.Management.PublicTrans.BeginTransaction(); //Neusoft.FrameWork.Management.Transaction trans = new Neusoft.FrameWork.Management.Transaction(changManager.Connection); //trans.BeginTransaction(); changManager.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans); if (changManager.InsertApply(change) == -1) { Neusoft.FrameWork.Management.PublicTrans.RollBack(); MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("²¡Àú¸ü»»ÉêÇëʧ°Ü")); return; } Neusoft.FrameWork.Management.PublicTrans.Commit(); MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("¸Ã²¡ÀúºÅµÄ²¡Àú¸ü»»ÉêÇëÒѾ´æÔÚ")); this.Clear(); this.FindForm().Close(); }