/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MyNet.DataAccess.Model.RoadInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_GIS_ROAD set ");
strSql.Append("DLBH= '" + model.DLBH + "',");
strSql.Append("DLMC='" + model.DLMC + "',");
strSql.Append("DLLX='" + model.DLLX + "',");
strSql.Append("SSXQ='" + model.SSXQ + "',");
strSql.Append("GXSJ=now(),");
strSql.Append("ISMARK= '" + model.ISMARK + "'");
strSql.Append(" where ROADID='" + model.ROADID + "' ");
int rows = dataAccess.Execute_NonQuery(strSql.ToString());
if (rows > 0)
{
return(true);
// return UpdateXyz(model.XYZPOINT, model.ROADID);
}
else
{
return(false);
}
}
/// <summary>
/// 初始化编辑信息
/// </summary>
/// <param name="id"></param>
private void initwinedit(string id)
{
MyNet.DataAccess.Model.RoadInfo model = roadManager.GetModel(id);
if (model != null)
{
this.txtRoadIDwin.Text = id;
Session["ROADID"] = id;
this.txtRoadNamewin.Text = model.DLMC;
this.uiDepartment1.DepertId = model.SSXQ;
this.cboRoadTypewin.Text = model.DLLX;
this.txtDLBHwin.Text = model.DLBH;
this.txtDLBHwin.Visible = true;
btnSave.Text = GetLangStr("GisRoadBrowse34", "修改");
win.Show();
}
}
public void Editor(string type, string id, string roadname)
{
try
{
if (type == "Edit")
{
Session["isedit"] = "true";
MyNet.DataAccess.Model.RoadInfo model = roadManager.GetModel(id);
if (model != null)
{
this.txtRoadIDwin.Text = id;
Session["ROADID"] = id;
btnSave.Text = GetLangStr("GisRoadBrowse34", "修改");
win.Show();
}
initwinedit(id);
}
if (type == "UpdateRoadLine")
{
Session["ROADID"] = id;
string js = " BMAP.AddRoadPoint({Operate:'UpdateRoadLine'});;";
this.ResourceManager1.RegisterAfterClientInitScript(js);
}
if (type == "Delete")
{
X.Msg.Confirm(GetLangStr("GisRoadBrowse35", "提示"), GetLangStr("GisRoadBrowse36", "是否删除道路信息"), new MessageBoxButtonsConfig
{
Yes = new MessageBoxButtonConfig
{
Handler = "OnEvl.DelYes('" + id + "')",
Text = GetLangStr("GisRoadBrowse37", "是")
},
No = new MessageBoxButtonConfig
{
Text = GetLangStr("GisRoadBrowse38", "否")
}
}).Show();
}
}
catch (Exception ex)
{
ILog.WriteErrorLog(ex);
logManager.InsertLogError("GisRoadBrowse.aspx-Editor", ex.Message + "；" + ex.StackTrace, "Editor has an exception");
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MyNet.DataAccess.Model.RoadInfo GetModel(string roadid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select roadid,dlbh,dlmc,dllx,ssxq,gxsj,ismark from t_gis_road ");
strSql.Append(" where roadid='" + roadid + "'");
MyNet.DataAccess.Model.RoadInfo model = new MyNet.DataAccess.Model.RoadInfo();
DataSet ds = dataAccess.Get_DataSet(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条道路数据
/// </summary>
public bool Add(MyNet.DataAccess.Model.RoadInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_GIS_ROAD(ROADID,DLBH,DLMC,DLLX,SSXQ,GXSJ,ISMARK) values (");
strSql.Append("'" + model.ROADID + "','" + model.DLBH + "','" + model.DLMC + "','" + model.DLLX + "','" + model.SSXQ + "',str_to_date('" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','%Y-%m-%d %H:%i:%s'),'" + model.ISMARK + "')");
int rows = dataAccess.Execute_NonQuery(strSql.ToString());
if (rows > 0)
{
if (model.XYZPOINT != null && model.XYZPOINT.Count > 0)
{
return(AddXyz(model.XYZPOINT, model.ROADID));
}
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MyNet.DataAccess.Model.RoadInfo DataRowToModel(DataRow row)
{
MyNet.DataAccess.Model.RoadInfo model = new MyNet.DataAccess.Model.RoadInfo();
if (row != null)
{
if (row["ROADID"] != null)
{
model.ROADID = row["ROADID"].ToString();
}
if (row["DLBH"] != null)
{
model.DLBH = row["DLBH"].ToString();
}
if (row["DLMC"] != null)
{
model.DLMC = row["DLMC"].ToString();
}
if (row["DLLX"] != null)
{
model.DLLX = row["DLLX"].ToString();
}
if (row["SSXQ"] != null)
{
model.SSXQ = row["SSXQ"].ToString();
}
if (row["GXSJ"] != null && row["GXSJ"].ToString() != "")
{
model.GXSJ = DateTime.Parse(row["GXSJ"].ToString());
}
if (row["ISMARK"] != null)
{
model.ISMARK = row["ISMARK"].ToString();
}
}
return(model);
}