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);
}