public static IEnumerable<TasinirComboEntity> CreateItemsSource(ICommandAdapter cmd, int duzey, string startsWidth) { SqlQuery q = "SELECT Id, Adi, TasinirKodu FROM TasinirKod".ToQuery(); q.Sql(" WHERE (LEN(TasinirKodu)- LEN(REPLACE(TasinirKodu,'.',''))) = @0", duzey); if (!String.IsNullOrEmpty(startsWidth)) { q.Sql(" AND TasinirKodu like '" + startsWidth + "%'", ConditionOperator.StartsWith); } return cmd.Query<TasinirComboEntity>(q); }
public static IEnumerable<TasinirComboEntity> CreateItemsSource(ICommandAdapter cmd, int duzey, string startsWidth) { SelectSql sql = new SelectSql(); sql.Custom("SELECT Id, Adi, TasinirKodu FROM TasinirKod".ToQuery()); sql.Where(" (LEN(TasinirKodu)- LEN(REPLACE(TasinirKodu,'.',''))) = @0".ToQuery(duzey)); if (!String.IsNullOrEmpty(startsWidth)) { sql.Where("TasinirKodu", ConditionOperator.StartsWith, startsWidth); } return cmd.Query<TasinirComboEntity>(sql.ToQuery()); }
public static IEnumerable<V_FaturaGiris> SelectByFaturaId(ICommandAdapter cmd, int FaturaId) { if (null == cmd) { throw new ArgumentNullException(nameof(cmd)); } SqlQuery query = @"select f.Id, f.FaturaId, f.MalzemeId, f.DepoId, m.TasinirKodu, m.Adi TasinirAdi, d.MalzemeKodu, d.MalzemeAdi, f.Miyad, f.Miktar, o.Adi OlcuBirimi, f.BirimFiyat, f.ToplamTutar, f.Indirim , f.IndirimTutar, f.Kdv, f.KdvTutar, f.GenelToplam from FaturaGiris f inner join Malzeme d on f.MalzemeId=d.Id inner join TasinirKod m on d.TasinirKodu=m.TasinirKodu left join OlcuBirimi o on f.OlcuBirimiId=o.Id where FaturaId=@0".ToQuery(FaturaId); return cmd.Query<V_FaturaGiris>(query); }