/// <summary>
/// 将页面值加到实体里
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private EmrReplaceItem SetEntityByPage()
{
EmrReplaceItem emrReplaceItem = new EmrReplaceItem();
emrReplaceItem.Id = txtId.Text.Trim();
emrReplaceItem.DestEmrName = txtDestEmrName.Text.Trim();
emrReplaceItem.DestItemName = txtDestItemName.Text.Trim();
emrReplaceItem.SourceItemName = txtSourceItemName.Text.Trim();
emrReplaceItem.SourceEmrName = txtSourceEmrName.Text.Trim();
emrReplaceItem.Valid = cmbValid.SelectedIndex;
return(emrReplaceItem);
}
/// <summary>
/// 将实体值赋给页面元素
/// </summary>
/// <param name="emrReplaceItem"></param>
private void SetPageValue(EmrReplaceItem emrReplaceItem)
{
if (emrReplaceItem == null || emrReplaceItem.Id == "")
{
return;
}
txtId.Text = emrReplaceItem.Id.Trim();
txtDestEmrName.Text = emrReplaceItem.DestEmrName.Trim();
txtDestItemName.Text = emrReplaceItem.DestItemName.Trim();
txtSourceEmrName.Text = emrReplaceItem.SourceEmrName.Trim();
txtSourceItemName.Text = emrReplaceItem.SourceItemName.Trim();
cmbValid.SelectedIndex = emrReplaceItem.Valid;
}
/// <summary>
/// 将grid中的值赋值给实体
/// </summary>
/// <param name="foucesRow"></param>
/// <returns></returns>
private EmrReplaceItem SetEntityByDataRow(DataRow dr)
{
if (dr == null)
{
return(null);
}
EmrReplaceItem emrReplaceItem = new EmrReplaceItem();
emrReplaceItem.Id = dr["id"].ToString();
emrReplaceItem.DestEmrName = dr["Dest_EmrName"].ToString();
emrReplaceItem.DestItemName = dr["Dest_ItemName"].ToString();
emrReplaceItem.SourceItemName = dr["Source_ItemName"].ToString();
emrReplaceItem.SourceEmrName = dr["Source_EmrName"].ToString();
emrReplaceItem.Valid = Convert.ToInt32(dr["Valid"].ToString());
return(emrReplaceItem);
}
/// <summary>
/// 进行保存操作
/// </summary>
/// <param name="emrReplaceItem"></param>
/// <returns></returns>
private bool SaveEmrItem(EmrReplaceItem emrItem)
{
try
{
string edittype = "";
if (m_EditState == EditState.Add)
{
edittype = "1";
}
else
{
edittype = "2";
}
m_SysTableManger.SaveEmrItem(emrItem, edittype);
return(true);
}
catch (Exception e)
{
return(false);
}
}
/// <summary>
/// 保存更新或者新增的值
/// </summary>
/// <param name="emrReplaceItem"></param>
/// <param name="edittype"></param>
public string SaveEmrItem(EmrReplaceItem emrReplaceItem, string edittype)
{
SqlParameter[] sqlParam = new SqlParameter[]
{
new SqlParameter("@EditType", SqlDbType.VarChar),
new SqlParameter("@ModelId", SqlDbType.VarChar),
new SqlParameter("@DestEmrName", SqlDbType.VarChar),
new SqlParameter("@SourceEmrName", SqlDbType.VarChar),
new SqlParameter("@DestItemName", SqlDbType.VarChar),
new SqlParameter("@SourceItemName", SqlDbType.VarChar),
new SqlParameter("@Valid", SqlDbType.Int)
};
sqlParam[0].Value = edittype;
sqlParam[1].Value = emrReplaceItem.Id;
sqlParam[2].Value = emrReplaceItem.DestEmrName;
sqlParam[3].Value = emrReplaceItem.SourceEmrName;
sqlParam[4].Value = emrReplaceItem.DestItemName;
sqlParam[5].Value = emrReplaceItem.SourceItemName;
sqlParam[6].Value = emrReplaceItem.Valid;
return(m_app.SqlHelper.ExecuteDataSet("EmrSysTable.usp_Edit_ModelEmr", sqlParam, CommandType.StoredProcedure).Tables[0].Rows[0][0].ToString());
}
