/// <summary>
/// 根据病历号查找黑名单主表数据
/// </summary>
/// <param name="cardNO">病历号</param>
/// <param name="pbl">黑名单实体</param>
/// <returns></returns>
public int GetBlackListMain(string cardNO, ref PatientBlackList pbl)
{
string sqlStr = string.Empty;
if (this.Sql.GetSql("Fee.BlackList.SelectBlackList", ref sqlStr) == -1)
{
this.Err = "查找SQL语句Fee.BlackList.SelectBlackList失败！";
return(-1);
}
try
{
sqlStr = string.Format(sqlStr, cardNO);
if (this.ExecQuery(sqlStr) == -1)
{
this.Err = "查找患者黑名单数据失败！";
return(-1);
}
pbl = new PatientBlackList();
while (this.Reader.Read())
{
pbl.CardNO = this.Reader[0].ToString();
pbl.BlackListValid = NConvert.ToBoolean(this.Reader[1].ToString());
}
return(1);
}
catch (Exception ex)
{
this.Err = ex.Message;
return(-1);
}
}
/// <summary>
/// 保存黑名单主表数据
/// </summary>
/// <param name="cardNo">病历号</param>
/// <param name="blackListValid">是否在黑名单中 "0"不在 "1"在</param>
/// <returns></returns>
public int SaveBlackList(PatientBlackList pbl)
{
int resultValue = InsertBlackList(pbl);
if (resultValue == -1)
{
resultValue = UpdateBlackList(pbl);
}
return(resultValue);
}
/// <summary>
/// 显示黑名单明细数据
/// </summary>
/// <param name="pbl"></param>
private void SetBlackListDetail(PatientBlackList pbl)
{
List <PatientBlackListDetail> list = pbl.BlackListDetail;
int count = list.Count;
this.neuSpread1_Sheet1.Rows.Count = count;
for (int i = 0; i < count; i++)
{
this.neuSpread1_Sheet1.Cells[i, 0].Text = pbl.CardNO;
this.neuSpread1_Sheet1.Cells[i, 1].Text = list[i].BlackListValid.ToString();
this.neuSpread1_Sheet1.Cells[i, 2].Text = list[i].Memo;
this.neuSpread1_Sheet1.Cells[i, 3].Text = list[i].Oper.Name;
this.neuSpread1_Sheet1.Cells[i, 4].Text = list[i].Oper.OperTime.ToString();
}
}
/// <summary>
/// 获取黑名单实体
/// </summary>
/// <param name="bl">true:加入黑名单 false从黑名单中排除</param>
/// <returns></returns>
private void GetPatientBlackList(bool bl)
{
pbl = new PatientBlackList();
//主表实体
pbl.CardNO = this.txtCardNo.Text;
pbl.BlackListValid = bl;
//明细
pbld = new PatientBlackListDetail();
pbld.SeqNO = pBlackList.GetBlackListSeqNo();
pbld.Memo = this.txtMemo.Text;
pbld.Oper.ID = pBlackList.Operator.ID;
pbld.Oper.OperTime = pBlackList.GetDateTimeFromSysDateTime();
pbld.BlackListValid = bl;
pbl.BlackListDetail.Clear();
pbl.BlackListDetail.Add(pbld);
}
/// <summary>
/// 根据病历号查找黑名单数据
/// </summary>
/// <param name="cardNO"></param>
/// <param name="pbl"></param>
/// <returns></returns>
public int GetBlackList(string cardNO, ref PatientBlackList pbl)
{
int resultValue = this.GetBlackListMain(cardNO, ref pbl);
if (resultValue == -1)
{
return(-1);
}
List <PatientBlackListDetail> list = new List <PatientBlackListDetail>();
resultValue = this.GetBlackListDetail(cardNO, ref list);
if (resultValue == -1)
{
return(-1);
}
pbl.BlackListDetail = list;
return(1);
}
/// <summary>
/// 插入黑名单明细
/// </summary>
/// <param name="pbl">黑名单实体</param>
/// <returns></returns>
public int AddBlackListDetail(PatientBlackList pbl)
{
if (pbl.BlackListDetail == null || pbl.BlackListDetail.Count == 0)
{
this.Err = "保存黑名单明细数据失败！";
return(-1);
}
PatientBlackListDetail pbld = pbl.BlackListDetail[0];
string[] args = new string[]
{
pbld.SeqNO,
pbl.CardNO,
NConvert.ToInt32(pbld.BlackListValid).ToString(),
pbld.Memo,
pbld.Oper.ID,
pbld.Oper.OperTime.ToString()
};
return(UpdateSigleTable("Fee.BlackList.InsertBlackListDetail", args));
}
/// <summary>
/// 将患者插入黑名单中
/// </summary>
///<param name="cardNO">病历号</param>
/// <param name="blackListValid">是否在黑名单中 "0"不在 "1"在</param>
/// <returns></returns>
public int InsertBlackList(PatientBlackList pbl)
{
string[] args = new string[] { pbl.CardNO, NConvert.ToInt32(pbl.BlackListValid).ToString() };
return(this.UpdateSigleTable("Fee.BlackList.InsertBlackList", args));
}
/// <summary>
/// 更新患者是否在黑名单中
/// </summary>
///<param name="cardNO">病历号</param>
/// <param name="blackListValid">是否在黑名单中 "0"不在 "1"在</param>
/// <returns></returns>
public int UpdateBlackList(PatientBlackList pbl)
{
//{E8D9B53F-9C12-4f6e-8F7C-A94FB6B9D173}
string[] args = new string[] { pbl.CardNO, NConvert.ToInt32(pbl.BlackListValid).ToString(), NConvert.ToInt32(!pbl.BlackListValid).ToString() };
return(this.UpdateSigleTable("Fee.BlackList.UpdateBlackList", args));
}
