//装入对应公司的Cycle信息
private void LoadCycle(string CompID)
{
using (MECEntities objDB = new MECEntities())
{
List <tblCycle> CycleList = objDB.tblCycle.Where("it.CompanyID=='" + CompID + "'").OrderBy("it.Cycle").ToList <tblCycle>();
cboCycle.Items.Clear();
Telerik.Web.UI.RadComboBoxItem item = new Telerik.Web.UI.RadComboBoxItem();
item.Value = string.Empty;
item.Text = "N/A";
cboCycle.Items.Add(item);
foreach (tblCycle cl in CycleList)
{
item = new Telerik.Web.UI.RadComboBoxItem();
item.Value = cl.CycleID;
item.Text = cl.Cycle.ToString();
cboCycle.Items.Add(item);
}
}
}
//装入公司信息
private void LoadCompany()
{
using (MECEntities objDB = new MECEntities())
{
List <tblCompany> CompList = objDB.tblCompany.ToList <tblCompany>();
cboCompany.Items.Clear();
//设置空值
Telerik.Web.UI.RadComboBoxItem item = new Telerik.Web.UI.RadComboBoxItem();
item.Text = "N/A";
item.Value = string.Empty;
cboCompany.Items.Add(item);
//装入公司数据
foreach (tblCompany cp in CompList)
{
item = new Telerik.Web.UI.RadComboBoxItem();
item.Value = cp.CompanyID;
item.Text = cp.CompName;
cboCompany.Items.Add(item);
}
}
}
public List <ViewTopCustomer> GetTopCustomer()
{
try
{
using (MECEntities objDB = new MECEntities())
{
List <ViewTopCustomer> viewTopCustomerList =
objDB.ViewTopCustomer.Top("10").Where(it => it.AcctNum != null).ToList();
return(viewTopCustomerList);
}
}
catch (Exception)
{
return(null);
}
}
public List <tblCycle> GetCycleByCompanyId(string companyId)
{
List <tblCycle> cycleObjList;
try
{
using (MECEntities objDB = new MECEntities())
{
cycleObjList = objDB.tblCycle.Where(it => it.CompanyID == companyId).ToList();
}
}
catch (Exception)
{
return(null);
}
return(cycleObjList);
}
public List <tblCompany> GetCompany()
{
List <tblCompany> companyObjList;
try
{
using (MECEntities objDB = new MECEntities())
{
companyObjList = objDB.tblCompany.Where(it => it.Comp != null).ToList();
}
}
catch (Exception)
{
return(null);
}
return(companyObjList);
}
public decimal GetBillingInfo(DateTime transactiondate)
{
try
{
using (MECEntities objDB = new MECEntities())
{
string esql = "select value sum(it.TotalDue) from MECEntities.ViewBillHistory as it "
+ " where it.TransactionDate between cast('" + transactiondate.AddMonths(-1).AddDays(1)
+ "' as System.DateTime) and cast('" + transactiondate + "' as System.DateTime) group by it.TransactionMonth"; ;
ObjectQuery<decimal> query = objDB.CreateQuery<decimal>(esql);
foreach (var item in query)
{
return item;
}
}
}
catch (Exception)
{
return 0;
}
return 0;
}
public decimal GetBillingInfo(DateTime transactiondate)
{
try
{
using (MECEntities objDB = new MECEntities())
{
string esql = "select value sum(it.TotalDue) from MECEntities.ViewBillHistory as it "
+ " where it.TransactionDate between cast('" + transactiondate.AddMonths(-1).AddDays(1)
+ "' as System.DateTime) and cast('" + transactiondate + "' as System.DateTime) group by it.TransactionMonth";;
ObjectQuery <decimal> query = objDB.CreateQuery <decimal>(esql);
foreach (var item in query)
{
return(item);
}
}
}
catch (Exception)
{
return(0);
}
return(0);
}
public List<ViewTopCustomer> GetTopCustomer()
{
try
{
using (MECEntities objDB = new MECEntities())
{
List<ViewTopCustomer> viewTopCustomerList =
objDB.ViewTopCustomer.Top("10").Where(it => it.AcctNum != null).ToList();
return viewTopCustomerList;
}
}
catch (Exception)
{
return null;
}
}
public List<tblCycle> GetCycleByCompanyId(string companyId)
{
List<tblCycle> cycleObjList;
try
{
using (MECEntities objDB = new MECEntities())
{
cycleObjList = objDB.tblCycle.Where(it => it.CompanyID == companyId).ToList();
}
}
catch (Exception)
{
return null;
}
return cycleObjList;
}
public List<tblCompany> GetCompany()
{
List<tblCompany> companyObjList;
try
{
using (MECEntities objDB = new MECEntities())
{
companyObjList = objDB.tblCompany.Where(it => it.Comp != null).ToList();
}
}
catch (Exception)
{
return null;
}
return companyObjList;
}
//装入对应公司的Cycle信息
private void LoadCycle(string CompID)
{
using (MECEntities objDB = new MECEntities())
{
List<tblCycle> CycleList = objDB.tblCycle.Where("it.CompanyID=='" + CompID+"'").OrderBy("it.Cycle").ToList<tblCycle>();
cboCycle.Items.Clear();
Telerik.Web.UI.RadComboBoxItem item = new Telerik.Web.UI.RadComboBoxItem();
item.Value = string.Empty;
item.Text = "N/A";
cboCycle.Items.Add(item);
foreach (tblCycle cl in CycleList)
{
item = new Telerik.Web.UI.RadComboBoxItem();
item.Value = cl.CycleID;
item.Text = cl.Cycle.ToString();
cboCycle.Items.Add(item);
}
}
}
//装入公司信息
private void LoadCompany()
{
using (MECEntities objDB = new MECEntities())
{
List<tblCompany> CompList = objDB.tblCompany.ToList<tblCompany>();
cboCompany.Items.Clear();
//设置空值
Telerik.Web.UI.RadComboBoxItem item = new Telerik.Web.UI.RadComboBoxItem();
item.Text = "N/A";
item.Value = string.Empty;
cboCompany.Items.Add(item);
//装入公司数据
foreach (tblCompany cp in CompList)
{
item = new Telerik.Web.UI.RadComboBoxItem();
item.Value = cp.CompanyID;
item.Text = cp.CompName;
cboCompany.Items.Add(item);
}
}
}
