/// <summary> /// 查询是否存在指定的行政区记录 /// </summary> /// <param name="iarea"></param> /// <returns></returns> public override bool Exists(IModel iarea) { MAreaDict area = (MAreaDict)iarea; strSql = "select * from " + TableName + " where AREA_CODE='" + area.AREA_CODE + "'"; return(recordIsExist(strSql)); }
/// <summary> /// 更新指定的行政区记录 /// </summary> /// <param name="iarea"></param> /// <param name="where"></param> /// <returns></returns> public override int Update(IModel iarea, string where) { MAreaDict area = (MAreaDict)iarea; Hashtable ht = new Hashtable(); ht.Add("AREA_CODE", area.AREA_CODE); ht.Add("AREA_NAME", area.AREA_NAME); ht.Add("INPUT_CODE", area.INPUT_CODE); return(ExecuteSql(StringConstructor.UpdateSql(TableName, ht, where).ToString())); }
/// <summary> /// 获取指定行政区代码的行政区记录 /// </summary> /// <param name="areaCode"></param> /// <returns></returns> public override IModel GetModel(string areaCode) { strSql = "select * from " + TableName + " where AREA_CODE='" + areaCode + "'"; DataTable dt = GetDataTable(strSql); if (dt.Rows.Count == 0) { return(null); } MAreaDict area = new MAreaDict(); area.AREA_CODE = dt.Rows[0]["AREA_CODE"].ToString(); area.AREA_NAME = dt.Rows[0]["AREA_NAME"].ToString(); area.INPUT_CODE = dt.Rows[0]["INPUT_CODE"].ToString(); return(area); }