///<summary></summary> public static List<Equipment> GetList(DateTime fromDate,DateTime toDate,EnumEquipmentDisplayMode display,string snDesc) { if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) { return Meth.GetObject<List<Equipment>>(MethodBase.GetCurrentMethod(),fromDate,toDate,display,snDesc); } string command=""; if(display==EnumEquipmentDisplayMode.Purchased){ command="SELECT * FROM equipment " +"WHERE DatePurchased >= "+POut.Date(fromDate) +" AND DatePurchased <= "+POut.Date(toDate) +" AND (SerialNumber LIKE '%"+POut.String(snDesc)+"%' OR Description LIKE '%"+POut.String(snDesc)+"%')" +" ORDER BY DatePurchased"; } if(display==EnumEquipmentDisplayMode.Sold) { command="SELECT * FROM equipment " +"WHERE DateSold >= "+POut.Date(fromDate) +" AND DateSold <= "+POut.Date(toDate) +" AND (SerialNumber LIKE '%"+POut.String(snDesc)+"%' OR Description LIKE '%"+POut.String(snDesc)+"%')" +" ORDER BY DatePurchased"; } if(display==EnumEquipmentDisplayMode.All) { command="SELECT * FROM equipment " +"WHERE ((DatePurchased >= "+POut.Date(fromDate) +" AND DatePurchased <= "+POut.Date(toDate)+")" +" OR (DateSold >= "+POut.Date(fromDate) +" AND DateSold <= "+POut.Date(toDate)+"))" +" AND (SerialNumber LIKE '%"+POut.String(snDesc)+"%' OR Description LIKE '%"+POut.String(snDesc)+"%')" +" ORDER BY DatePurchased"; } return Crud.EquipmentCrud.SelectMany(command); }
///<summary></summary> public static List <Equipment> GetList(DateTime fromDate, DateTime toDate, EnumEquipmentDisplayMode display, string snDesc) { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { return(Meth.GetObject <List <Equipment> >(MethodBase.GetCurrentMethod(), fromDate, toDate, display, snDesc)); } string command = ""; if (display == EnumEquipmentDisplayMode.Purchased) { command = "SELECT * FROM equipment " + "WHERE DatePurchased >= " + POut.Date(fromDate) + " AND DatePurchased <= " + POut.Date(toDate) + " AND (SerialNumber LIKE '%" + POut.String(snDesc) + "%' OR Description LIKE '%" + POut.String(snDesc) + "%' OR Location LIKE '%" + POut.String(snDesc) + "%')" + " ORDER BY DatePurchased"; } if (display == EnumEquipmentDisplayMode.Sold) { command = "SELECT * FROM equipment " + "WHERE DateSold >= " + POut.Date(fromDate) + " AND DateSold <= " + POut.Date(toDate) + " AND (SerialNumber LIKE '%" + POut.String(snDesc) + "%' OR Description LIKE '%" + POut.String(snDesc) + "%' OR Location LIKE '%" + POut.String(snDesc) + "%')" + " ORDER BY DatePurchased"; } if (display == EnumEquipmentDisplayMode.All) { command = "SELECT * FROM equipment " + "WHERE ((DatePurchased >= " + POut.Date(fromDate) + " AND DatePurchased <= " + POut.Date(toDate) + ")" + " OR (DateSold >= " + POut.Date(fromDate) + " AND DateSold <= " + POut.Date(toDate) + "))" + " AND (SerialNumber LIKE '%" + POut.String(snDesc) + "%' OR Description LIKE '%" + POut.String(snDesc) + "%' OR Location LIKE '%" + POut.String(snDesc) + "%')" + " ORDER BY DatePurchased"; } return(Crud.EquipmentCrud.SelectMany(command)); }
private void FillGrid() { if (textDateStart.errorProvider1.GetError(textDateStart) != "" || textDateEnd.errorProvider1.GetError(textDateEnd) != "") { return; } DateTime fromDate; DateTime toDate; if (textDateStart.Text == "") { fromDate = DateTime.MinValue.AddDays(1); //because we don't want to include 010101 } else { fromDate = PIn.Date(textDateStart.Text); } if (textDateEnd.Text == "") { toDate = DateTime.MaxValue; } else { toDate = PIn.Date(textDateEnd.Text); } EnumEquipmentDisplayMode display = EnumEquipmentDisplayMode.All; if (radioPurchased.Checked) { display = EnumEquipmentDisplayMode.Purchased; } if (radioSold.Checked) { display = EnumEquipmentDisplayMode.Sold; } listEquip = Equipments.GetList(fromDate, toDate, display, textSnDesc.Text); gridMain.BeginUpdate(); if (radioPurchased.Checked) { gridMain.HScrollVisible = true; } else { gridMain.HScrollVisible = false; } gridMain.Columns.Clear(); ODGridColumn col = new ODGridColumn(Lan.g(this, "Description"), 150); gridMain.Columns.Add(col); col = new ODGridColumn(Lan.g(this, "SerialNumber"), 90); gridMain.Columns.Add(col); col = new ODGridColumn(Lan.g(this, "Yr"), 40); gridMain.Columns.Add(col); col = new ODGridColumn(Lan.g(this, "DatePurchased"), 90); gridMain.Columns.Add(col); if (display != EnumEquipmentDisplayMode.Purchased) //Purchased mode is designed for submission to tax authority, only certain columns { col = new ODGridColumn(Lan.g(this, "DateSold"), 90); gridMain.Columns.Add(col); } col = new ODGridColumn(Lan.g(this, "Cost"), 80, HorizontalAlignment.Right); gridMain.Columns.Add(col); col = new ODGridColumn(Lan.g(this, "Est Value"), 80, HorizontalAlignment.Right); gridMain.Columns.Add(col); if (display != EnumEquipmentDisplayMode.Purchased) { col = new ODGridColumn(Lan.g(this, "Location"), 80); gridMain.Columns.Add(col); } gridMain.Rows.Clear(); ODGridRow row; for (int i = 0; i < listEquip.Count; i++) { row = new ODGridRow(); row.Cells.Add(listEquip[i].Description); row.Cells.Add(listEquip[i].SerialNumber); row.Cells.Add(listEquip[i].ModelYear); row.Cells.Add(listEquip[i].DatePurchased.ToShortDateString()); if (display != EnumEquipmentDisplayMode.Purchased) { if (listEquip[i].DateSold.Year < 1880) { row.Cells.Add(""); } else { row.Cells.Add(listEquip[i].DateSold.ToShortDateString()); } } row.Cells.Add(listEquip[i].PurchaseCost.ToString("f")); row.Cells.Add(listEquip[i].MarketValue.ToString("f")); if (display != EnumEquipmentDisplayMode.Purchased) { row.Cells.Add(listEquip[i].Location); } gridMain.Rows.Add(row); } gridMain.EndUpdate(); }