/// <summary>
/// 保存损伤中毒库
/// </summary>
/// <param name="diagnosis">损伤中毒库实体</param>
/// <param name="editType">1:新增 2：修改</param>
/// <returns></returns>
public string SaveToxicosis(Toxicosis toxicosis, string editType)
{
SqlParameter[] sqlParam = new SqlParameter[]
{
new SqlParameter("@EditType", SqlDbType.VarChar),
new SqlParameter("@ID", SqlDbType.VarChar),
new SqlParameter("@MapID", SqlDbType.VarChar),
new SqlParameter("@StandardCode", SqlDbType.VarChar),
new SqlParameter("@Name", SqlDbType.VarChar),
new SqlParameter("@Py", SqlDbType.VarChar),
new SqlParameter("@Wb", SqlDbType.VarChar),
new SqlParameter("@Valid", SqlDbType.VarChar),
new SqlParameter("@Memo", SqlDbType.VarChar)
};
sqlParam[0].Value = editType;
sqlParam[1].Value = toxicosis.Id;
sqlParam[2].Value = toxicosis.Mapid;
sqlParam[3].Value = toxicosis.Standardcode;
sqlParam[4].Value = toxicosis.Name;
sqlParam[5].Value = toxicosis.Py;
sqlParam[6].Value = toxicosis.Wb;
sqlParam[7].Value = toxicosis.Valid;
sqlParam[8].Value = toxicosis.Memo;
return(m_app.SqlHelper.ExecuteDataSet("EmrSysTable.usp_Edit_Toxicosis", sqlParam, CommandType.StoredProcedure).Tables[0].Rows[0][0].ToString());
}
/// <summary>
/// 将损伤中毒库实体中值加载到页面
/// </summary>
/// <param name="Toxicosis"></param>
private void SetPageValue(Toxicosis Toxicosis)
{
if (Toxicosis == null || Toxicosis.Id == "")
{
return;
}
this.txtID.Text = Toxicosis.Id.Trim();
this.txtMapID.Text = Toxicosis.Mapid.Trim();
this.txtName.Text = Toxicosis.Name.Trim();
this.txtPy.Text = Toxicosis.Py.Trim();
this.txtWb.Text = Toxicosis.Wb.Trim();
this.cmbValid.SelectedIndex = Toxicosis.Valid;
this.txtMemo.Text = Toxicosis.Memo.Trim();
this.txtStandardCode.Text = Toxicosis.Standardcode.Trim();
}
/// <summary>
/// 将页面值加入到损伤中毒库实体中
/// </summary>
/// <returns></returns>
private Toxicosis SetEntityByPageValue()
{
Toxicosis Toxicosis = new Toxicosis();
Toxicosis.Id = this.txtID.Text.Trim();
Toxicosis.Mapid = this.txtMapID.Text.Trim();
Toxicosis.Standardcode = this.txtStandardCode.Text.Trim();
Toxicosis.Name = this.txtName.Text.Trim();
Toxicosis.Py = this.txtPy.Text.Trim();
Toxicosis.Wb = this.txtWb.Text.Trim();
Toxicosis.Valid = this.cmbValid.SelectedIndex;
Toxicosis.Memo = this.txtMemo.Text.Trim();
return(Toxicosis);
}
/// <summary>
/// 将gridview中对应行值加载到实体中
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private Toxicosis SetEntityByDataRow(DataRow dr)
{
if (dr == null)
{
return(null);
}
Toxicosis toxicosis = new Toxicosis();
toxicosis.Id = dr["Id"].ToString();
toxicosis.Mapid = dr["Mapid"].ToString();
toxicosis.Standardcode = dr["Standardcode"].ToString();
toxicosis.Name = dr["Name"].ToString();
toxicosis.Py = dr["Py"].ToString();
toxicosis.Wb = dr["Wb"].ToString();
toxicosis.Valid = Convert.ToInt32(dr["Valid"].ToString());
toxicosis.Memo = dr["Memo"].ToString();
return(toxicosis);
}
/// <summary>
/// 保存损伤中毒库值
/// </summary>
/// <param name="diag"></param>
/// <returns></returns>
private bool SaveToxicosis(Toxicosis toxi)
{
try
{
string edittype = "";
if (m_EditState == EditState.Add)
{
edittype = "1";
}
else
{
edittype = "2";
}
m_SysTableManger.SaveToxicosis(toxi, edittype);
return(true);
}
catch (Exception e)
{
return(false);
}
}
/// <summary>
/// 根据损伤中毒库ID获取损伤中毒库实体信息
/// </summary>
/// <param name="templet_id"></param>
public Toxicosis GetToxicosis(string markId)
{
Toxicosis toxicosis = new Toxicosis();
DataTable dt = GetDiagnosisOfChinese_Table(markId);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
toxicosis.Id = dr["Id"].ToString();
toxicosis.Mapid = dr["Mapid"].ToString();
toxicosis.Standardcode = dr["Standardcode"].ToString();
toxicosis.Name = dr["Name"].ToString();
toxicosis.Name = dr["Name"].ToString();
toxicosis.Py = dr["Py"].ToString();
toxicosis.Wb = dr["Wb"].ToString();
toxicosis.Valid = Convert.ToInt32(dr["Valid"].ToString());
toxicosis.Memo = dr["Memo"].ToString();
}
return(toxicosis);
}
/// <summary>
/// 根据传入损伤中毒库实体删除对应数据
/// </summary>
/// <param name="Toxicosis"></param>
/// <returns></returns>
public bool DelToxicosis(Toxicosis toxicosis)
{
return(DelToxicosis(toxicosis.Id));
}
