///<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();
}
