public List <string> getProductName_En(string prefix) { Bis.ProductMethod bisProduct = new Bis.ProductMethod(); ViewModel.Search searchProduct = new ViewModel.Search(); searchProduct.Filter = "and tblProduct.Accessory='false' and tblProduct.Name_En like N'%" + prefix.FixFarsi() + "%' "; DataSet dsProduct = bisProduct.GetProductData(searchProduct); List <string> ProductNames = new List <string>(); if (!dsProduct.Null_Ds()) { for (int i = 0; i < dsProduct.Tables[0].Rows.Count; i++) { ProductNames.Add(string.Format("{0}~{1}", dsProduct.Tables[0].Rows[i]["Name_En"].ToString(), dsProduct.Tables[0].Rows[i]["IDProduct"].ToString())); //string item = AutoCompleteExtender.CreateAutoCompleteItem(dsProduct.Tables[0].Rows[i]["ProductCodeName"].ToString(), dsProduct.Tables[0].Rows[i]["IDProduct"].ToString()); //ProductNames.Add(item); } return(ProductNames); } else { ProductNames.Add(string.Format("{0},{1}", "اطلاعاتی یافت نشد", "اطلاعاتی یافت نشد")); return(ProductNames); } }
public object ProductAutoComplete(object searchparam) { Bis.ProductMethod bisProduct = new Bis.ProductMethod(); try { if (searchparam != "") { ViewModel.Search searchProduct = new ViewModel.Search(); searchProduct.Filter = " and (tblProduct.Name_Fa Like N'%" + searchparam.ToString().FixFarsi() + "%' or tblProduct.Name_En Like N'%" + searchparam.ToString().FixFarsi() + "%') and tblProduct.Accessory = 'False' and tblProduct.AcceptByAdmin = 'true' and tblProduct.ShowInSite = 'true' and tblProductCategory.ShowInSite = 'true' "; searchProduct.Order = "order by tblProduct.Name_Fa desc"; DataSet ds = bisProduct.GetDataAutoCompeleForCompare(searchProduct); System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer(); List <Dictionary <string, object> > rows = new List <Dictionary <string, object> >(); Dictionary <string, object> row; foreach (DataRow dr in ds.Tables[0].Rows) { row = new Dictionary <string, object>(); foreach (DataColumn col in ds.Tables[0].Columns) { row.Add(col.ColumnName, dr[col]); } rows.Add(row); } return(serializer.Serialize(rows)); } else { return(""); } } catch (Exception) { throw; } finally { } }
public List <string> getAccessoryCodeAndName(string prefix) { Bis.ProductMethod bisAccessory = new Bis.ProductMethod(); ViewModel.Search searchAccessory = new ViewModel.Search(); searchAccessory.Filter = " and tblProduct.Accessory='true' and (tblProduct.ProductCode like N'%" + prefix.FixFarsi() + "%' or tblProduct.Name_Fa like N'%" + prefix.FixFarsi() + "%' )"; //searchCompany.Order = "order by tblLegalUser.Name_Fa desc"; DataSet dsAccessory = bisAccessory.GetProductData(searchAccessory); List <string> AccessoryNames = new List <string>(); if (!dsAccessory.Null_Ds()) { for (int i = 0; i < dsAccessory.Tables[0].Rows.Count; i++) { AccessoryNames.Add(string.Format("{0}~{1}", dsAccessory.Tables[0].Rows[i]["AccessoryCodeName"].ToString(), dsAccessory.Tables[0].Rows[i]["IDProduct"].ToString())); } return(AccessoryNames); } else { AccessoryNames.Add(string.Format("{0}~{1}", "اطلاعاتی یافت نشد", Guid.Empty)); return(AccessoryNames); } }