private void GetOutQtyAndSetNotes(Item item, DailyItem dI)
{
double qty = 0;
List <ItemHistory> hs = _histories
.Where(d => d.InOrOut == InOrOut.Out &&
d.Item_Id == item.Id)
.ToList();
foreach (var h in hs)
{
qty = qty + h.AppopriateQty;
if (string.IsNullOrEmpty(h.Note))
{
if (h.DR != null)
{
dI.NotesForOut.Add(h.DR.Note);
}
}
else
{
dI.NotesForOut.Add(h.Note + ". By :" + h.CreatedBy);
}
}
dI.Out = qty;
}
public DailyItem Get(int Id)
{
string sql = string.Format("select * from Daily where Id={0}", Id);
DailyItem dt = DBhelper.Init().GetDataBase().QueryFirstOrDefault <DailyItem>(sql);
return(dt);
}
public DailyReportDTO GetDailyReport(DateTime date)
{
_date = date;
DailyReportDTO dR = new DailyReportDTO();
dR.Date = date;
SearchParam p = new SearchParam();
p.SearchWithDate = true;
p.From = date;
p.To = date.AddDays(1);
List <Item> items = _itemService.AllActiveItems();
_histories = _historyService.SearchHistories(p);
_previousHistories = _historyService.GetItemsHistoryFromOtherPreviousDays(_date);
_nextHistories = _historyService.GetItemsHistoryAfterThisDate(_date);
foreach (var i in items)
{
DailyItem d = CreateRow(i);
_perDays.Add(d);
}
dR.Records = _perDays;
return(dR);
}
// Init所有每日精选商品
private void Inititems()
{
bool islock = false;
if (_dailyProducts.Count < maxShow)
{
for (int i = 0; i < _dailyProducts.Count; i++)
{
DailyProduct dailyProduct = _dailyProducts[i];
DailyItem item = Instantiate(itemPrefab, itemContainer);
item.Init(islock, dailyProduct);
dailyItems.Add(item);
}
for (int i = _dailyProducts.Count; i < maxShow; i++)
{
islock = true;
DailyItem item = Instantiate(itemPrefab, itemContainer);
item.Init(islock);
dailyItems.Add(item);
}
}
if (_dailyProducts.Count >= maxShow)
{
for (int i = 0; i < maxShow; i++)
{
DailyProduct dailyProduct = _dailyProducts[i];
DailyItem item = Instantiate(itemPrefab, itemContainer);
item.Init(islock, dailyProduct);
dailyItems.Add(item);
}
}
}
private void GetInQtyAndSetNotes(Item item, DailyItem dI)
{
double qty = 0;
List <ItemHistory> hs = _histories
.Where(d => d.InOrOut == InOrOut.In &&
d.Item_Id == item.Id)
.ToList();
foreach (var h in hs)
{
qty = qty + h.AppopriateQty;
if (string.IsNullOrEmpty(h.Note))
{
if (h.DR != null)
{
dI.NotesForIn.Add(h.DR.Note);
}
}
else
{
dI.NotesForIn.Add(h.Note + ". By :" + h.CreatedBy);
}
}
dI.HasReturnItems = hs.Any(h => h.IsMistaken);
dI.In = qty;
}
void addItemAtEmptySlot(DailyItem item)
{
for (int i = 0; i < Items2.Count; i++)
{
if (Items2[i].itemName2 == null)
{
Items2[i] = item;
break;
}
}
}
private DailyItem CreateRow(Item i)
{
DailyItem d = new DailyItem();
d.Id = i.Id;
d.ItemName = i.Name;
d.MeasuredBy = i.MeasuredBy;
d.BeginningQty = GetBeginningQty(i);
GetInQtyAndSetNotes(i, d);
GetOutQtyAndSetNotes(i, d);
d.EndingQty = GetEndingQty(i);
return(d);
}
public int Post(DailyItem daily)
{
//string sql = "insert into Daily Values('早睡',1,0,0)";
string sql = string.Format("insert into Daily Values('{0}',{1},{2},'{3}','{4}','{5}',{6})",
daily.Name,
daily.Days,
daily.AbandonCount,
daily.Status,
DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
0);
int i = DBhelper.Init().GetDataBase().Execute(sql);
return(i);
}
//生成商品，加入商品列表
private void InitItems()
{
foreach (DailyProduct dailyProduct in _dailyProducts)
{
DailyItem item = Instantiate(prefabCard, content);
item.InitItem(dailyProduct);
_dailyItems.Add(item);
}
int cardCount = _dailyProducts.Count;
for (int i = cardCount; i < maxShow; i++)
{
DailyItem item = Instantiate(prefabLock, content);
item.isLock = true;
_dailyItems.Add(item);
}
}
public void addItem(int id2)
{
if (Items2.Count == 0)
{
Init();
}
for (int i = 0; i < database.items2.Count; i++)
{
if (database.items2[i].itemID2 == id2)
{
DailyItem DailyItem = database.items2[i];
if (Items2[id2].itemName2 == null)
{
Items2[id2] = DailyItem;
}
break;
}
}
}
private void SaveDailyItems(Guid dailyId, string data)
{
var deserialiseList = JsonConvert.DeserializeObject <List <DailyItem> >(data);
foreach (var item in deserialiseList)
{
DailyItem dailyItem = new DailyItem()
{
Id = Guid.NewGuid(),
MRPPerUnit = item.MRPPerUnit,
Quantity = item.Quantity,
ItemAmount = item.ItemAmount,
StoreProductId = item.StoreProductId,
DailyId = dailyId
};
StoreProduct storeProduct = _dbContext.StoreProducts.Where(s => s.Id == item.StoreProductId).FirstOrDefault();
storeProduct.Quantity = storeProduct.Quantity - item.Quantity;
_dbContext.Entry(storeProduct).State = EntityState.Modified;
_dbContext.DailyItem.Add(dailyItem);
}
}
private void DisplayItem(DailyItem i)
{
var id = _sheet.Cell(_rowIndex, 1);
id.Value = i.Id;
var itemName = _sheet.Cell(_rowIndex, 2);
itemName.Value = i.ItemName;
var measuredBy = _sheet.Cell(_rowIndex, 3);
measuredBy.Value = i.MeasuredBy.ToString();
var beginning = _sheet.Cell(_rowIndex, 4);
beginning.Value = i.BeginningQty;
var inQty = _sheet.Cell(_rowIndex, 5);
inQty.Value = i.In;
inQty.Comment.Style.Alignment.SetAutomaticSize();
inQty.Comment.AddText(i.CommentsForIn);
if (i.HasReturnItems)
{
inQty.Style.Fill.BackgroundColor = XLColor.LightPink;
}
var outQty = _sheet.Cell(_rowIndex, 6);
outQty.Value = i.Out;
outQty.Comment.Style.Alignment.SetAutomaticSize();
outQty.Comment.AddText(i.CommentsForOut);
var ending = _sheet.Cell(_rowIndex, 7);
ending.Value = i.EndingQty;
}
public int Update(DailyItem daily)
{
if (daily.UpdateDate.ToString("yyyy-MM-dd") == DateTime.Now.ToString("yyyy-MM-dd"))
{
daily.Days = daily.Status ? daily.Days += 1 : daily.Days -= 1;
}
else
{
daily.Days += 1;
daily.UpdateDate = DateTime.Now;
daily.Status = true;
}
string sql = string.Format("update Daily set Name='{0}',Days={1},Status='{2}',UpdateDate='{3}' where Id={4}",
daily.Name,
daily.Days,
daily.Status,
daily.UpdateDate,
daily.Id);
int i = DBhelper.Init().GetDataBase().Execute(sql);
return(i);
}
/// <summary>
/// 获取天气数据
/// </summary>
/// <param name="cityId"></param>
private async Task GetWeather(string cityId, int isRefresh)
{
Model.UserCity userCity = string.IsNullOrEmpty(cityId) ? userCityRespose.UserCities.FirstOrDefault(x => x.IsDefault == 1) : userCityRespose.UserCities.FirstOrDefault(x => x.CityId == cityId);
IGetWeatherRequest weatherRequest = GetWeatherRequestFactory.CreateGetWeatherRequest(GetWeatherMode.CityId, userCity.CityId);
//有网络
if (NetHelper.IsNetworkAvailable())
{
if (userRespose.UserConfig.IsWifiUpdate == 0)
{
weatherRespose = await GetWeatherAsync(isRefresh, userCity, weatherRequest);
}
else
{
if (NetHelper.IsWifiConnection())
{
weatherRespose = await GetWeatherAsync(isRefresh, userCity, weatherRequest);
}
else
{
weatherRespose.result = null;
NotifyUser("Wifi未启动");
}
}
}
else
{
weatherRespose = await weatherService.GetWeatherByClientAsync(userCity.CityId.ToString());
NotifyUser("请开启网络，以更新最新天气数据");
}
if (weatherRespose != null)
{
var respose = weatherRespose.result.FirstOrDefault();
var aqi = respose.aqi;
var now = respose.now;
var basic = respose.basic;
var daily_forecast = respose.daily_forecast;
var hourly_forecast = respose.hourly_forecast;
if (aqi != null)
{
homePageModel.Aqi = "空气质量: " + aqi.city.qlty;
}
homePageModel.City = basic.city;
homePageModel.Daytmp = daily_forecast.FirstOrDefault().tmp.min + "° / " + daily_forecast.FirstOrDefault().tmp.max + "°";
homePageModel.Hum = "湿度: " + now.hum + " %";
homePageModel.Pres = now.pres + " hPa";
homePageModel.Tmp = now.tmp + "°";
homePageModel.Txt = now.cond.txt;
homePageModel.Update = basic.update.loc + " 发布";
homePageModel.Vis = "能见度: " + now.vis + " km";
homePageModel.Wind = now.wind.dir + " " + now.wind.sc + " 级";
homePageModel.WeatherType = weatherTypeRespose.WeatherTypes.FirstOrDefault(x => x.Code == now.cond.code);
List <ViewModel.DailyItem> dailyList = new List <ViewModel.DailyItem>();
foreach (var item in daily_forecast)
{
DailyItem daily = new DailyItem()
{
Date = GetDateStr(item.date),
Image = weatherTypeRespose.WeatherTypes.FirstOrDefault(x => x.Code == item.cond.code_d).TileWidePic,
Tmp = item.tmp.min + "° / " + item.tmp.max + "°",
Txt = item.cond.txt_d
};
dailyList.Add(daily);
}
homePageModel.DailyList = dailyList;
List <ViewModel.HourlyItem> hourlyList = new List <ViewModel.HourlyItem>();
foreach (var item in hourly_forecast)
{
HourlyItem hourly = new HourlyItem()
{
Date = DateTime.Parse(item.date).ToString("HH:mm"),
Hum = item.hum + " %",
Tmp = item.tmp + "°",
Wind = item.wind.dir + " " + item.wind.sc
};
hourlyList.Add(hourly);
}
homePageModel.HourlyList = hourlyList;
LayoutRoot.DataContext = null;
LayoutRoot.DataContext = homePageModel;
}
else
{
NotifyUser("天气数据获取失败");
}
}
