/// <summary>
/// 操作病案首页评分标准表
/// </summary>
/// <returns>iem_mainpage_qc首页评分标准表</returns>
public static DataTable OperIemMainPageQC(IemMainpageQC qc, OperType opertype)
{
SqlParameter[] sqlParam = new SqlParameter[]
{
new SqlParameter("@OPERTYPE", SqlDbType.VarChar),
new SqlParameter("@ID", SqlDbType.VarChar),
new SqlParameter("@TABLETYPE", SqlDbType.VarChar),
new SqlParameter("@FIELDS", SqlDbType.VarChar),
new SqlParameter("@FIELDSVALUE", SqlDbType.VarChar),
new SqlParameter("@CONDITIONTABLETYPE", SqlDbType.VarChar),
new SqlParameter("@CONDITIONFIELDS", SqlDbType.VarChar),
new SqlParameter("@CONDITIONFIELDSVALUE", SqlDbType.VarChar),
new SqlParameter("@REDUCTSCORE", SqlDbType.VarChar),
new SqlParameter("@REDUCTREASON", SqlDbType.VarChar),
new SqlParameter("@VALIDE", SqlDbType.VarChar)
};
sqlParam[0].Value = ((int)opertype).ToString();
sqlParam[1].Value = qc.ID;
sqlParam[2].Value = qc.TableType;
sqlParam[3].Value = qc.Fields;
sqlParam[4].Value = qc.FieldsValue;
sqlParam[5].Value = qc.ConditionTableType;
sqlParam[6].Value = qc.ConditionFields;
sqlParam[7].Value = qc.ConditionValues;
sqlParam[8].Value = qc.ReductScore.ToString();
sqlParam[9].Value = qc.ReductReason;
sqlParam[10].Value = qc.Valide.ToString();
return(m_SqlHelper.ExecuteDataTable("iem_main_page.usp_operiem_mainpage_qc", sqlParam, CommandType.StoredProcedure));
}
/// <summary>
/// 删除 edit by 王冀 2012 12 19
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDel_Click(object sender, EventArgs e)
{
try
{
if (DialogResult.OK == m_app.CustomMessageBox.MessageShow("确定要删除标准？", DrectSoft.Core.CustomMessageBoxKind.QuestionOkCancel))
{
if (this.textEditID.Text == "")
{
m_app.CustomMessageBox.MessageShow("请选择一条删除标准");
return;
}
m_opertype = OperType.DEL;
this.FreshOperView();
IemMainpageQC qc = this.GetQCFromView();
if (qc == null)
{
return;
}
DataAccess.OperIemMainPageQC(qc, m_opertype);
//DataTable dtMainpageQC = DataAccess.OperIemMainPageQC(qc, OperType.QUERY);
//this.gridControlConfig.DataSource = dtMainpageQC;
m_app.CustomMessageBox.MessageShow("删除成功");
m_opertype = OperType.QUERY;
this.FreshOperView();
refreshData();
}
}
catch (Exception ex)
{
m_app.CustomMessageBox.MessageShow(ex.Message);
}
}
/// <summary>
/// 保存 edit by 王冀 2012 12 19
/// Modify by xlb 2013-06-18
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (m_opertype == OperType.ADD)
{
qc = this.GetQCFromView();
if (qc == null)
{
return;
}
qc.ID = Guid.NewGuid().ToString().Substring(16, 16);
DataAccess.OperIemMainPageQC(qc, m_opertype);
m_app.CustomMessageBox.MessageShow("新增成功");
m_opertype = OperType.QUERY;
this.FreshOperView();
refreshData();
}
else if (m_opertype == OperType.EDIT)
{
int rh = gViewConfig.FocusedRowHandle;
qc = this.GetQCFromView();
if (qc == null)
{
return;
}
DataAccess.OperIemMainPageQC(qc, m_opertype);
m_app.CustomMessageBox.MessageShow("修改成功");
m_opertype = OperType.QUERY;
this.FreshOperView();
refreshData();
gViewConfig.FocusedRowHandle = rh;
}
}
catch (Exception ex)
{
m_app.CustomMessageBox.MessageShow(ex.Message);
}
}
/// <summary>
/// 将编辑区的值传给实体 edit by 王冀 2012 12 19
/// </summary>
/// <returns></returns>
private IemMainpageQC GetQCFromView()
{
try
{
if (comboBoxEditTableType.SelectedIndex == -1)
{
m_app.CustomMessageBox.MessageShow("表类型不能为空");
this.comboBoxEditTableType.Focus();
return(null);
}
if (textEditFields.Text.Trim() == "")
{
m_app.CustomMessageBox.MessageShow("校验字段不能为空");
this.textEditFields.Focus();
return(null);
}
if (rbValues.Checked && this.textEditValues.Text.Trim() == "")
{
m_app.CustomMessageBox.MessageShow("校验值不能为空");
this.textEditValues.Focus();
return(null);
}
if (chkHaveCondition.Checked)
{
if (comboBoxEditConditionTable.SelectedIndex == -1)
{
m_app.CustomMessageBox.MessageShow("条件表类型不能为空");
this.comboBoxEditConditionTable.Focus();
return(null);
}
if (textEditConditionFields.Text.Trim() == "")
{
m_app.CustomMessageBox.MessageShow("条件校验字段不能为空");
this.textEditConditionFields.Focus();
return(null);
}
if (rbConditionValues.Checked && this.textEditConditionValues.Text.Trim() == "")
{
m_app.CustomMessageBox.MessageShow("条件值不能为空");
this.textEditConditionValues.Focus();
return(null);
}
}
if (textEditReductScore.Text.Trim() == "")
{
m_app.CustomMessageBox.MessageShow("扣分值不能为空");
this.textEditReductScore.Focus();
return(null);
}
if (textEditReductReason.Text.Trim() == "")
{
m_app.CustomMessageBox.MessageShow("扣分原因不能为空");
this.textEditReductReason.Focus();
return(null);
}
if (this.cmbValid.SelectedIndex == -1)
{
m_app.CustomMessageBox.MessageShow("有效性不能为空");
this.cmbValid.Focus();
return(null);
}
IemMainpageQC qc = new IemMainpageQC();
qc.ID = textEditID.Text.Trim();
qc.TableType = comboBoxEditTableType.SelectedIndex.ToString();
qc.Fields = textEditFields.Text.Trim();
if (rbNotNull.Checked)
{
qc.FieldsValue = "不为空";
}
else
{
qc.FieldsValue = textEditValues.Text.Trim();
}
if (chkHaveCondition.Checked)
{
qc.ConditionTableType = comboBoxEditTableType.SelectedIndex.ToString();
qc.ConditionFields = textEditConditionFields.Text.Trim();
if (rbConditionNotNull.Checked)
{
qc.ConditionValues = "不为空";
}
else
{
qc.ConditionValues = textEditConditionValues.Text.Trim();
}
}
try
{
qc.ReductScore = float.Parse(textEditReductScore.Text.Trim());
}
catch (Exception)
{
m_app.CustomMessageBox.MessageShow("分数为无效数字");
this.textEditReductScore.Focus();
return(null);
}
qc.ReductReason = textEditReductReason.Text.Trim();
qc.Valide = cmbValid.SelectedIndex;
return(qc);
}
catch (Exception)
{
return(null);
throw;
}
}