public CDataResult <int> AddTide(CTideInput input)
{
var newTide = new CTide()
{
PublicDate = input.PublicDate,
FloodTime1 = input.FloodTime1,
FloodHigh1 = input.FloodHigh1,
FloodTime2 = input.FloodTime2,
FloodHigh2 = input.FloodHigh2,
FloodTime3 = input.FloodTime3,
FloodHigh3 = input.FloodHigh3,
FloodTime4 = input.FloodTime4,
FloodHigh4 = input.FloodHigh4,
CompanyId = input.CompanyId
};
var newTideId = this._TideRepository.InsertAndGetId(newTide);
return(new CDataResult <int>()
{
IsSuccess = true,
ErrorMessage = null,
Data = newTideId
});
}
public CDataResult <bool> ImportTides(CTideInput input)
{
byte[] buffer = Convert.FromBase64String(input.File_Base64);
MemoryStream ms = new MemoryStream(buffer);
string sheetName = "潮汐时间表";
string defaultDatePrefix = "1980-01-01 ";
List <object[]> dataList = ExcelExporter <CTide> .ReadFile(ms, sheetName, 20000, 9, 2);
List <CTide> tideList = new List <CTide>();
for (int i = 0; i < dataList.Count; i++)
{
object[] tideData = dataList[i];
CTide tide = new CTide();
DateTime publicDate;
if (!DateTime.TryParse(tideData[0].ToString(), out publicDate))
{
continue;
}
tide.PublicDate = publicDate;
//tide.MoonDate = tideData[1].ToString();
//DateTime flood1Time;
//if (!DateTime.TryParse(defaultDatePrefix + tideData[2].ToString(), out flood1Time)) continue;
//tide.Flood1 = flood1Time;
//DateTime ebb1Time;
//if (!DateTime.TryParse(defaultDatePrefix + tideData[3].ToString(), out ebb1Time)) continue;
//tide.Ebb1 = ebb1Time;
//DateTime flood2Time;
//if (!DateTime.TryParse(defaultDatePrefix + tideData[4].ToString(), out flood2Time)) continue;
//tide.Flood2 = flood2Time;
//DateTime ebb2Time;
//if (!DateTime.TryParse(defaultDatePrefix + tideData[5].ToString(), out ebb2Time)) continue;
//tide.Ebb2 = ebb2Time;
//tide.PublicDate = tideData[0] == null ? string.Empty : tideData[1].ToString();
tide.FloodTime1 = tideData[1] == null ?string.Empty:tideData[1].ToString();
tide.FloodHigh1 = tideData[2] == null ? string.Empty : tideData[2].ToString();
tide.FloodTime2 = tideData[3] == null ? string.Empty : tideData[3].ToString();
tide.FloodHigh2 = tideData[4] == null ? string.Empty : tideData[4].ToString();
tide.FloodTime3 = tideData[5] == null ? string.Empty : tideData[5].ToString();
tide.FloodHigh3 = tideData[6] == null ? string.Empty : tideData[6].ToString();
tide.FloodTime4 = tideData[7] == null ? string.Empty : tideData[7].ToString();
tide.FloodHigh4 = tideData[8] == null ? string.Empty : tideData[8].ToString();
tideList.Add(tide);
}
List <CTide> oldTides = _TideRepository.GetAll().ToList();
for (int i = 0; i < oldTides.Count; i++)
{
_TideRepository.Delete(oldTides[i]);
}
for (int i = 0; i < tideList.Count; i++)
{
_TideRepository.Insert(tideList[i]);
}
return(new CDataResult <bool>()
{
IsSuccess = true,
ErrorMessage = null,
Data = true
});
}
