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); } }
protected void FillRptMasterProduct(Repeater rptMasterProduct, string hfIDProductCategory) { try { ViewModel.Search searchProduct = new ViewModel.Search(); searchProduct.Filter = " And tblProduct.IDProductCategory = '" + hfIDProductCategory + "'"; searchProduct.Order = " Order By tblProductCategory.[Order]"; DataSet dsProduct = BisProduct.GetProductData(searchProduct); rptMasterProduct.DataSource = dsProduct; rptMasterProduct.DataBind(); } catch { } }
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); } }