/// <summary>
/// 根据行政区划码取名称下拉框
/// </summary>
/// <param name="sw">查询模型</param>
/// <param name="code">编码</param>
/// <param name="name">名称</param>
/// <returns></returns>
public static string getSelectOptionBYWeather(T_ALL_AREA_SW sw, out string code, out string name)
{
code = "";
name = "";
StringBuilder sb = new StringBuilder();
DataTable dt = BaseDT.T_ALL_AREA.getDT(sw);
if (dt.Rows.Count > 0)
{
code = dt.Rows[0]["AREACODE"].ToString();
name = dt.Rows[0]["AREANAME"].ToString();
for (int i = 0; i < dt.Rows.Count; i++)
{
string areaCode = dt.Rows[i]["AREACODE"].ToString();
string areaName = dt.Rows[i]["AREANAME"].ToString();
if (sw.CurAREACODE == areaCode)
{
code = dt.Rows[i]["AREACODE"].ToString();
name = dt.Rows[i]["AREANAME"].ToString();
sb.AppendFormat("<option value=\"{0}\" selected = \"selected\" >{1}</option>", areaCode, areaName);
}
else
{
sb.AppendFormat("<option value=\"{0}\" >{1}</option>", areaCode, areaName);
}
}
}
dt.Clear();
dt.Dispose();
return(sb.ToString());
}
/// <summary>
/// 判断记录是否存在
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>true存在 false不存在 </returns>
public static bool isExists(T_ALL_AREA_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("select 1 from T_ALL_AREA where 1=1");
if (string.IsNullOrEmpty(sw.AREACODE) == false)
{
sb.AppendFormat(" and AREACODE='{0}'", ClsSql.EncodeSql(sw.AREACODE));
}
return(DataBaseClass.JudgeRecordExists(sb.ToString()));
}
/// <summary>
/// 根据编号获取区划名称
/// </summary>
/// <param name="sw">参见条件模型T_ALL_AREA_SW</param>
/// <returns>区划名称</returns>
public static string getNameByID(T_ALL_AREA_SW sw)
{
DataTable dt = BaseDT.T_ALL_AREA.getDT(sw);
string str = "";
if (dt != null)
{
if (dt.Rows.Count > 0)
{
str = dt.Rows[0]["AREANAME"].ToString();
}
}
dt.Clear();
dt.Dispose();
return(str);
}
/// <summary>
///行政区划下拉框
/// </summary>
/// <param name="sw">参见条件模型T_ALL_AREA_SW</param>
/// <returns>返回下拉框<code><option></option></code></returns>
public static string getAREANAMESelectOption(T_ALL_AREA_SW sw)
{
StringBuilder sb = new StringBuilder();
DataTable dt = BaseDT.T_ALL_AREA.getDT();
for (int i = 0; i < dt.Rows.Count; i++)
{
string AREACODE = dt.Rows[i]["AREACODE"].ToString();
string AREANAME = dt.Rows[i]["AREANAME"].ToString();
if (AREACODE.Substring(2, 13) == "0000000000000")
{
AREANAME = "" + AREANAME;
}
if (AREACODE.Substring(4, 11) == "00000000000")//获取所有市的
{
AREANAME = "-" + AREANAME;
}
else if (AREACODE.Substring(6, 9) == "000000000")//获取所有县的
{
AREANAME = "--" + AREANAME;
}
else if (AREACODE.Substring(9, 6) == "000000")//获取所有乡镇的
{
AREANAME = "----" + AREANAME;
}
else
{
AREANAME = "------" + AREANAME;
}
if (sw.CurAREACODE == AREACODE)//判断是否有需要默认选中的项
{
sb.AppendFormat("<option value=\"{0}\" selected>{1}</option>", AREACODE, AREANAME);
}
else
{
sb.AppendFormat("<option value=\"{0}\">{1}</option>", AREACODE, AREANAME);
}
}
dt.Clear();
dt.Dispose();
return(sb.ToString());
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="sw">参见条件模型T_ALL_AREA_SW</param>
/// <returns>参见模型T_ALL_AREA_Model</returns>
public static IEnumerable <T_ALL_AREA_Model> getListModel(T_ALL_AREA_SW sw)
{
var result = new List <T_ALL_AREA_Model>();
DataTable dt = BaseDT.T_ALL_AREA.getDT(sw);
for (int i = 0; i < dt.Rows.Count; i++)
{
T_ALL_AREA_Model m = new T_ALL_AREA_Model();
m.AREACODE = dt.Rows[i]["AREACODE"].ToString();
m.AREAID = dt.Rows[i]["AREAID"].ToString();
m.AREANAME = dt.Rows[i]["AREANAME"].ToString();
m.AREAJC = dt.Rows[i]["AREAJC"].ToString();
m.JD = dt.Rows[i]["JD"].ToString();
m.WD = dt.Rows[i]["WD"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 获取单条记录
/// </summary>
/// <param name="sw">参见条件模型T_ALL_AREA_SW</param>
/// <returns>参见模型T_ALL_AREA_Model</returns>
public static T_ALL_AREA_Model getModel(T_ALL_AREA_SW sw)
{
DataTable dt = BaseDT.T_ALL_AREA.getDT(sw);
T_ALL_AREA_Model m = new T_ALL_AREA_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
//数据库表字段
m.AREAID = dt.Rows[i]["AREAID"].ToString();
m.AREACODE = dt.Rows[i]["AREACODE"].ToString();
m.AREANAME = dt.Rows[i]["AREANAME"].ToString();
m.AREAJC = dt.Rows[i]["AREAJC"].ToString();
m.JD = dt.Rows[i]["JD"].ToString();
m.WD = dt.Rows[i]["WD"].ToString();
//扩充字段
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static DataTable getDT(T_ALL_AREA_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT AREAID, AREACODE, AREANAME, AREAJC, JD, WD");
sb.AppendFormat(" FROM T_ALL_AREA");
sb.AppendFormat(" WHERE 1=1");
if (string.IsNullOrEmpty(sw.AREAID) == false)
{
sb.AppendFormat(" AND AREAID = '{0}'", ClsSql.EncodeSql(sw.AREAID));
}
if (string.IsNullOrEmpty(sw.AREACODE) == false)
{
sb.AppendFormat(" AND AREACODE = '{0}'", ClsSql.EncodeSql(sw.AREACODE));
}
if (!string.IsNullOrEmpty(sw.AREAJC))
{
sb.AppendFormat(" AND AREAJC = '{0}'", ClsSql.EncodeSql(sw.AREAJC));
}
if (string.IsNullOrEmpty(sw.SubAREACODE) == false)
{
if (sw.SubAREACODE == "0")
{
sb.AppendFormat(" AND Substring(AREACODE,3, 13) ='0000000000000'");
}
else if (sw.SubAREACODE.Substring(2, 13) == "0000000000000")
{
sb.AppendFormat(" AND Substring(AREACODE,5, 11) = '00000000000' AND Substring(AREACODE,3, 2) != '00' AND Substring(AREACODE,1, 2)='{0}'", sw.SubAREACODE.Substring(0, 2));
}
else if (sw.SubAREACODE.Substring(4, 11) == "00000000000" && sw.SubAREACODE.Substring(2, 2) != "00")
{
sb.AppendFormat(" AND Substring(AREACODE,7, 9) = '000000000' AND Substring(AREACODE,5, 2) != '00'AND Substring(AREACODE,1,4)='{0}'", sw.SubAREACODE.Substring(0, 4));
}
else if (sw.SubAREACODE.Substring(6, 9) == "000000000" && sw.SubAREACODE.Substring(4, 2) != "00")
{
sb.AppendFormat("AND Substring(AREACODE,10, 6) = '000000' AND Substring(AREACODE,7, 3) != '000' AND Substring(AREACODE,1,6)='{0}'", sw.SubAREACODE.Substring(0, 6));
}
else if (sw.SubAREACODE.Substring(9, 6) == "000000" && sw.SubAREACODE.Substring(6, 3) != "000")
{
sb.AppendFormat("AND Substring(AREACODE,13, 3) = '000' AND Substring(AREACODE,10, 6) != '000' AND Substring(AREACODE,1,9)='{0}'", sw.SubAREACODE.Substring(0, 6));
}
else
{
sb.AppendFormat(" AND Substring(AREACODE,1, 15) = '{0}' ", sw.SubAREACODE.Substring(0, 15));
}
}
if (!string.IsNullOrEmpty(sw.GetContyORGNOByCity))//市获取所有县
{
sb.AppendFormat(" AND (SUBSTRING(AREACODE,1,4)='{0}' and SUBSTRING(AREACODE,5,2)<>'00' and SUBSTRING(AREACODE,7,9) = '000000000' )", ClsSql.EncodeSql(sw.GetContyORGNOByCity.Substring(0, 4)));
}
if (!string.IsNullOrEmpty(sw.GetXZOrgNOByConty))
{
sb.AppendFormat(" AND (SUBSTRING(AREACODE,1,6)='{0}' and SUBSTRING(AREACODE,7,3) != '000'and SUBSTRING(AREACODE,10,6) = '000000')", ClsSql.EncodeSql(sw.GetXZOrgNOByConty.Substring(0, 6)));
}
if (string.IsNullOrEmpty(sw.OnlyGetShiXian) == false)
{
sb.AppendFormat(" AND (SUBSTRING(AREACODE,1,4)='{0}' and SUBSTRING(AREACODE,7,3) = '000' and SUBSTRING(AREACODE,5,11)<>'00000000000' )", ClsSql.EncodeSql(sw.TOPAREACODE.Substring(0, 4)));
}
sb.AppendFormat(" ORDER BY AREACODE ");
DataSet ds = DataBaseClass.FullDataSet(sb.ToString());
return(ds.Tables[0]);
}
