/// <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);
}