//装入对应公司的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); } } }