public static string GetUrunListesi(string Tanim) { SqlConnection conn = DB.Connect(); string query = " SELECT Id,Tanim,Birim,BirimFiyat, Marka FROM Urunler where Tanim like @Tanim";// and m.Tarih between isnull( @Tarih1 , m.Tarih) and isnull( @Tarih2 , m.Tarih)"; SqlCommand cmd = new SqlCommand(query, conn); cmd.Parameters.Add("@Tanim", SqlDbType.VarChar, 20).Value = "%" + Tanim + "%"; // cmd.Parameters.Add("@Tarih2", SqlDbType.VarChar, 30).Value = TxtSifre.Text; //Sifre.TripleDesc(TbxSifre.Text); SqlDataReader dr = cmd.ExecuteReader(); Data.Urunler Ana = new Data.Urunler(); Ana.Liste = new List <Data.Urun>(); while (dr.Read()) { Data.Urun aa = new Data.Urun(); aa.Id = Convert.ToInt16(dr["Id"].ToString()); aa.Tanim = dr["Tanim"].ToString(); aa.Birim = dr["Birim"].ToString(); aa.Marka = dr["Marka"].ToString(); aa.BirimFiyat = Convert.ToDouble(dr["BirimFiyat"].ToString()); Ana.Liste.Add(aa); } JavaScriptSerializer serializer = new JavaScriptSerializer(); string ss = serializer.Serialize(Ana); dr.Close(); dr.Dispose(); DB.Close(conn); cmd.Dispose(); return(ss); }
public static string GetUrun(int Id) { SqlConnection conn = DB.Connect(); string query = " SELECT Id,Tanim,Birim,BirimFiyat, Marka FROM Urunler where Id = @Id";// and m.Tarih between isnull( @Tarih1 , m.Tarih) and isnull( @Tarih2 , m.Tarih)"; SqlCommand cmd = new SqlCommand(query, conn); cmd.Parameters.Add("@Id", SqlDbType.Int).Value = Id; SqlDataReader dr = cmd.ExecuteReader(); Data.Urunler Ana = new Data.Urunler(); Ana.Liste = new List <Data.Urun>(); while (dr.Read()) { Data.Urun aa = new Data.Urun(); aa.Id = Convert.ToInt16(dr["Id"].ToString()); aa.Tanim = dr["Tanim"].ToString(); aa.Birim = dr["Birim"].ToString(); aa.Marka = dr["Marka"].ToString(); aa.BirimFiyat = Convert.ToDouble(dr["BirimFiyat"].ToString()); Ana.Liste.Add(aa); } JavaScriptSerializer serializer = new JavaScriptSerializer(); string ss = serializer.Serialize(Ana); dr.Close(); dr.Dispose(); DB.Close(conn); cmd.Dispose(); return(ss); }