public static List <SelectItem> GetSelectYearMonth(string uscode)
{
var financeData = DataSync_LDW_AM_STFinanceData.Search(f => f.UsCode == uscode)
.Distinct()
.OrderByDescending(e => e.FinanceYear)
.ThenByDescending(e => e.FinanceMonth).Take(12).ToList();
List <SelectItem> returnList = new List <SelectItem>();
var index = 0;
foreach (var item in financeData)
{
SelectItem sItem = new SelectItem();
var yearMonth = item.FinanceYear + "-" + item.FinanceMonth;
sItem.Name = yearMonth;
sItem.Value = item.Total_Sales_TTM;
if (index == 0)
{
sItem.Selected = true;
}
else
{
sItem.Selected = false;
}
index++;
returnList.Add(sItem);
}
return(returnList);
}
public static string GetTTFinanceData(string uscode)
{
var financeData = DataSync_LDW_AM_STFinanceData.Search(f => f.UsCode == uscode)
.OrderByDescending(e => e.FinanceYear)
.ThenByDescending(e => e.FinanceMonth)
.FirstOrDefault();
string returnVal = "";
if (financeData != null)
{
returnVal = financeData.Total_Sales_TTM;
}
return(returnVal);
}