/// <summary>
/// 更新不良反应项目
/// </summary>
/// <param name="kb">实体</param>
/// <returns>-1失败，1成功</returns>
public int UpdateKBItem(Neusoft.HISFC.Models.Nurse.Kickback kb)
{
string strsql = "";
if (this.Sql.GetSql("INJECT.KICKBACK.UPDATEITEM_ID", ref strsql) == -1)
{
return(-1);
}
try
{
strsql = string.Format(strsql,
kb.Name,
kb.SpellCode,
kb.WBCode,
kb.UserCode,
(kb.IsValid ? "1" : "0"),
kb.OperEnv.ID,
kb.OperEnv.Name,
kb.OperEnv.OperTime.ToString(),
kb.Memo,
kb.ID);
}
catch (Exception ex)
{
this.Err = ex.Message;
return(-1);
}
if (this.ExecNoQuery(strsql) <= 0)
{
return(-1);
}
return(1);
}
private void neuSpread1_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
Neusoft.HISFC.Models.Nurse.Kickback kb = new Neusoft.HISFC.Models.Nurse.Kickback();
kb.ID = this.neuSpread1_Sheet1.GetText(e.Row, 0);
kb.Name = this.neuSpread1_Sheet1.GetText(e.Row, 1).Replace("\r\n", "");
kb.SpellCode = this.neuSpread1_Sheet1.GetText(e.Row, 2);
kb.WBCode = this.neuSpread1_Sheet1.GetText(e.Row, 3);
kb.UserCode = this.neuSpread1_Sheet1.GetText(e.Row, 4);
if (this.neuSpread1_Sheet1.GetText(e.Row, 5).Trim().Equals("是"))
{
kb.IsValid = true;
}
else
{
kb.IsValid = false;
}
kb.Memo = this.neuSpread1_Sheet1.GetText(e.Row, 6).Replace("\r\n", "");
kb.OperEnv.ID = ((Neusoft.HISFC.Models.Base.Employee)Neusoft.FrameWork.Management.Connection.Operator).ID;
kb.OperEnv.Name = ((Neusoft.HISFC.Models.Base.Employee)Neusoft.FrameWork.Management.Connection.Operator).Name;
kb.OperEnv.OperTime = this.kbManager.GetDateTimeFromSysDateTime();
ucKBHandler uc = new ucKBHandler();
uc.IsAdd = false;
uc.UpdateItem(kb);
uc.UpdateEvent += new UpdateSuccessHandler(uc_UpdateEvent);
Neusoft.FrameWork.WinForms.Classes.Function.PopShowControl(uc);
}
public void UpdateItem(Neusoft.HISFC.Models.Nurse.Kickback kb)
{
this.tbID.Text = kb.ID;
this.tbID.ReadOnly = true;
this.tbName.Text = kb.Name;
this.tbSpell.Text = kb.SpellCode;
this.tbWb.Text = kb.WBCode;
this.tbUser.Text = kb.UserCode;
this.tbMemo.Text = kb.Memo;
}
private Neusoft.HISFC.Models.Nurse.Kickback GetForm()
{
Neusoft.HISFC.Models.Nurse.Kickback kb = new Neusoft.HISFC.Models.Nurse.Kickback();
kb.ID = this.tbID.Text;
kb.Name = this.tbName.Text;
kb.SpellCode = this.tbSpell.Text;
kb.WBCode = this.tbWb.Text;
kb.UserCode = this.tbUser.Text;
kb.Memo = this.tbMemo.Text;
kb.IsValid = this.chkValid.Checked;
kb.OperEnv.ID = ((Neusoft.HISFC.Models.Base.Employee)Neusoft.FrameWork.Management.Connection.Operator).ID;
kb.OperEnv.Name = ((Neusoft.HISFC.Models.Base.Employee)Neusoft.FrameWork.Management.Connection.Operator).Name;
kb.OperEnv.OperTime = this.kbManager.GetDateTimeFromSysDateTime();
return(kb);
}
/// <summary>
/// 修改行
/// </summary>
/// <param name="kb">实体</param>
/// <returns>-1失败，1成功</returns>
private int Modify(Neusoft.HISFC.Models.Nurse.Kickback kb)
{
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
//Neusoft.FrameWork.Management.Transaction t = new Neusoft.FrameWork.Management.Transaction(Neusoft.FrameWork.Management.Connection.Instance);
//t.BeginTransaction();
this.kbManager.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
if (this.kbManager.UpdateKBItem(kb) == -1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
return(-1);
}
Neusoft.FrameWork.Management.PublicTrans.Commit();
return(1);
}
private void FillTable(DataRow dr, Neusoft.HISFC.Models.Nurse.Kickback kb)
{
dr["ID"] = kb.ID;
dr["名称"] = kb.Name;
dr["拼音码"] = kb.SpellCode;
dr["五笔码"] = kb.WBCode;
dr["自定义码"] = kb.UserCode;
if (kb.IsValid)
{
dr["是否有效"] = "是";
}
else
{
dr["是否有效"] = "否";
}
dr["备注"] = kb.Memo;
}
/// <summary>
/// 获取所有不良反应信息 /// </summary>
/// <returns>null失败</returns>
public List <Neusoft.HISFC.Models.Nurse.Kickback> QueryKickback()
{
string strsql = "";
if (this.Sql.GetSql("INJECT.KICKBACK.SELECTALL", ref strsql) == -1)
{
this.Err = "读取 INJECT.KICKBACK.SELECTALL " + "失败";
return(null);
}
if (this.ExecQuery(strsql) == -1)
{
return(null);
}
List <Neusoft.HISFC.Models.Nurse.Kickback> kbList = new List <Neusoft.HISFC.Models.Nurse.Kickback>();
while (this.Reader.Read())
{
Neusoft.HISFC.Models.Nurse.Kickback kb = new Neusoft.HISFC.Models.Nurse.Kickback();
kb.ID = this.Reader.IsDBNull(0) ? "" : this.Reader[0].ToString(); //编码
kb.Name = this.Reader.IsDBNull(1) ? "" : this.Reader[1].ToString(); //名称
kb.SpellCode = this.Reader.IsDBNull(2) ? "" : this.Reader[2].ToString(); //拼音码 kb.WBCode = this.Reader.IsDBNull(3) ? "" : this.Reader[3].ToString();//五笔码 kb.UserCode = this.Reader.IsDBNull(4) ? "" : this.Reader[4].ToString();//自定义码
if (this.Reader.IsDBNull(5))
{
kb.IsValid = false;
}
else
{
if (this.Reader[5].ToString().Trim().Equals("1"))
{
kb.IsValid = true;
}
else
{
kb.IsValid = false;
}
}
kb.Memo = this.Reader.IsDBNull(6) ? "" : this.Reader[6].ToString();//备注
kbList.Add(kb);
}
return(kbList);
}
