/// <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="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="list">黑名单明细数据</param>
/// <returns></returns>
public int GetBlackListDetail(string cardNO, ref List <PatientBlackListDetail> list)
{
string sqlStr = string.Empty;
if (this.Sql.GetSql("Fee.BlackList.SelectBlackListDetail", 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);
}
list = new List <PatientBlackListDetail>();
PatientBlackListDetail obj = null;
while (this.Reader.Read())
{
obj = new PatientBlackListDetail();
obj.SeqNO = this.Reader[0].ToString();
obj.BlackListValid = NConvert.ToBoolean(this.Reader[1]);
obj.Memo = this.Reader[2].ToString();
obj.Oper.Name = this.Reader[3].ToString();
obj.Oper.OperTime = NConvert.ToDateTime(this.Reader[4]);
list.Add(obj);
}
return(1);
}
catch (Exception ex)
{
this.Err = ex.Message;
return(-1);
}
}
