public ActionResult BOQ_MAIN_List(string searchNo, string searchIDNo, string searchType, string searchIDType, string searchExc, string searchIDExc, string searchYear, string searchIDYear)
{
WebView.WebService._base myWebService;
myWebService = new WebService._base();
WebService._base.OSPBOQ_MAIN BOQ_MAIN = new WebService._base.OSPBOQ_MAIN();
if (searchNo != null && searchType != null && searchExc != null && searchYear != null)
{
if (searchNo.Equals("") && searchType.Equals("") && searchExc.Equals("") && searchYear.Equals(""))
{
BOQ_MAIN = myWebService.GetOSPBOQ_MAIN(0, 100, null, null, null, null, null, null, null, null);
}
else
{
BOQ_MAIN = myWebService.GetOSPBOQ_MAIN(0, 100, searchNo, searchIDNo, searchType, searchIDType, searchExc, searchIDExc, searchYear, searchIDYear);
ViewBag.searchNo = searchNo;
ViewBag.searchType = searchType;
ViewBag.searchExc = searchExc;
ViewBag.searchYear = searchYear;
}
}
else
{
BOQ_MAIN = myWebService.GetOSPBOQ_MAIN(0, 100, null, null, null, null, null, null, null, null);
ViewBag.searchNo = "";
ViewBag.searchType = "";
ViewBag.searchExc = "";
ViewBag.searchYear = "";
}
ViewData["data2"] = BOQ_MAIN.BOQ_MAINList;
using (Entities ctxData = new Entities())
{
var query = from p in ctxData.WV_BOQ_DATA
orderby p.SCH_NO ascending
select new { Text = p.SCH_NO, Value = p.SCH_NO };
List <SelectListItem> list = new List <SelectListItem>();
list.Add(new SelectListItem()
{
Text = "Select", Value = "Select"
});
foreach (var a in query.Distinct().OrderBy(it => it.Value))
{
if (a.Value != null)
{
list.Add(new SelectListItem()
{
Text = a.Text.ToString(), Value = a.Value.ToString()
});
}
}
ViewBag.x_SCH_NO = list;
}
using (Entities ctxData = new Entities())
{
var query = from p in ctxData.WV_BOQ_DATA
orderby p.SCH_TYPE ascending
select new { Text = p.SCH_TYPE, Value = p.SCH_TYPE };
List <SelectListItem> list = new List <SelectListItem>();
list.Add(new SelectListItem()
{
Text = "Select", Value = "Select"
});
foreach (var a in query.Distinct().OrderBy(it => it.Value))
{
if (a.Value != null)
{
list.Add(new SelectListItem()
{
Text = a.Text.ToString(), Value = a.Value.ToString()
});
}
}
ViewBag.x_SCH_TYPE = list;
}
using (Entities ctxData = new Entities())
{
var query = from p in ctxData.WV_BOQ_DATA
orderby p.EXC_ABB ascending
select new { Text = p.EXC_ABB, Value = p.EXC_ABB };
List <SelectListItem> list = new List <SelectListItem>();
list.Add(new SelectListItem()
{
Text = "Select", Value = "Select"
});
foreach (var a in query.Distinct().OrderBy(it => it.Value))
{
if (a.Value != null)
{
list.Add(new SelectListItem()
{
Text = a.Text.ToString(), Value = a.Value.ToString()
});
}
}
ViewBag.x_EXC_ABB = list;
}
using (Entities ctxData = new Entities())
{
var query = from p in ctxData.WV_BOQ_DATA
orderby p.YEAR_INSTALL ascending
select new { Text = p.YEAR_INSTALL, Value = p.YEAR_INSTALL };
List <SelectListItem> list = new List <SelectListItem>();
list.Add(new SelectListItem()
{
Text = "Select", Value = "Select"
});
foreach (var a in query.Distinct().OrderBy(it => it.Value))
{
if (a.Value != null)
{
list.Add(new SelectListItem()
{
Text = a.Text.ToString(), Value = a.Value.ToString()
});
}
}
ViewBag.x_YEAR_INSTALL = list;
}
return(View());
}
