public ActionResult EtoSearch(string Etonumber, string projectName, string ordernumber, string customername, string gag, string doc, string routing, string orderpart, string reference)
{
//if (Convert.ToString(Session["username"]) != "")
//{
Etonumber = Etonumber != "undefined" ? Etonumber : "";
Etonumber = Etonumber != "null" ? Etonumber.Replace("_", "[_]") : "";
projectName = projectName != "undefined" ? projectName.Replace("_", "[_]") : "";
ordernumber = ordernumber != "undefined" ? ordernumber.Replace("_", "[_]") : "";
customername = customername != "undefined" ? customername.Replace("_", "[_]") : "";
gag = gag != "undefined" ? gag.Replace("_", "[_]") : "";
doc = doc != "undefined" ? doc.Replace("_", "[_]") : "";
routing = routing != "undefined" ? routing : "";
orderpart = orderpart != "undefined" ? orderpart.Replace("_", "[_]") : "";
reference = reference != "undefined" ? reference.Replace("_", "[_]") : "";
var data = Mainclass.DisplayDoc("exec sp_etoSearch '" + Etonumber + "','" + projectName + "','" + ordernumber + "','" + customername + "','" + gag + "','" + doc + "','" + routing + "','" + orderpart + "','" + reference + "','" + count + "'");
//var data = model.sp_etoSearch(Etonumber, projectName, ordernumber, customername, Vgag, Vdoc, vrouting, Vorderpart, Vref).ToList();
var jsonResult = Json(data, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
/*}
* else
* return Json("1", JsonRequestBehavior.AllowGet);*/
}
public ActionResult DocSearch(string documentNumber, string legacyPartNumber, string docStatus, string documentDescription, string LegDocumentNumber, string docType, string PartDescription)
{
// if (Convert.ToString(Session["username"]) != "")
//{
documentNumber = documentNumber != "undefined" ? documentNumber : "";
documentNumber = documentNumber != "null" ? documentNumber.Replace("_", "[_]") : "";
legacyPartNumber = legacyPartNumber != "undefined" ? legacyPartNumber.Replace("_", "[_]") : "";
docStatus = docStatus != "undefined" ? docStatus : "";
documentDescription = documentDescription != "undefined" ? documentDescription.Replace("_", "[_]") : "";
LegDocumentNumber = LegDocumentNumber != "undefined" ? LegDocumentNumber.Replace("_", "[_]") : "";
docType = docType != "undefined" ? docType : "";
PartDescription = PartDescription != "undefined" ? PartDescription.Replace("_", "[_]") : "";
var data = Mainclass.DisplayDoc("exec sp_docsearch '" + documentNumber + "','" + documentDescription + "','" + legacyPartNumber + "','" + docStatus + "','" + LegDocumentNumber + "','" + docType + "','" + PartDescription + "','" + count + "'");
//var data = model.sp_docsearch(documentNumber.ToString(), documentDescription, legacyPartNumber, prtstatus, LegDocumentNumber, parttyp).ToList();
var jsonResult = Json(data, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
/*
* }
* else
* return Json("1", JsonRequestBehavior.AllowGet);
*/
}
public ActionResult GetPartdetail(long id)
{
var data = Mainclass.DisplayDoc("exec searchpartdetail " + id + "");
var jsonResult = Json(data, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
public ActionResult PcnSearch(string Pcnnumber, string PcnDescription, string problem, string solution, string impected)
{
//if (Convert.ToString(Session["username"]) != "")
//{
Pcnnumber = Pcnnumber != "undefined" ? Pcnnumber : "";
Pcnnumber = Pcnnumber != "null" ? Pcnnumber.Replace("_", "[_]") : "";
PcnDescription = PcnDescription != "undefined" ? PcnDescription.Replace("_", "[_]") : "";
problem = problem != "undefined" ? problem.Replace("_", "[_]") : "";
impected = impected != "undefined" ? impected.Replace("_", "[_]") : "";
solution = solution != "undefined" ? solution.Replace("_", "[_]") : "";
//if (solution == "")
// dconum = null;
//else
// dconum = Convert.ToInt32(solution);
//int? parttyp = 0;
//if (impected == "")
// parttyp = null;
//else
// parttyp = Convert.ToInt32(impected);
//int? vproblem = 0;
//if (problem == "")
// vproblem = null;
//else
// vproblem = Convert.ToInt32(problem);
var data = Mainclass.DisplayDoc("exec sp_pcnsearch '" + Pcnnumber + "','" + PcnDescription + "','" + problem + "','" + solution + "','" + impected + "','" + count + "'");
//for (int i = 0; i < data.Count; i++)
//{
// var probem = Mainclass.Display("Select problemdata=(it.itemid+'/'+it.revision) from [dbo].[items] it join pcnitem_report pcnreport on pcnreport.problemitem_iid=it.iid join pcn_report pcn on pcn.pid='" + data[i]["pid"] + "'");
// var solutio = Mainclass.Display("Select problemdata=(it.itemid+'/'+it.revision) from [dbo].[items] it join pcnitem_report pcnreport on pcnreport.problemitem_iid=it.iid join pcn_report pcn on pcn.pid='" + data[i]["pid"] + "'");
// var impacted = Mainclass.Display("Select problemdata=(it.itemid+'/'+it.revision) from [dbo].[items] it join pcnitem_report pcnreport on pcnreport.problemitem_iid=it.iid join pcn_report pcn on pcn.pid='" + data[i]["pid"] + "'");
// data[i].Add("problem", probem);
// data[i].Add("solution", solutio);
// data[i].Add("impacted", impacted);
//}
//var data = model.sp_pcnsearch(Pcnnumber.ToString(), PcnDescription, vproblem, dconum, parttyp).ToList();
var jsonResult = Json(data, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
/*
* }
* else
* return Json("1", JsonRequestBehavior.AllowGet);*/
}
public ActionResult DatamartSearch(string searchString)
{
searchString = searchString.Trim();
string whereClause = "1 = 1";
searchString = searchString.Trim();
//searchString = Regex.Replace(searchString, @"\s+", " ");
string[] keywords = Regex.Split(searchString, @"\s+");
foreach (string key in keywords)
{
whereClause = whereClause + " and itemdata like ''%" + key + "%''";
}
var data = Mainclass.DisplayDoc("exec sp_search_datamart @searchText ='" + whereClause.ToString() + "', @count = " + count);
//var data = model.sp_docsearch(documentNumber.ToString(), documentDescription, legacyPartNumber, prtstatus, LegDocumentNumber, parttyp).ToList();
var jsonResult = Json(data, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}