/// <summary> /// 查询指定的收费项目字典记录 /// </summary> /// <param name="ichargeItemClassDict"></param> /// <returns></returns> public override bool Exists(IModel ichargeItemClassDict) { MChargeItemClassDict chargeItemClassDict = (MChargeItemClassDict)ichargeItemClassDict; strSql = "select * from " + TableName + " where CLASS_CODE='" + chargeItemClassDict.CLASS_CODE + "'"; return(recordIsExist(strSql)); }
private bool SaveData() { Hashtable ht = new Hashtable(); if (dgv_ChargeItemClassDict.Rows.Count > RowCount - 1) //说明有新增行 { for (int i = RowCount, j = 0; i <= dgv_ChargeItemClassDict.Rows.Count && j < dgv_ChargeItemClassDict.Rows.Count; i++, j++) //从第rowcount个开始保存 { MChargeItemClassDict MchgItmClsDit = new MChargeItemClassDict(); MchgItmClsDit.CLASS_CODE = dgv_ChargeItemClassDict.Rows[i - 1].Cells["CLASS_CODE"].Value.ToString().Trim(); MchgItmClsDit.CLASS_NAME = dgv_ChargeItemClassDict.Rows[i - 1].Cells["CLASS_NAME"].Value.ToString().Trim(); ht.Add(j, MchgItmClsDit); } } if (ht.Count > 0) { if (BChgItmClsDit.AddMore(ht) > 0) { MessageBoxEx.Show("添加成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return(true); } else { MessageBoxEx.Show("添加失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } } else { return(false); } }
/// <summary> /// 更新指定的收费项目字典记录 /// </summary> /// <param name="ichargeItemClassDict"></param> /// <param name="where"></param> /// <returns></returns> public override int Update(IModel ichargeItemClassDict, string where) { MChargeItemClassDict chargeItemClassDict = (MChargeItemClassDict)ichargeItemClassDict; Hashtable ht = new Hashtable(); ht.Add("CLASS_CODE", chargeItemClassDict.CLASS_CODE); ht.Add("CLASS_NAME", chargeItemClassDict.CLASS_NAME); return(ExecuteSql(StringConstructor.UpdateSql(TableName, ht, where).ToString())); }
/// <summary> /// 获取一条符合条件的收费项目分类字典记录 /// </summary> /// <param name="classCode"></param> /// <returns></returns> public override IModel GetModel(string classCode) { strSql = "select * from " + TableName + " where CLASS_CODE='" + classCode + "'"; DataTable dt = GetDataTable(strSql); if (dt.Rows.Count == 0) { return(null); } MChargeItemClassDict chargeItemClassDict = new MChargeItemClassDict(); chargeItemClassDict.CLASS_CODE = dt.Rows[0]["CLASS_CODE"].ToString(); chargeItemClassDict.CLASS_NAME = dt.Rows[0]["CLASS_NAME"].ToString(); return(chargeItemClassDict); }
/// <summary> /// 批量更新收费分类记录 /// </summary> /// <param name="ht2"></param> /// <returns></returns> public override int UpdateMore(Hashtable ht2) { MChargeItemClassDict chargeItemClassDict = new MChargeItemClassDict(); Hashtable ht = new Hashtable(); Hashtable htStr = new Hashtable(); if (ht2.Count > 0) { for (int i = 0; i < ht2.Count; i++) { ht.Clear(); chargeItemClassDict = (MChargeItemClassDict)ht2[i]; ht.Add("CLASS_CODE", chargeItemClassDict.CLASS_CODE); ht.Add("CLASS_NAME", chargeItemClassDict.CLASS_NAME); htStr.Add(i, StringConstructor.UpdateSql(TableName, ht, " where CLASS_CODE='" + chargeItemClassDict.CLASS_CODE + "'")); } return(ExecuteNonSql(htStr)); } return(0); }
/// <summary> /// 批量插入收费分类记录 /// </summary> /// <param name="ht2"></param> /// <returns></returns> public override int AddMore(Hashtable ht2) { MChargeItemClassDict chargeItemClassDict = new MChargeItemClassDict(); Hashtable ht = new Hashtable(); Hashtable htstr = new Hashtable(); if (ht2.Count > 0) { for (int i = 0; i < ht2.Count; i++) { ht.Clear(); chargeItemClassDict = (MChargeItemClassDict)ht2[i]; ht.Add("CLASS_CODE", chargeItemClassDict.CLASS_CODE); ht.Add("CLASS_NAME", chargeItemClassDict.CLASS_NAME); htstr.Add(i, StringConstructor.InsertSql(TableName, ht).ToString()); } return(ExecuteNonSql(htstr)); } else { return(0); } }
/// <summary> /// 批量修改 /// </summary> private bool EditData() { Hashtable htEdit = new Hashtable(); int k = 0; if (htRow.Count > 0) { foreach (DictionaryEntry myDE in htRow) { int r = Convert.ToInt32(myDE.Value); MChargeItemClassDict MchgItmClsDit = new MChargeItemClassDict(); MchgItmClsDit.CLASS_CODE = dgv_ChargeItemClassDict.Rows[r].Cells["CLASS_CODE"].Value.ToString().Trim(); MchgItmClsDit.CLASS_NAME = dgv_ChargeItemClassDict.Rows[r].Cells["CLASS_NAME"].Value.ToString().Trim(); htEdit.Add(k, MchgItmClsDit); k += 1; } htRow.Clear(); i = 0; if (BChgItmClsDit.UpdateMore(htEdit) >= 0) { MessageBoxEx.Show("修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return(true); } else { MessageBoxEx.Show("修改失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } } else { return(false); } }