/// <summary>
/// 修改指定站点的所有可修改的信息
/// </summary>
/// 可能出现：信息超过允许的范围，站点不存在。
/// <param name="station">传入一个站点对象。</param>
/// <returns></returns>
public static helper.DBReturnCode AlterStation(Models.Maintain db, Models.ID_TO_STCD_DK station)
{
if (!db.ID_TO_STCD_DK.Any(i => i.ID == station.ID)) //站点不存在
{
return(helper.DBReturnCode.NOT_EXIST);
}
ID_TO_STCD_DK target = db.ID_TO_STCD_DK.First(i => i.ID == station.ID);
//修改所有属性
target.STTYPE = station.STTYPE;
target.CNAME = station.CNAME;
target.WATERMAX = station.WATERMAX;
target.WATERMIN = station.WATERMIN;
target.WATERCHANGE = station.WATERCHANGE;
target.RAINCHANGE = station.RAINCHANGE;
target.BRAIN = station.BRAIN;
target.DAYWATERTJ = station.DAYWATERTJ;
target.DAYRAINTJ = station.DAYRAINTJ;
target.XUNWATERTJ = station.XUNWATERTJ;
target.XUNRAINTJ = station.XUNRAINTJ;
target.MONTHWATERTJ = station.MONTHWATERTJ;
target.MONTHRAINTJ = station.MONTHRAINTJ;
target.sendflag = station.sendflag;
try
{
db.SaveChanges();
return(helper.DBReturnCode.SUCCESS);
}catch (Exception e)
{
return(helper.DBReturnCode.OP_ERROR);
}
}
//GET:transfer/alterstation
/// <summary>
/// 修改一个站点的信息
/// </summary>
/// <returns></returns>
public ActionResult alterstation()
{
string station8Id, stationId, stationType, stationName, dayRain, dayWater, xunRain, xunWater, monthRain, monthWater, sendFlag;
decimal?waterMax, waterMin, waterChange, rainChange, rainAdditional;
//检查参数
try
{
station8Id = Request.Params.Get("station8id");
stationId = Request.Params.Get("stationid");
stationType = Request.Params.Get("stationtype");
stationName = Request.Params.Get("stationname");
waterMax = Decimal.Parse(Request.Params.Get("watermax"));
waterMin = Decimal.Parse(Request.Params.Get("watermin"));
waterChange = Decimal.Parse(Request.Params.Get("waterchange"));
rainChange = Decimal.Parse(Request.Params.Get("rainchange"));
rainAdditional = Decimal.Parse(Request.Params.Get("rainadditional"));
dayRain = Request.Params.Get("dayrain");
dayWater = Request.Params.Get("daywater");
xunRain = Request.Params.Get("xunrain");
xunWater = Request.Params.Get("xunwater");
monthRain = Request.Params.Get("monthrain");
monthWater = Request.Params.Get("monthwater");
sendFlag = Request.Params.Get("sendflag");
if (station8Id.Length != 8 || stationId.Length != 4 || dayRain.Length != 1 || dayWater.Length != 1 || xunRain.Length != 1 || xunWater.Length != 1 || monthRain.Length != 1 || monthWater.Length != 1 || sendFlag.Length != 1)
{
throw new Exception();
}
}
catch (Exception e)
{
return(Json(helper.DBHelper.SerializeDBReturnCode(helper.DBReturnCode.BAD_REQUEST), JsonRequestBehavior.AllowGet));
}
//init a station object
Models.ID_TO_STCD_DK station = new Models.ID_TO_STCD_DK();
station.ID = stationId;
station.STCD = station8Id;
station.CNAME = stationName;
station.STTYPE = stationType;
station.WATERMAX = waterMax;
station.WATERMIN = waterMin;
station.WATERCHANGE = waterChange;
station.RAINCHANGE = rainChange;
station.BRAIN = rainAdditional;
station.DAYRAINTJ = dayRain;
station.DAYWATERTJ = dayWater;
station.XUNRAINTJ = xunRain;
station.XUNWATERTJ = xunWater;
station.MONTHRAINTJ = monthRain;
station.MONTHWATERTJ = monthWater;
station.sendflag = sendFlag;
Models.Maintain db = new Models.Maintain();
helper.DBReturnCode code = DAL.TransferStationService.AlterStation(db, station);
string json = helper.DBHelper.SerializeDBReturnCode(code);
return(Json(json, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 根据给定的信息添加一个站点。
/// </summary>
/// 可能站点信息缺失，站点ID和报讯ID和其他站冲突。
/// <param name="station"></param>
/// <returns></returns>
public static helper.DBReturnCode AddStation(Models.Maintain db, Models.ID_TO_STCD_DK station)
{
//联合主键不能冲突
if (db.ID_TO_STCD_DK.Any(i => i.ID == station.ID) || db.ID_TO_STCD_DK.Any(i => i.STCD == station.STCD))
{
return(helper.DBReturnCode.DATA_CONFLICT);
}
db.ID_TO_STCD_DK.Add(station);
try
{
db.SaveChanges();
return(helper.DBReturnCode.SUCCESS);
}catch (Exception e)
{
return(helper.DBReturnCode.OP_ERROR);
}
}
