/// <summary> /// 获取指定检查项目代码、检查项目子类的检查项目记录 /// </summary> /// <param name="EXAM_ITEM_CODE"></param> /// <param name="EXAM_SUB_CLASS"></param> /// <returns></returns> public override IModel GetModel(string EXAM_ITEM_CODE, string EXAM_SUB_CLASS) { strSql = "select * from " + TableName + " where EXAM_ITEM_CODE = '" + EXAM_ITEM_CODE + "' and EXAM_SUB_CLASS = '" + EXAM_SUB_CLASS + "'"; DataTable dt = GetDataTable(strSql); if (dt.Rows.Count == 0) { return(null); } MExamItemDict examItemDict = new MExamItemDict(); examItemDict.EXAM_ITEM_CODE = dt.Rows[0]["EXAM_ITEM_CODE"].ToString(); examItemDict.EXAM_ITEM_NAME = dt.Rows[0]["EXAM_ITEM_NAME"].ToString(); examItemDict.INPUT_CODE = dt.Rows[0]["INPUT_CODE"].ToString(); examItemDict.EXAM_CLASS = dt.Rows[0]["EXAM_CLASS"].ToString(); examItemDict.EXAM_SUB_CLASS = dt.Rows[0]["EXAM_SUB_CLASS"].ToString(); if (dt.Rows[0]["SORT_ID"].ToString() == "") { examItemDict.SORT_ID = null; } else { examItemDict.SORT_ID = Convert.ToInt32(dt.Rows[0]["SORT_ID"].ToString()); } return(examItemDict); }
/// <summary> /// 批量插入检查项目记录 /// </summary> /// <param name="ht2"></param> /// <returns></returns> public override int AddMore(Hashtable ht2) { MExamItemDict examItemDict = new MExamItemDict(); Hashtable ht = new Hashtable(); Hashtable htstr = new Hashtable(); if (ht2.Count > 0) { for (int i = 0; i < ht2.Count; i++) { ht.Clear(); examItemDict = (MExamItemDict)ht2[i]; ht.Add("EXAM_ITEM_CODE", examItemDict.EXAM_ITEM_CODE); ht.Add("EXAM_ITEM_NAME", examItemDict.EXAM_ITEM_NAME); ht.Add("INPUT_CODE", examItemDict.INPUT_CODE); ht.Add("EXAM_CLASS", examItemDict.EXAM_CLASS); ht.Add("EXAM_SUB_CLASS", examItemDict.EXAM_SUB_CLASS); ht.Add("SORT_ID", examItemDict.SORT_ID); htstr.Add(i, StringConstructor.InsertSql(TableName, ht).ToString()); } return(ExecuteNonSql(htstr)); } else { return(0); } }
/// <summary> /// 批量更新检查项目记录 /// </summary> /// <param name="ht2"></param> /// <returns></returns> public override int UpdateMore(Hashtable ht2) { MExamItemDict examItemDict = new MExamItemDict(); Hashtable htStr = new Hashtable(); Hashtable ht = new Hashtable(); if (ht2.Count > 0) { for (int i = 0; i < ht2.Count; i++) { ht.Clear(); examItemDict = (MExamItemDict)ht2[i]; ht.Add("EXAM_ITEM_CODE", examItemDict.EXAM_ITEM_CODE); ht.Add("EXAM_ITEM_NAME", examItemDict.EXAM_ITEM_NAME); ht.Add("INPUT_CODE", examItemDict.INPUT_CODE); ht.Add("EXAM_CLASS", examItemDict.EXAM_CLASS); ht.Add("EXAM_SUB_CLASS", examItemDict.EXAM_SUB_CLASS); ht.Add("SORT_ID", examItemDict.SORT_ID); htStr.Add(i, StringConstructor.UpdateSql(TableName, ht, " where EXAM_ITEM_CODE = '" + examItemDict.EXAM_ITEM_CODE + "' and EXAM_SUB_CLASS = '" + examItemDict.EXAM_SUB_CLASS + "'")); } return(ExecuteNonSql(htStr)); } return(0); }
/// <summary> /// 查询是否存在指定的检查项目记录 /// </summary> /// <param name="iexamItemDict"></param> /// <returns></returns> public override bool Exists(IModel iexamItemDict) { MExamItemDict examItemDict = (MExamItemDict)iexamItemDict; strSql = "select * from " + TableName + " where EXAM_ITEM_CODE='" + examItemDict.EXAM_ITEM_CODE + "' and " + "EXAM_SUB_CLASS = '" + examItemDict.EXAM_SUB_CLASS + "'"; return(recordIsExist(strSql)); }
/// <summary> /// 插入一条检查项目记录 /// </summary> /// <param name="iexamItemDict"></param> /// <returns></returns> public override int Add(IModel iexamItemDict) { MExamItemDict examItemDict = (MExamItemDict)iexamItemDict; Hashtable ht = new Hashtable(); ht.Add("EXAM_ITEM_CODE", examItemDict.EXAM_ITEM_CODE); ht.Add("EXAM_ITEM_NAME", examItemDict.EXAM_ITEM_NAME); ht.Add("INPUT_CODE", examItemDict.INPUT_CODE); ht.Add("EXAM_CLASS", examItemDict.EXAM_CLASS); ht.Add("EXAM_SUB_CLASS", examItemDict.EXAM_SUB_CLASS); ht.Add("SORT_ID", examItemDict.SORT_ID); return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString())); }
private bool 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()); if (r >= dgv_ExamItem.Rows.Count) { continue; } MExamItemDict MExamItemDi = new MExamItemDict(); if (!string.IsNullOrEmpty(dgv_ExamItem.Rows[r].Cells["EXAM_ITEM_CODE"].FormattedValue.ToString())) { MExamItemDi.EXAM_ITEM_CODE = dgv_ExamItem.Rows[r].Cells["EXAM_ITEM_CODE"].Value.ToString(); } else { MessageBoxEx.Show("项目代码不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } if (!string.IsNullOrEmpty(dgv_ExamItem.Rows[r].Cells["EXAM_SUB_CLASS"].FormattedValue.ToString())) { MExamItemDi.EXAM_SUB_CLASS = dgv_ExamItem.Rows[r].Cells["EXAM_SUB_CLASS"].Value.ToString(); } else { MessageBoxEx.Show("检查子类不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } if (!string.IsNullOrEmpty(dgv_ExamItem.Rows[r].Cells["EXAM_ITEM_NAME"].FormattedValue.ToString())) { MExamItemDi.EXAM_ITEM_NAME = dgv_ExamItem.Rows[r].Cells["EXAM_ITEM_NAME"].Value.ToString(); } if (!string.IsNullOrEmpty(dgv_ExamItem.Rows[r].Cells["INPUT_CODE"].FormattedValue.ToString())) { MExamItemDi.INPUT_CODE = dgv_ExamItem.Rows[r].Cells["INPUT_CODE"].Value.ToString(); } if (!string.IsNullOrEmpty(dgv_ExamItem.Rows[r].Cells["EXAM_CLASS"].FormattedValue.ToString())) { MExamItemDi.EXAM_CLASS = dgv_ExamItem.Rows[r].Cells["EXAM_CLASS"].Value.ToString(); } else { MessageBoxEx.Show("检查类别不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } if (!string.IsNullOrEmpty(dgv_ExamItem.Rows[r].Cells["SORT_ID"].FormattedValue.ToString())) { MExamItemDi.SORT_ID = Convert.ToInt32(dgv_ExamItem.Rows[r].Cells["SORT_ID"].Value.ToString()); } htEdit.Add(k, MExamItemDi); } if (BExamItemDi.UpdateMore(htEdit) >= 0) { MessageBoxEx.Show("修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBoxEx.Show("修改失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } } htRow.Clear(); i = 0; return(true); }
private bool SaveData()//批量保存 { Hashtable ht = new Hashtable(); if (dgv_ExamItem.Rows.Count > rowcount - 1) //说明有新增行 { for (int i = rowcount, j = 0; i <= dgv_ExamItem.Rows.Count && j < dgv_ExamItem.Rows.Count; i++, j++) //从第rowcount个开始保存 { MExamItemDict MExamItemDi = new MExamItemDict(); if (!string.IsNullOrEmpty(dgv_ExamItem.Rows[i - 1].Cells["EXAM_ITEM_CODE"].FormattedValue.ToString())) { MExamItemDi.EXAM_ITEM_CODE = dgv_ExamItem.Rows[i - 1].Cells["EXAM_ITEM_CODE"].Value.ToString(); } else { MessageBoxEx.Show("项目代码不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } if (!string.IsNullOrEmpty(dgv_ExamItem.Rows[i - 1].Cells["EXAM_SUB_CLASS"].FormattedValue.ToString())) { MExamItemDi.EXAM_SUB_CLASS = dgv_ExamItem.Rows[i - 1].Cells["EXAM_SUB_CLASS"].Value.ToString(); } else { MessageBoxEx.Show("检查子类不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } if (!string.IsNullOrEmpty(dgv_ExamItem.Rows[i - 1].Cells["EXAM_ITEM_NAME"].FormattedValue.ToString())) { MExamItemDi.EXAM_ITEM_NAME = dgv_ExamItem.Rows[i - 1].Cells["EXAM_ITEM_NAME"].Value.ToString(); } if (!string.IsNullOrEmpty(dgv_ExamItem.Rows[i - 1].Cells["INPUT_CODE"].FormattedValue.ToString())) { MExamItemDi.INPUT_CODE = dgv_ExamItem.Rows[i - 1].Cells["INPUT_CODE"].Value.ToString(); } if (!string.IsNullOrEmpty(dgv_ExamItem.Rows[i - 1].Cells["EXAM_CLASS"].FormattedValue.ToString())) { MExamItemDi.EXAM_CLASS = dgv_ExamItem.Rows[i - 1].Cells["EXAM_CLASS"].Value.ToString(); } else { MessageBoxEx.Show("检查类别不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } if (!string.IsNullOrEmpty(dgv_ExamItem.Rows[i - 1].Cells["SORT_ID"].FormattedValue.ToString())) { MExamItemDi.SORT_ID = Convert.ToInt32(dgv_ExamItem.Rows[i - 1].Cells["SORT_ID"].Value.ToString()); } bool bl = BExamItemDi.Exists(MExamItemDi); if (bl) { MessageBoxEx.Show("存在相同的项目代码、检查类别和检查子类!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } ht.Add(j, MExamItemDi); } } if (ht.Count > 0) { if (BExamItemDi.AddMore(ht) > 0) { MessageBoxEx.Show("添加成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBoxEx.Show("添加失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } } return(true); }