/// <summary>
/// 增、删、改
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型Message</returns>
public static Message Manager(BINGCHONGHAI_Model m)
{
if (m.opMethod == "Add")
{
Message msg = BaseDT.SDE.BINGCHONGHAI.Add(m);
if (msg.Success == false)
{
return(new Message(msg.Success, msg.Msg, ""));
}
return(new Message(msg.Success, msg.Msg, msg.Url));
}
if (m.opMethod == "Mdy")
{
Message msg = BaseDT.SDE.BINGCHONGHAI.Mdy(m);
if (msg.Success == false)
{
return(new Message(msg.Success, msg.Msg, ""));
}
return(new Message(msg.Success, msg.Msg, msg.Url));
}
if (m.opMethod == "Del")
{
return(BaseDT.SDE.BINGCHONGHAI.Del(m));
}
return(new Message(false, "无效操作", ""));
}
/// <summary>
/// 判断是否存在
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public static bool isExists(BINGCHONGHAI_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("select 1 from BINGCHONGHAI where 1=1");
if (string.IsNullOrEmpty(m.OBJECTID.ToString()) == false)
{
sb.AppendFormat(" and OBJECTID={0}", ClsSql.saveNullField(m.OBJECTID.ToString()));
}
return(SDEDataBaseClass.JudgeRecordExists(sb.ToString()));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public static Message Del(BINGCHONGHAI_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("delete BINGCHONGHAI");
sb.AppendFormat(" where OBJECTID= {0}", ClsSql.saveNullField(m.OBJECTID.ToString()));
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 Mdy(BINGCHONGHAI_Model m)
{
if (isExists(new BINGCHONGHAI_Model {
OBJECTID = m.OBJECTID
}) == false)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" INSERT INTO BINGCHONGHAI(OBJECTID,NAME,CATEGORY,DISPLAY_X,DISPLAY_Y,Shape) values(");
sb.AppendFormat("{0},", ClsSql.saveNullField(m.OBJECTID.ToString()));
sb.AppendFormat("{0},", ClsSql.saveNullField(m.NAME));
sb.AppendFormat("{0},", ClsSql.saveNullField(m.CATEGORY));
sb.AppendFormat("{0},", ClsSql.saveNullField(m.DISPLAY_X));
sb.AppendFormat("{0},", ClsSql.saveNullField(m.DISPLAY_Y));
sb.AppendFormat("{0})", m.Shape);
bool bln = SDEDataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "添加成功!", ""));
}
else
{
return(new Message(false, "添加失败!", ""));
}
}
else
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" UPDATE BINGCHONGHAI SET ");
sb.AppendFormat(" NAME={0}", ClsSql.saveNullField(m.NAME));
sb.AppendFormat(",CATEGORY={0}", ClsSql.saveNullField(m.CATEGORY));
sb.AppendFormat(",DISPLAY_X={0}", ClsSql.saveNullField(m.DISPLAY_X));
sb.AppendFormat(",DISPLAY_Y={0}", ClsSql.saveNullField(m.DISPLAY_Y));
sb.AppendFormat(",Shape={0}", m.Shape);
sb.AppendFormat(" where OBJECTID= {0}", ClsSql.saveNullField(m.OBJECTID.ToString()));
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(BINGCHONGHAI_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO BINGCHONGHAI(OBJECTID,NAME,CATEGORY,DISPLAY_X,DISPLAY_Y,Shape) values(");
sb.AppendFormat("{0},", ClsSql.saveNullField(m.OBJECTID.ToString()));
sb.AppendFormat("{0},", ClsSql.saveNullField(m.NAME));
sb.AppendFormat("{0},", ClsSql.saveNullField(m.CATEGORY));
sb.AppendFormat("{0},", ClsSql.saveNullField(m.DISPLAY_X));
sb.AppendFormat("{0},", ClsSql.saveNullField(m.DISPLAY_Y));
sb.AppendFormat("{0})", m.Shape);
bool bln = SDEDataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "添加成功!", ""));
}
else
{
return(new Message(false, "添加失败!", ""));
}
}
