/// <summary>
/// 获取符合检查类别、检查子类的检查类别记录
/// </summary>
/// <param name="EXAM_CLASS"></param>
/// <param name="EXAM_SUB_CLASS"></param>
/// <returns></returns>
public override IModel GetModel(string EXAM_CLASS, string EXAM_SUB_CLASS)
{
strSql = "select * from " + TableName + " where Exam_Class = '" + EXAM_CLASS + "' and EXAM_SUB_CLASS = '" + EXAM_SUB_CLASS + "'";
DataTable dt = GetDataTable(strSql);
if (dt.Rows.Count == 0)
{
return(null);
}
MExamClass examClass = new MExamClass();
examClass.EXAM_CLASS = dt.Rows[0]["EXAM_CLASS"].ToString();
examClass.EXAM_SUB_CLASS = dt.Rows[0]["EXAM_SUB_CLASS"].ToString();
examClass.DICOM_MODALITY = dt.Rows[0]["DICOM_MODALITY"].ToString();
examClass.LOCAL_ID_CLASS = dt.Rows[0]["LOCAL_ID_CLASS"].ToString();
examClass.PRINT_PATTERN_CLASS = dt.Rows[0]["PRINT_PATTERN_CLASS"].ToString();
examClass.DEVICE = dt.Rows[0]["DEVICE"].ToString();
if (dt.Rows[0]["SORT_ID"] == null || dt.Rows[0]["SORT_ID"].ToString() == "")
{
examClass.SORT_ID = null;
}
else
{
examClass.SORT_ID = int.Parse(dt.Rows[0]["SORT_ID"].ToString());
}
return(examClass);
}
/// <summary>
/// 获取指定检查类别名称、检查子类名称的检查类别记录
/// </summary>
/// <param name="EXAM_CLASS"></param>
/// <param name="EXAM_SUB_CLASS"></param>
/// <returns></returns>
public override IModel GetModel(string EXAM_CLASS, string EXAM_SUB_CLASS)
{
strSql = "select * from " + TableName + " where Exam_Class = '" + EXAM_CLASS + "' and EXAM_SUB_CLASS = '" + EXAM_SUB_CLASS + "'";
DataTable dt = GetDataTable(strSql);
if (dt.Rows.Count == 0)
{
return(null);
}
MExamClass examClass = new MExamClass();
examClass.EXAM_CLASS = dt.Rows[0]["EXAM_CLASS"].ToString();
examClass.EXAM_SUB_CLASS = dt.Rows[0]["EXAM_SUB_CLASS"].ToString();
examClass.DICOM_MODALITY = dt.Rows[0]["DICOM_MODALITY"].ToString();
examClass.LOCAL_ID_CLASS = dt.Rows[0]["LOCAL_ID_CLASS"].ToString();
examClass.TAG_IMAGE_NAME = dt.Rows[0]["TAG_IMAGE_NAME"].ToString();
examClass.DEVICE = dt.Rows[0]["DEVICE"].ToString();
if (dt.Rows[0]["SORT_ID"] == null)
{
examClass.SORT_ID = null;
}
else
{
examClass.SORT_ID = Convert.ToInt32(dt.Rows[0]["SORT_ID"].ToString());
}
return(examClass);
}
/// <summary>
/// 批量插入检查类别记录
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int AddMore(Hashtable ht2)
{
MExamClass examClass = new MExamClass();
Hashtable ht = new Hashtable();
Hashtable htstr = new Hashtable();
if (ht2.Count > 0)
{
for (int i = 0; i < ht2.Count; i++)
{
ht.Clear();
examClass = (MExamClass)ht2[i];
ht.Add("EXAM_CLASS", examClass.EXAM_CLASS);
ht.Add("EXAM_SUB_CLASS", examClass.EXAM_SUB_CLASS);
ht.Add("DICOM_MODALITY", examClass.DICOM_MODALITY);
ht.Add("LOCAL_ID_CLASS", examClass.LOCAL_ID_CLASS);
ht.Add("TAG_IMAGE_NAME", examClass.TAG_IMAGE_NAME);
ht.Add("DEVICE", examClass.DEVICE);
ht.Add("SORT_ID", examClass.SORT_ID);
htstr.Add(i, StringConstructor.InsertSql(TableName, ht).ToString());
}
return(ExecuteNonSql(htstr));
}
else
{
return(0);
}
}
/// <summary>
/// 查询是否存在指定的检查类别记录
/// </summary>
/// <param name="iexamClass"></param>
/// <returns></returns>
public override bool Exists(IModel iexamClass)
{
MExamClass examClass = (MExamClass)iexamClass;
strSql = "select * from " + TableName + " where EXAM_CLASS='" + examClass.EXAM_CLASS + "' and " +
"EXAM_SUB_CLASS = '" + examClass.EXAM_SUB_CLASS + "'";
return(recordIsExist(strSql));
}
/// <summary>
/// 插入一条检查类别记录
/// </summary>
/// <param name="iexamClass"></param>
/// <returns></returns>
public override int Add(IModel iexamClass)
{
MExamClass examClass = (MExamClass)iexamClass;
Hashtable ht = new Hashtable();
ht.Add("EXAM_CLASS", examClass.EXAM_CLASS);
ht.Add("EXAM_SUB_CLASS", examClass.EXAM_SUB_CLASS);
ht.Add("DICOM_MODALITY", examClass.DICOM_MODALITY);
ht.Add("LOCAL_ID_CLASS", examClass.LOCAL_ID_CLASS);
ht.Add("PRINT_PATTERN_CLASS", examClass.PRINT_PATTERN_CLASS);
ht.Add("DEVICE", examClass.DEVICE);
ht.Add("SORT_ID", examClass.SORT_ID);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
/// <summary>
/// 更新指定的检查类别记录
/// </summary>
/// <param name="iexamClass"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update(IModel iexamClass, string where)
{
MExamClass examClass = (MExamClass)iexamClass;
Hashtable ht = new Hashtable();
ht.Add("EXAM_CLASS", examClass.EXAM_CLASS);
ht.Add("EXAM_SUB_CLASS", examClass.EXAM_SUB_CLASS);
ht.Add("DICOM_MODALITY", examClass.DICOM_MODALITY);
ht.Add("LOCAL_ID_CLASS", examClass.LOCAL_ID_CLASS);
ht.Add("TAG_IMAGE_NAME", examClass.TAG_IMAGE_NAME);
ht.Add("DEVICE", examClass.DEVICE);
ht.Add("SORT_ID", examClass.SORT_ID);
return(ExecuteSql(StringConstructor.UpdateSql(TableName, ht, where).ToString()));
}
private void EditData()//批量修改
{
Hashtable htEdit = new Hashtable();
int r = 0;
if (htRow.Count > 0)
{
for (int k = 0; k < htRow.Count; k++)
{
r = Convert.ToInt32(htRow[k].ToString());
MExamClass MExamCla = new MExamClass();
if (!string.IsNullOrEmpty(dgv_ExamClass.Rows[r].Cells["EXAM_CLASS"].FormattedValue.ToString()))
{
MExamCla.EXAM_CLASS = dgv_ExamClass.Rows[r].Cells["EXAM_CLASS"].Value.ToString();
}
else
{
MessageBoxEx.Show("项目类别不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (!string.IsNullOrEmpty(dgv_ExamClass.Rows[r].Cells["EXAM_SUB_CLASS"].FormattedValue.ToString()))
{
MExamCla.EXAM_SUB_CLASS = dgv_ExamClass.Rows[r].Cells["EXAM_SUB_CLASS"].Value.ToString();
}
else
{
MessageBoxEx.Show("检查子类不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (!string.IsNullOrEmpty(dgv_ExamClass.Rows[r].Cells["DICOM_MODALITY"].FormattedValue.ToString()))
{
MExamCla.DICOM_MODALITY = dgv_ExamClass.Rows[r].Cells["DICOM_MODALITY"].Value.ToString();
}
if (!string.IsNullOrEmpty(dgv_ExamClass.Rows[r].Cells["LOCAL_ID_CLASS"].FormattedValue.ToString()))
{
MExamCla.LOCAL_ID_CLASS = dgv_ExamClass.Rows[r].Cells["LOCAL_ID_CLASS"].Value.ToString();
}
if (!string.IsNullOrEmpty(dgv_ExamClass.Rows[r].Cells["TAG_IMAGE_NAME"].FormattedValue.ToString()))
{
MExamCla.TAG_IMAGE_NAME = dgv_ExamClass.Rows[r].Cells["TAG_IMAGE_NAME"].Value.ToString();
}
if (!string.IsNullOrEmpty(dgv_ExamClass.Rows[r].Cells["DEVICE"].FormattedValue.ToString()))
{
MExamCla.DEVICE = dgv_ExamClass.Rows[r].Cells["DEVICE"].Value.ToString();
}
if (!string.IsNullOrEmpty(dgv_ExamClass.Rows[r].Cells["SORT_ID"].FormattedValue.ToString()))
{
MExamCla.SORT_ID = Convert.ToInt16(dgv_ExamClass.Rows[r].Cells["SORT_ID"].Value);
}
htEdit.Add(k, MExamCla);
}
if (BExamCla.UpdateMore(htEdit) >= 0)
{
MessageBoxEx.Show("修改成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBoxEx.Show("修改失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
htRow.Clear();
i = 0;
}
private void SaveData()//批量保存
{
Hashtable ht = new Hashtable();
if (dgv_ExamClass.Rows.Count > rowcount - 1) //说明有新增行
{
for (int i = rowcount, j = 0; i <= dgv_ExamClass.Rows.Count && j < dgv_ExamClass.Rows.Count; i++, j++) //从第rowcount个开始保存
{
MExamClass MExamCla = new MExamClass();
if (!string.IsNullOrEmpty(dgv_ExamClass.Rows[i - 1].Cells["EXAM_CLASS"].FormattedValue.ToString()))
{
MExamCla.EXAM_CLASS = dgv_ExamClass.Rows[i - 1].Cells["EXAM_CLASS"].Value.ToString();
}
else
{
MessageBoxEx.Show("项目类别不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (!string.IsNullOrEmpty(dgv_ExamClass.Rows[i - 1].Cells["EXAM_SUB_CLASS"].FormattedValue.ToString()))
{
MExamCla.EXAM_SUB_CLASS = dgv_ExamClass.Rows[i - 1].Cells["EXAM_SUB_CLASS"].Value.ToString();
}
else
{
MessageBoxEx.Show("检查子类不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (!string.IsNullOrEmpty(dgv_ExamClass.Rows[i - 1].Cells["DICOM_MODALITY"].FormattedValue.ToString()))
{
MExamCla.DICOM_MODALITY = dgv_ExamClass.Rows[i - 1].Cells["DICOM_MODALITY"].Value.ToString();
}
if (!string.IsNullOrEmpty(dgv_ExamClass.Rows[i - 1].Cells["LOCAL_ID_CLASS"].FormattedValue.ToString()))
{
MExamCla.LOCAL_ID_CLASS = dgv_ExamClass.Rows[i - 1].Cells["LOCAL_ID_CLASS"].Value.ToString();
}
if (!string.IsNullOrEmpty(dgv_ExamClass.Rows[i - 1].Cells["TAG_IMAGE_NAME"].FormattedValue.ToString()))
{
MExamCla.TAG_IMAGE_NAME = dgv_ExamClass.Rows[i - 1].Cells["TAG_IMAGE_NAME"].Value.ToString();
}
if (!string.IsNullOrEmpty(dgv_ExamClass.Rows[i - 1].Cells["DEVICE"].FormattedValue.ToString()))
{
MExamCla.DEVICE = dgv_ExamClass.Rows[i - 1].Cells["DEVICE"].Value.ToString();
}
if (!string.IsNullOrEmpty(dgv_ExamClass.Rows[i - 1].Cells["SORT_ID"].FormattedValue.ToString()))
{
MExamCla.SORT_ID = Convert.ToInt16(dgv_ExamClass.Rows[i - 1].Cells["SORT_ID"].Value);
}
bool BL = BExamCla.Exists(MExamCla);
if (BL)
{
MessageBoxEx.Show("存在相同的检查类别和子类！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
ht.Add(j, MExamCla);
}
}
if (ht.Count > 0)
{
if (BExamCla.AddMore(ht) > 0)
{
MessageBoxEx.Show("添加成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBoxEx.Show("添加失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
