/// <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();
}
