protected void AddNewRec_Click(object sender, EventArgs e)
{
string country = DNTRequest.GetString("combox_country_select");
string state = DNTRequest.GetString("combox_state_select");
string city = DNTRequest.GetString("city");
string zipcode = DNTRequest.GetString("zipcode");
if (country == "" || state == "" || city == "")
{
RegisterMessage("国家、省份或城市信息没有填写!<br><a href=\\'mall_locationsmanage.aspx\\'>返回</a>");
return;
}
DataTable dt = DbProvider.GetInstance().GetLocationsTable();
foreach (DataRow dr in dt.Rows)
{
if (dr["country"].ToString() == country && dr["state"].ToString() == state && dr["city"].ToString() == city)
{
RegisterMessage("新建记录与其它记录重复!<br><a href=\\'mall_locationsmanage.aspx\\'>返回</a>");
return;
}
}
Locationinfo local = new Locationinfo();
local.Country = country;
local.State = state;
local.City = city;
local.Zipcode = zipcode;
DbProvider.GetInstance().CreateLocations(local);
Locations.GetInstance.WriteJsonFile();
RegisterStartupScript("PAGE", "window.location.href='mall_locationsmanage.aspx';");
}
public ActionResult AddVal([Bind(Include = "lat,lon")] Locationinfo location)
{
if (ModelState.IsValid)
{
var _username = Session["UserName"];
var get_user = db.Login.FirstOrDefault(p => p.Username == _username.ToString());
location.ID = get_user.ID;
db.location.Add(location);
db.SaveChanges();
return(View(location));
}
return(View());
}
/// <summary>
/// 获得所在地信息(DTO)
/// </summary>
/// <param name="__idatareader">要转换的数据</param>
/// <returns>返回所在地信息</returns>
public static Locationinfo GetLocationInfo(IDataReader reader)
{
Locationinfo locationinfo = null;
if (reader.Read())
{
locationinfo = new Locationinfo();
locationinfo.Lid = TypeConverter.ObjectToInt(reader["lid"]);
locationinfo.City = reader["city"].ToString().Trim();
locationinfo.State = reader["state"].ToString().Trim();
locationinfo.Country = reader["country"].ToString().Trim();
locationinfo.Zipcode = reader["zipcode"].ToString().Trim();
reader.Close();
}
return(locationinfo);
}
public static Locationinfo[] GetLocationInfoArray(DataTable dt)
{
if (dt == null || dt.Rows.Count == 0)
{
return(null);
}
Locationinfo[] locationInfoArray = new Locationinfo[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
locationInfoArray[i] = new Locationinfo();
locationInfoArray[i].Lid = TypeConverter.ObjectToInt(dt.Rows[i]["lid"]);
locationInfoArray[i].City = dt.Rows[i]["city"].ToString();
locationInfoArray[i].State = dt.Rows[i]["state"].ToString();
locationInfoArray[i].Country = dt.Rows[i]["country"].ToString();
locationInfoArray[i].Zipcode = dt.Rows[i]["zipcode"].ToString();
}
dt.Dispose();
return(locationInfoArray);
}
// GET: Login
public JsonResult Mapview([Bind(Include = "username,password")] Login usr)
{
double lt = 8d;
double ln = 8d;
Locationinfo ltn = new Locationinfo();
try
{
List <Locationinfo> lst = new List <Locationinfo>();
using (VehicleDbContext dbc = new VehicleDbContext())
{
lst = dbc.location.OrderBy(a => a.locationID).ToList();
}
//var get_user = db.Login.FirstOrDefault(p => true);
//usr.ID = get_user.ID;
lt = lst[lst.Count - 1].lat;
ln = lst[lst.Count - 1].lon;
}
catch (Exception ex)
{
}
return(Json(new { lat = lt, lon = ln }, JsonRequestBehavior.AllowGet));
}
protected void SaveLocation_Click(object sender, EventArgs e)
{
#region 保存区域修改
int row = 0;
DataTable dt = DbProvider.GetInstance().GetLocationsTable();
string errorinfo = "";
bool iserror = false;
foreach (object o in DataGrid1.GetKeyIDArray())
{
int id = int.Parse(o.ToString());
string country = DataGrid1.GetControlValue(row, "country").Trim();
string state = DataGrid1.GetControlValue(row, "state").Trim();
string city = DataGrid1.GetControlValue(row, "city").Trim();
string zipcode = DataGrid1.GetControlValue(row, "zipcode").Trim();
row++;
DataRow oldrow = null;
foreach (DataRow dr in dt.Rows)
{
if (dr["lid"].ToString() == id.ToString())
{
oldrow = dr;
break;
}
}
if (country == "" || state == "" || city == "")
{
iserror = true;
errorinfo += "原<b>" + oldrow["city"].ToString() + "</b>行修改后信息不完整!<br>";
continue;
}
bool isreply = false;
foreach (DataRow dr in dt.Rows)
{
if (dr["lid"].ToString() != id.ToString() && dr["country"].ToString() == country && dr["state"].ToString() == state && dr["city"].ToString() == city)
{
iserror = true;
errorinfo += "原<b>" + oldrow["city"].ToString() + "</b>修改后与其它记录重复!<br>";
isreply = true;
break;
}
}
if (isreply)
{
continue;
}
Locationinfo local = new Locationinfo();
local.Lid = id;
local.Country = country;
local.State = state;
local.City = city;
local.Zipcode = zipcode;
DbProvider.GetInstance().UpdateLocations(local);
}
Locations.GetInstance.WriteJsonFile();
if (iserror)
{
RegisterMessage(errorinfo + "<a href=\\'mall_locationsmanage.aspx\\'>返回</a>");
}
else
{
RegisterStartupScript("PAGE", "window.location.href='mall_locationsmanage.aspx';");
}
#endregion
}
