/// <summary>
/// 判断分区护理站是否已经存在
/// </summary>
/// <param name="subarea">实体</param>
/// <returns>true存在, false不存在</returns>
public bool IsExist(Neusoft.HISFC.Models.HealthRecord.Case.CaseSubarea subarea)
{
string strsql = "";
if (this.Sql.GetSql("CaseManager.Subarea.NurseStationIsExist", ref strsql) == -1)
{
return(true);
}
try
{
strsql = string.Format(strsql, subarea.SubArea.ID, subarea.NurseStation.ID);
}
catch (Exception ex)
{
this.Err = ex.Message;
return(true);
}
string s = this.ExecSqlReturnOne(strsql);
if (s == null || s == string.Empty)
{
return(true);
}
int retv = Neusoft.FrameWork.Function.NConvert.ToInt32(s);
if (retv > 0)
{
return(true);
}
return(false);
}
private void btnOK_Click(object sender, EventArgs e)
{
Neusoft.FrameWork.Models.NeuObject nurseObj = this.cbNurse.SelectedItem;
Neusoft.FrameWork.Models.NeuObject subareaObj = this.cbSubarea.SelectedItem;
Neusoft.HISFC.Models.HealthRecord.Case.CaseSubarea s = new Neusoft.HISFC.Models.HealthRecord.Case.CaseSubarea();
s.SubArea.ID = subareaObj.ID;
s.NurseStation.ID = nurseObj.ID;
if (this.cbManager.IsExist(s))
{
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("记录已经存在"));
return;
}
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
//Neusoft.FrameWork.Management.Transaction trans = new Neusoft.FrameWork.Management.Transaction(this.cbManager.Connection);
//trans.BeginTransaction();
this.cbManager.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
if (this.cbManager.Insert(s) == -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("保存成功"));
}
private void FillFP(Neusoft.HISFC.Models.HealthRecord.Case.CaseSubarea subarea)
{
int rowIndex = this.neuSpread1_Sheet1.Rows.Count;
this.neuSpread1_Sheet1.Rows.Add(rowIndex, 1);
this.neuSpread1_Sheet1.SetText(rowIndex, 0, subarea.SubArea.ID);
this.neuSpread1_Sheet1.SetText(rowIndex, 1, subarea.SubArea.Name);
this.neuSpread1_Sheet1.SetText(rowIndex, 2, subarea.NurseStation.ID);
this.neuSpread1_Sheet1.SetText(rowIndex, 3, subarea.NurseStation.Name);
this.neuSpread1_Sheet1.Rows[rowIndex].Tag = subarea;
}
/// <summary>
/// 根据分区编码取得包含的护理站
/// </summary>
/// <param name="subareaID">分区编码</param>
/// <returns>null失败</returns>
public List <Neusoft.HISFC.Models.HealthRecord.Case.CaseSubarea> QueryBySubareaID(string subareaID)
{
string strsql = "";
if (this.Sql.GetSql("CaseManager.Subarea.SelectBySubareaID", ref strsql) == -1)
{
this.Err = "获取 CaseManager.Subarea.SelectBySubareaID 失败";
return(null);
}
try
{
strsql = string.Format(strsql, subareaID);
}
catch (Exception ex)
{
this.Err = ex.Message;
return(null);
}
if (this.ExecQuery(strsql) == -1)
{
return(null);
}
List <Neusoft.HISFC.Models.HealthRecord.Case.CaseSubarea> listSubarea = new List <Neusoft.HISFC.Models.HealthRecord.Case.CaseSubarea>();
while (this.Reader.Read())
{
Neusoft.HISFC.Models.HealthRecord.Case.CaseSubarea subarea = new Neusoft.HISFC.Models.HealthRecord.Case.CaseSubarea();
subarea.SubArea.ID = this.Reader.IsDBNull(0) ? "" : this.Reader[0].ToString();
subarea.SubArea.Name = this.Reader.IsDBNull(1) ? "" : this.Reader[1].ToString();
subarea.NurseStation.ID = this.Reader.IsDBNull(2) ? "" : this.Reader[2].ToString();
subarea.NurseStation.Name = this.Reader.IsDBNull(3) ? "" : this.Reader[3].ToString();
listSubarea.Add(subarea);
}
this.Reader.Close();
return(listSubarea);
}
/// <summary>
/// 插入新记录
/// </summary>
/// <param name="subarea">实体</param>
/// <returns>-1失败；1成功</returns>
public int Insert(Neusoft.HISFC.Models.HealthRecord.Case.CaseSubarea subarea)
{
string strsql = "";
if (this.Sql.GetSql("CaseManager.Subarea.Insert", ref strsql) == -1)
{
return(-1);
}
try
{
strsql = string.Format(strsql, subarea.SubArea.ID, subarea.NurseStation.ID);
}
catch (Exception ex)
{
return(-1);
}
if (this.ExecNoQuery(strsql) <= 0)
{
return(-1);
}
return(1);
}
