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