public static string GetSiparisListesi(string MasterId)
{
SqlConnection conn = DB.Connect();
string query =// " SELECT MasterId,UrunId,Birim,BirimFiyat,Miktar FROM SiparisDetay where MasterId like @MasterId";// and m.Tarih between isnull( @Tarih1 , m.Tarih) and isnull( @Tarih2 , m.Tarih)";
" select m.Tarih,m.BayiId,m.Id SiparisNo, d.UrunId,d.Miktar, d.BirimFiyat,d.Id,d.Birim,d.BirimFiyat*d.Miktar Tutar," +
" isnull((select Tanim from Urunler where Id=d.UrunId ),'') UrunAdi, " +
" isnull((select Adres from Bayiler where Id=m.BayiId ),'') Adres, " +
" isnull((select Tanim from Bayiler where Id=m.BayiId ),'') BayiAdi " +
" from SiparisMaster m inner join SiparisDetay d on m.Id=d.MasterId ";
//" where m.Id= @MasterId" ;
SqlCommand cmd = new SqlCommand(query, conn);
// cmd.Parameters.Add("@MasterId", SqlDbType.Int).Value = "%" + MasterId + "%";
// cmd.Parameters.Add("@Tarih2", SqlDbType.VarChar, 30).Value = TxtSifre.Text; //Sifre.TripleDesc(TbxSifre.Text);
SqlDataReader dr = cmd.ExecuteReader();
Data.Siparisler Ana = new Data.Siparisler();
Ana.Liste = new List <Data.Siparis>();
while (dr.Read())
{
Data.Siparis aa = new Data.Siparis();
aa.Id = Convert.ToInt16(dr["Id"].ToString());
aa.SiparisNo = Convert.ToInt16(dr["SiparisNo"].ToString());
aa.BayiAdi = dr["BayiAdi"].ToString();
aa.Adres = dr["Adres"].ToString();
aa.BayiId = Convert.ToInt16(dr["BayiId"].ToString());
aa.Tarih = Convert.ToDateTime(dr["Tarih"].ToString());
aa.UrunAdi = dr["UrunAdi"].ToString();
aa.UrunId = Convert.ToInt16(dr["UrunId"].ToString());
aa.Birim = dr["Birim"].ToString();
aa.BirimFiyat = Convert.ToDouble(dr["BirimFiyat"].ToString());
aa.Miktar = Convert.ToDouble(dr["Miktar"].ToString());
aa.Tutar = Convert.ToDouble(dr["Tutar"].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 GetAll()
{
SqlConnection conn = DB.Connect();
string query = " select m.Tarih,m.BayiId,m.Id SiparisNo, d.UrunId,d.Miktar, d.BirimFiyat,d.Id,d.Birim,d.BirimFiyat*d.Miktar Tutar," +
" isnull((select Tanim from Urunler where Id=d.UrunId ),'') UrunAdi, " +
" isnull((select Tanim from Bayiler where Id=m.BayiId ),'') BayiAdi " +
" from SiparisMaster m inner join SiparisDetay d on m.Id=d.MasterId " +
" where not exists(select Id from FaturaDetay where SiparisDetayId=d.Id ) ";// and m.Tarih between isnull( @Tarih1 , m.Tarih) and isnull( @Tarih2 , m.Tarih)";
SqlCommand cmd = new SqlCommand(query, conn);
// cmd.Parameters.Add("@Tarih1", SqlDbType.VarChar, 20).Value = SqlDbType.Date.;
// cmd.Parameters.Add("@Tarih2", SqlDbType.VarChar, 30).Value = TxtSifre.Text; //Sifre.TripleDesc(TbxSifre.Text);
SqlDataReader dr = cmd.ExecuteReader();
//Data.Siparisler Ana = new Data.Siparisler();
Data.Siparis aa = new Data.Siparis();
if (dr.Read())
{
aa.SiparisNo = Convert.ToInt16(dr["SiparisNo"].ToString());
aa.BayiAdi = dr["BayiAdi"].ToString();
aa.BayiId = Convert.ToInt16(dr["BayiId"].ToString());
aa.Tarih = Convert.ToDateTime(dr["Tarih"].ToString());
aa.UrunAdi = dr["UrunAdi"].ToString();
aa.UrunId = Convert.ToInt16(dr["UrunId"].ToString());
aa.Birim = dr["Birim"].ToString();
aa.BirimFiyat = Convert.ToDouble(dr["BirimFiyat"].ToString());
aa.Miktar = Convert.ToDouble(dr["Miktar"].ToString());
aa.Tutar = Convert.ToDouble(dr["Tutar"].ToString());
// Ana.Liste.Add(aa);
}
JavaScriptSerializer serializer = new JavaScriptSerializer();
string ss = serializer.Serialize(aa);
dr.Close();
dr.Dispose();
DB.Close(conn);
cmd.Dispose();
return(ss);
}
