/// <summary>
/// 三维-修改
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public static Message Mdy(TD_MOUNTAIN_Model m)
{
if (PublicCls.OrgIsZhen(m.BYORGNO) == false)
{
return(new Message(false, "修改失败，请选择所属乡镇！", ""));
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("UPDATE MOUNTAIN");
sb.AppendFormat(" set ");
sb.AppendFormat("NAME={0}", ClsSql.saveNullField(m.NAME));
sb.AppendFormat(",BYORGNO={0}", ClsSql.saveNullField(m.BYORGNO));
sb.AppendFormat(",BYORGNOXS={0}", ClsSql.saveNullField(m.BYORGNOXS));
sb.AppendFormat(",DISPLAY_X={0}", ClsSql.saveNullField(m.JD));
sb.AppendFormat(",DISPLAY_Y={0}", ClsSql.saveNullField(m.WD));
sb.AppendFormat(",VILLAGE={0}", ClsSql.saveNullField(m.VILLAGE));
sb.AppendFormat(",TYPE={0}", ClsSql.saveNullField(m.TYPE));
sb.AppendFormat(",Shape={0}", m.Shape);
sb.AppendFormat(" where OBJECTID= {0}", ClsSql.saveNullField(m.OBJECTID));
bool bln = SDEDataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "修改成功！", ""));
}
else
{
return(new Message(false, "修改失败，请检查各输入框是否正确！", ""));
}
}
/// <summary>
/// 三维添加
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public static Message Add(TD_MOUNTAIN_Model m)
{
if (PublicCls.OrgIsZhen(m.BYORGNO) == false)
{
return(new Message(false, "添加失败，请选择所属乡镇！", ""));
}
if (TD_MOUNTAIN.isPExists(new TD_MOUNTAIN_Model {
JD = m.JD, WD = m.WD
}) == false)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("insert into MOUNTAIN(NAME,BYORGNO,BYORGNOXS,DISPLAY_X,DISPLAY_Y,Shape,VILLAGE,TYPE) values(");
sb.AppendFormat("{0},", ClsSql.saveNullField(m.NAME));
sb.AppendFormat("{0},", ClsSql.saveNullField(m.BYORGNO));
sb.AppendFormat("{0},", ClsSql.saveNullField(m.BYORGNOXS));
sb.AppendFormat("{0},", ClsSql.saveNullField(m.JD));
sb.AppendFormat("{0},", ClsSql.saveNullField(m.WD));
sb.AppendFormat("{0},", m.Shape);
sb.AppendFormat("{0},", ClsSql.saveNullField(m.VILLAGE));
sb.AppendFormat("{0})", ClsSql.saveNullField(m.TYPE));
bool bln = SDEDataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "添加成功！", ""));
}
else
{
return(new Message(false, "添加失败，请检查各输入框是否正确！", ""));
}
}
else
{
return(new Message(false, "已有相同地址的山,请重新选择地址", ""));
}
}
/// <summary>
/// 判断记录是否存在
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>true存在 false不存在</returns>
public static bool isExists(TD_MOUNTAIN_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("select 1 from MOUNTAIN where 1=1");
if (string.IsNullOrEmpty(m.OBJECTID) == false)
{
sb.AppendFormat(" where OBJECTID= '{0}'", ClsSql.EncodeSql(m.OBJECTID));
}
return(DataBaseClass.JudgeRecordExists(sb.ToString()));
}
/// <summary>
/// 是否存在相同的点
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public static bool isPExists(TD_MOUNTAIN_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("select 1 from MOUNTAIN where 1=1");
if (string.IsNullOrEmpty(m.JD) == false && string.IsNullOrEmpty(m.WD) == false)
{
sb.AppendFormat(" and DISPLAY_X='{0}'", ClsSql.EncodeSql(m.JD));
}
sb.AppendFormat(" and DISPLAY_Y='{0}'", ClsSql.EncodeSql(m.WD));
return(SDEDataBaseClass.JudgeRecordExists(sb.ToString()));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public static Message Del(TD_MOUNTAIN_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("delete MOUNTAIN");
sb.AppendFormat(" where OBJECTID= '{0}'", ClsSql.EncodeSql(m.OBJECTID));
bool bln = SDEDataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "删除成功！", ""));
}
else
{
return(new Message(false, "删除失败，请检查各输入框是否正确！", ""));
}
}
/// <summary>
/// 山数据管理
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public static Message Manager(TD_MOUNTAIN_Model m)
{
if (m.opMethod == "Add")
{
Message msgUser = BaseDT.SDE.TD_MOUNTAIN.Add(m);
return(new Message(msgUser.Success, msgUser.Msg, msgUser.Url));
}
if (m.opMethod == "Mdy")
{
Message msgUser = BaseDT.SDE.TD_MOUNTAIN.Mdy(m);
return(new Message(msgUser.Success, msgUser.Msg, msgUser.Url));
}
if (m.opMethod == "Del")
{
Message msgUser = BaseDT.SDE.TD_MOUNTAIN.Del(m);
return(new Message(msgUser.Success, msgUser.Msg, msgUser.Url));
}
return(new Message(false, "无效操作", ""));
}
/// <summary>
/// 根据查询条件获取某一条用户信息记录，用于修改、删除、用户登录验证
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static TD_MOUNTAIN_Model getModel(TD_MOUNTAIN_SW sw)
{
var result = new List <TD_MOUNTAIN_Model>();
DataTable dt = BaseDT.SDE.TD_MOUNTAIN.getDT(sw);//列表
DataTable dt51 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "51"
}); //类型
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
TD_MOUNTAIN_Model m = new TD_MOUNTAIN_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.OBJECTID = dt.Rows[i]["OBJECTID"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.BYORGNOXS = dt.Rows[i]["BYORGNOXS"].ToString();
m.ORGXSNAME = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNOXS);
m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
m.NAME = dt.Rows[i]["NAME"].ToString();
string jd = dt.Rows[i]["DISPLAY_X"].ToString();
string wd = dt.Rows[i]["DISPLAY_Y"].ToString();
m.JD = Convert.ToDouble(jd).ToString("F6");
m.WD = Convert.ToDouble(wd).ToString("F6");
m.VILLAGE = dt.Rows[i]["VILLAGE"].ToString();
m.Shape = dt.Rows[i]["Shape"].ToString();
m.TYPE = dt.Rows[i]["TYPE"].ToString();
m.TYPENAME = BaseDT.T_SYS_DICT.getName(dt51, m.TYPE);
}
dt.Clear();
dt.Dispose();
dtORG.Clear();
dtORG.Dispose();
return(m);
}
