public int CreateStreet(StreetModel entity, string sUserId)
{
SqlParameter[] _SqlParameter = new SqlParameter[7];
_SqlParameter[0] = new SqlParameter("@StAreaCode", SqlDbType.VarChar);
_SqlParameter[0].Value = Convert.ToString(entity.StreetAreaCode);
_SqlParameter[1] = new SqlParameter("@StName", SqlDbType.VarChar);
_SqlParameter[1].Value = Convert.ToString(entity.StreetName);
_SqlParameter[2] = new SqlParameter("@StOperator", SqlDbType.VarChar);
_SqlParameter[2].Value = Convert.ToString(sUserId);
_SqlParameter[3] = new SqlParameter("@StCreatedBy", SqlDbType.VarChar);
_SqlParameter[3].Value = Convert.ToString(sUserId);
_SqlParameter[4] = new SqlParameter("@StModifiedBy", SqlDbType.VarChar);
_SqlParameter[4].Value = Convert.ToString(sUserId);
_SqlParameter[5] = new SqlParameter("@StIsActive", SqlDbType.VarChar);
_SqlParameter[5].Value = Convert.ToInt32(1);
_SqlParameter[6] = new SqlParameter("@StIsArchived", SqlDbType.VarChar);
_SqlParameter[6].Value = Convert.ToInt32(0);
DataTable ds = conn.executeSelectQueryWithSPNew("NSP_AddStreet", _SqlParameter);
if (ds != null && ds.Rows[0][0].ToString() == "Y")
{
return(1);
}
return(0);
}
public virtual IActionResult GetItem([FromBody] int id)
{
StreetDto dto = service.GetById(id);
if (dto == null)
{
return(BadRequest());
}
StreetModel model = mapper.Map <StreetModel>(dto);
return(Ok(model));
}
public static async Task <HashSet <AddressModel> > GetDistrictPowerOffInformation(string page)
{
var config = Configuration.Default;
var context = BrowsingContext.New(config);
var document = await context.OpenAsync(req => req.Content(page));
var table = document.QuerySelector("[class='sticky-enabled']").ToHtml();
document = await context.OpenAsync(req => req.Content(table));
var tbody = document.QuerySelector("tbody").ToHtml();
var listOfPlaces = document.QuerySelectorAll("tr").ToList();
var addresses = new HashSet <AddressModel>();
foreach (var column in listOfPlaces.Skip(1))
{
var row = column.QuerySelectorAll("td");
var dateOff = DateTime.Parse(row[1].ChildNodes[0].TextContent);
var dateOn = DateTime.Parse(row[2].ChildNodes[0].TextContent);
var reason = row[3].ChildNodes[0].TextContent;
var places = row[4].QuerySelectorAll("b").ToList();
foreach (var place in places)
{
row[4].QuerySelector("b")?.Remove();
var isCity = Utils.IsCity(place.TextContent);
var placeName = isCity ? place.TextContent.Split(",")[0] : place.TextContent.Split(",")[1];
var houses = row[4].ToHtml().Split("<br>")[1];
var addressModel = new AddressModel();
addressModel.PlaceName = placeName;
addressModel.Reason = reason;
addressModel.PowerOffDate = dateOff;
addressModel.PowerOnDate = dateOn;
var streetModel = new StreetModel();
streetModel.Name = isCity ? place.TextContent.Split(",")[1] : place.TextContent.Split(",")[2];
streetModel.Houses.AddRange(houses.Split(" "));
row[4].QuerySelector("br").Remove();
row[4].QuerySelector("br")?.Remove();
addresses.Add(addressModel);
var placeFromSet = addresses.Where(x => x.PlaceName == placeName).First();
placeFromSet.Streets.Add(streetModel);
}
}
return(addresses);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(StreetModel model)
{
bool reValue = true;
int reCount = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("update Street set ");
strSql.Append(" StreetName = @StreetName , ");
strSql.Append(" StreetTitle = @StreetTitle , ");
strSql.Append(" StreetContent = @StreetContent , ");
strSql.Append(" OrderId = @OrderId , ");
strSql.Append(" TownId = @TownId ");
strSql.Append(" where StreetId=@StreetId ");
SqlParameter[] parameters =
{
new SqlParameter("@StreetId", SqlDbType.Decimal, 9),
new SqlParameter("@StreetName", SqlDbType.VarChar, 100),
new SqlParameter("@StreetTitle", SqlDbType.VarChar, 200),
new SqlParameter("@StreetContent", SqlDbType.VarChar),
new SqlParameter("@OrderId", SqlDbType.Int, 4),
new SqlParameter("@TownId", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.StreetId;
parameters[1].Value = model.StreetName;
parameters[2].Value = model.StreetTitle;
parameters[3].Value = model.StreetContent;
parameters[4].Value = model.OrderId;
parameters[5].Value = model.TownId; try
{//异常处理
reCount = this.helper.ExecSqlReInt(strSql.ToString(), parameters);
}
catch (Exception ex)
{
this.helper.Close();
throw ex;
}
if (reCount <= 0)
{
reValue = false;
}
return(reValue);
}
public virtual IActionResult UpdateItem([FromBody] StreetModel model)
{
if (model == null)
{
return(BadRequest());
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
StreetDto dto = mapper.Map <StreetDto>(model);
service.Update(dto);
return(Ok());
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(StreetModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Street(");
strSql.Append("StreetName,StreetTitle,StreetContent,OrderId,TownId");
strSql.Append(") values (");
strSql.Append("@StreetName,@StreetTitle,@StreetContent,@OrderId,@TownId");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@StreetName", SqlDbType.VarChar, 100),
new SqlParameter("@StreetTitle", SqlDbType.VarChar, 200),
new SqlParameter("@StreetContent", SqlDbType.VarChar),
new SqlParameter("@OrderId", SqlDbType.Int, 4),
new SqlParameter("@TownId", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.StreetName;
parameters[1].Value = model.StreetTitle;
parameters[2].Value = model.StreetContent;
parameters[3].Value = model.OrderId;
parameters[4].Value = model.TownId;
bool result = false;
try
{
helper.ExecSqlReInt(strSql.ToString(), parameters);
result = true;
}
catch (Exception ex)
{
this.helper.Close();
throw ex;
}
finally
{
}
return(result);
}
public StreetDTO(StreetModel StreetModel)
{
Trechos = new List <List <PointDTO> >();
this.ID = StreetModel.ID;
this.Name = StreetModel.Name;
foreach (var trecho in StreetModel.StreetTrechosModel)
{
var nt = new List <PointDTO>();
foreach (var point in trecho)
{
var np = new PointDTO(point);
if (point.GSPanorama != null)
{
var panoramaDTO = new PanoramaDTO(point.GSPanorama);
np.PanoramaDTO = panoramaDTO;
}
nt.Add(np);
}
Trechos.Add(nt);
}
}
public ActionResult AddStreet(StreetModel model)
{
if (ModelState.IsValid)
{
try
{
_StreetService.CreateStreet(model, Session["Email"].ToString());
TempData["Success"] = "Success";
return(RedirectToAction("StreetList"));
}
catch (Exception ex)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
ModelState.AddModelError("", ex.Message);
TempData["Fail"] = "Fail";
return(View("AddStreet", model));
}
}
else
{
TempData["ModelsError"] = "Error";
return(RedirectToAction("AddStreet"));
}
}//..CreateUser
