public IEnumerable <BO.x31Report> GetList(BO.myQuery mq) { if (mq.explicit_orderby == null) { mq.explicit_orderby = "a.x31Name"; } ; DL.FinalSqlCommand fq = DL.basQuery.ParseFinalSql(GetSQL1(), mq, _mother.CurrentUser); return(_db.GetList <BO.x31Report>(fq.FinalSql, fq.Parameters)); }
public IEnumerable <BO.j03User> GetList(BO.myQuery mq) { DL.FinalSqlCommand fq = DL.basQuery.ParseFinalSql(GetSQL1(), mq, _mother.CurrentUser); return(_db.GetList <BO.j03User>(fq.FinalSql, fq.Parameters)); }
public IEnumerable <BO.o51Tag> GetList(BO.myQuery mq) { mq.explicit_orderby = "o51_o53.o53Ordinary,o51_o53.o53Name,a.o51Ordinary,a.o51Name"; DL.FinalSqlCommand fq = DL.basQuery.ParseFinalSql(GetSQL1(), mq, _mother.CurrentUser); return(_db.GetList <BO.o51Tag>(fq.FinalSql, fq.Parameters)); }
public static DL.FinalSqlCommand ParseFinalSql(string strPrimarySql, BO.myQuery mq, BO.RunningUser ru, bool bolPrepareParam4DT = false) { var lis = new List <DL.QueryRow>(); if (mq.lisJ73 != null) { ParseJ73Query(ref lis, mq); } if (mq.IsRecordValid == true) { AQ(ref lis, "a.ValidUntil>GETDATE()", "", null); } if (mq.IsRecordValid == false) { AQ(ref lis, "GETDATE() NOT BETWEEN a.ValidFrom AND a.ValidUntil", "", null); } if (mq.global_d2 != null && Convert.ToDateTime(mq.global_d2).Hour == 0) { mq.global_d2 = Convert.ToDateTime(mq.global_d2).AddDays(1).AddMinutes(-1); } if (mq.global_d1 != null && mq.global_d2 != null) { if (mq.Prefix == "p41") { AQ(ref lis, "(a.p41PlanStart BETWEEN @d1 AND @d2 OR a.p41PlanEnd BETWEEN @d1 AND @d2 OR (@d1 >= a.p41PlanStart AND @d2<=a.p41PlanEnd))", "d1", mq.global_d1, "AND", null, null, "d2", mq.global_d2); } if (mq.Prefix == "p44") { AQ(ref lis, "a.p41ID IN (select p41ID FROM p41Task WHERE p41PlanStart BETWEEN @d1 AND @d2 OR p41PlanEnd BETWEEN @d1 AND @d2 OR (@d1 >= p41PlanStart AND @d2<=p41PlanEnd))", "d1", mq.global_d1, "AND", null, null, "d2", mq.global_d2); } if (mq.Prefix == "y02") { AQ(ref lis, "p33Date BETWEEN @d1 AND @d2", "d1", mq.global_d1, "AND", null, null, "d2", mq.global_d2); } } if (mq.pids != null && mq.pids.Any()) { AQ(ref lis, mq.PkField + " IN (" + String.Join(",", mq.pids) + ")", "", null); } if (mq.b03id > 0) { if (mq.Prefix == "b02") { AQ(ref lis, "a.b02ID IN (select b02ID FROM b04StatusGroupBinding WHERE b03ID=@b03id)", "b03id", mq.b03id); } } if (mq.b02id > 0) { AQ(ref lis, "a.b02ID=@b02id", "b02id", mq.b02id); } if (mq.b02ids != null && mq.b02ids.Count() > 0) { switch (mq.Prefix) { case "z01": case "z02": break; case "p44": AQ(ref lis, "a.p41ID IN (select p41ID FROM p41Task WHERE b02ID IN (" + string.Join(",", mq.b02ids) + "))", "", null); break; default: AQ(ref lis, "a.b02ID IN (select b02ID FROM b02Status WHERE b02ID IN (" + string.Join(",", mq.b02ids) + "))", "", null); break; } } if (mq.j04id > 0) { AQ(ref lis, "a.j04ID=@j04id", "j04id", mq.j04id); } if (mq.j72id > 0) { if (mq.Prefix == "j04") { AQ(ref lis, "a.j04ID IN (select j04ID FROM j74TheGridReceiver WHERE j72ID=@j72id)", "j72id", mq.j72id); } } if (mq.DateBetween != null && mq.DateBetweenDays > 0) { AQ(ref lis, string.Format("(a.p41PlanStart BETWEEN @d1 AND DATEADD(DAY,{0},@d1) OR a.p41PlanEnd BETWEEN @d1 AND DATEADD(DAY,{0},@d1) OR @d1 BETWEEN a.p41PlanStart AND a.p41PlanEnd OR DATEADD(DAY,{0},@d1) BETWEEN a.p41PlanStart AND a.p41PlanEnd)", mq.DateBetweenDays), "d1", mq.DateBetween.Value); } if (mq.p19id > 0) { if (mq.Prefix == "p10") { AQ(ref lis, "a.p10ID IN (select xa.p10ID FROM p10MasterProduct xa INNER JOIN p13MasterTpv xb ON xa.p13ID=xb.p13ID INNER JOIN p14MasterOper xc ON xb.p13ID=xc.p13ID WHERE xc.p19ID=@p19id)", "p19id", mq.p19id); } if (mq.Prefix == "p13") { AQ(ref lis, "a.p13ID IN (select xa.p13ID FROM p10MasterProduct xa INNER JOIN p13MasterTpv xb ON xa.p13ID=xb.p13ID INNER JOIN p14MasterOper xc ON xb.p13ID=xc.p13ID WHERE xc.p19ID=@p19id)", "p19id", mq.p19id); } } if (mq.p21id > 0) { if (mq.Prefix == "p10") { AQ(ref lis, "a.p10ID IN (select p10ID FROM p22LicenseBinding WHERE p21ID=@p21id)", "p21id", mq.p21id); } if (mq.Prefix == "p13") { AQ(ref lis, "a.p13ID IN (select xb.p13ID FROM p22LicenseBinding xa INNER JOIN p10MasterProduct xb ON xa.p10ID=xb.p10ID WHERE xa.p21ID=@p21id)", "p21id", mq.p21id); } if (mq.Prefix == "p11" || mq.Prefix == "p12") { AQ(ref lis, "a.p21ID=@p21id", "p21id", mq.p21id); } if (mq.Prefix == "o23") { AQ(ref lis, "a.o23Entity LIKE 'p21License' AND a.o23RecordPid=@p21id", "p21id", mq.p21id); } } if (mq.p21id_missing > 0) { if (mq.Prefix == "p10") { AQ(ref lis, "a.p10ID NOT IN (select p10ID FROM p22LicenseBinding WHERE p21ID=@p21id)", "p21id", mq.p21id_missing); } } if (mq.p10id > 0) { if (mq.Prefix == "p21") { AQ(ref lis, "a.p21ID IN (select p21ID FROM p22LicenseBinding WHERE p10ID=@p10id)", "p10id", mq.p10id); } if (mq.Prefix == "p11") { AQ(ref lis, "a.p10ID_Master=@p10id", "p10id", mq.p10id); } if (mq.Prefix == "o23") { AQ(ref lis, "a.o23Entity LIKE 'p10MasterProduct' AND a.o23RecordPid=@p10id", "p10id", mq.p10id); } if (mq.Prefix == "p14") { AQ(ref lis, "a.p13ID IN (select p13ID FROM p10MasterProduct WHERE p10ID=@p10id)", "p10id", mq.p10id); } } if (mq.p12id > 0) { if (mq.Prefix == "p11" || mq.Prefix == "p15") { AQ(ref lis, "a.p12ID=@p12id", "p12id", mq.p12id); } if (mq.Prefix == "o23") { AQ(ref lis, "a.o23Entity LIKE 'p12ClientTpv' AND a.o23RecordPid=@p12id", "p12id", mq.p12id); } } if (mq.p11id > 0) { if (mq.Prefix == "o23") { AQ(ref lis, "a.o23Entity LIKE 'p11ClientProduct' AND a.o23RecordPid=@p10id", "p11id", mq.p11id); } if (mq.Prefix == "p21") { AQ(ref lis, "a.p21ID IN (select p21ID FROM p11ClientProduct WHERE p11ID=@p11id)", "p11id", mq.p11id); } if (mq.Prefix == "p51") { AQ(ref lis, "a.p51ID IN (select p51ID FROM p52OrderItem WHERE p11ID=@p11id)", "p11id", mq.p11id); } if (mq.Prefix == "p52") { AQ(ref lis, "a.p11ID=@p11id", "p11id", mq.p11id); } if (mq.Prefix == "p41") { AQ(ref lis, "a.p52ID IN (select p52ID FROM p52OrderItem WHERE p11ID=@p11id)", "p11id", mq.p11id); } if (mq.Prefix == "p15") { AQ(ref lis, "a.p12ID IN (select p12ID FROM p11ClientProduct WHERE p11ID=@p11id)", "p11id", mq.p11id); } //if (mq.Prefix == "p44") AQ(ref lis, "a.p41ID IN (select xa.p41ID FROM p41Task xa INNER JOIN p52OrderItem xb ON xa.p52ID=xb.p52ID WHERE xb.p11ID=@p11id)", "p11id", mq.p11id); if (mq.Prefix == "p44") { AQ(ref lis, "a.p19ID IN (select xa.p19ID FROM p19Material xa INNER JOIN p11ClientProduct xb ON xa.p19Code=xb.p11Code WHERE xb.p11ID=@p11id)", "p11id", mq.p11id); } } if (mq.p13id > 0) { if (mq.Prefix == "p10" || mq.Prefix == "p14") { AQ(ref lis, "a.p13ID=@p13id", "p13id", mq.p13id); } if (mq.Prefix == "p12") { AQ(ref lis, "a.p13ID_Master=@p13id", "p13id", mq.p13id); } if (mq.Prefix == "p11") { AQ(ref lis, "a.p11ID IN (select xa.p11ID FROM p11ClientProduct xa INNER JOIN p12ClientTpv xb ON xa.p12ID=xb.p12ID WHERE xb.p13ID_Master=@p13id)", "p13id", mq.p13id); } if (mq.Prefix == "o23") { AQ(ref lis, "a.o23Entity LIKE 'p13MasterTpv' AND a.o23RecordPid=@p13id", "p13id", mq.p13id); } } if (mq.p28id > 0) { if (mq.Prefix == "j02" || mq.Prefix == "p26" || mq.Prefix == "p21") { AQ(ref lis, "a.p28ID=@p28id", "p28id", mq.p28id); } if (mq.Prefix == "p11" || mq.Prefix == "p12") { AQ(ref lis, "a.p21ID IN (select p21ID FROM p21License WHERE p28ID=@p28id)", "p28id", mq.p28id); } if (mq.Prefix == "o23") { AQ(ref lis, "a.o23Entity LIKE 'p28Company' AND a.o23RecordPid=@p28id", "p28id", mq.p28id); } if (mq.Prefix == "p51") { AQ(ref lis, "a.p28ID=@p28id", "p28id", mq.p28id); } if (mq.Prefix == "p41") { AQ(ref lis, "a.p52ID IN (select xa.p52ID FROM p52OrderItem xa INNER JOIN p51Order xb ON xa.p51ID=xb.p51ID WHERE xb.p28ID=@p28id)", "p28id", mq.p28id); } } if (mq.j02id > 0) { if (mq.Prefix == "o23") { AQ(ref lis, "a.o23Entity LIKE 'j02Person' AND a.o23RecordPid=@j02id", "j02id", mq.j02id); } if (mq.Prefix == "p51" || mq.Prefix == "p41") { AQ(ref lis, "a.j02ID_Owner=@j02id", "j02id", mq.j02id); } if (mq.Prefix == "j90" || mq.Prefix == "j92" || mq.Prefix == "x40") { AQ(ref lis, "a.j03ID IN (select j03ID FROM j03User WHERE j02ID=@j02id)", "j02id", mq.j02id); } } if (mq.p25id > 0) { if (mq.Prefix == "p26") { AQ(ref lis, "a.p25ID=@p25id", "p25id", mq.p25id); } if (mq.Prefix == "p18") { AQ(ref lis, "a.p25ID=@p25id", "p25id", mq.p25id); } if (mq.Prefix == "p27") { AQ(ref lis, "a.p27ID IN (select xa.p27ID FROM p29MszUnitBinding xa INNER JOIN p26Msz xb ON xa.p26ID=xb.p26ID WHERE xb.p25ID=@p25id)", "p25id", mq.p25id); } } //if (mq.p25ids !=null && mq.p25ids.Count > 0) //{ // if (mq.Prefix == "p26") AQ(ref lis, "a.p25ID IN (" + string.Join(",", mq.p25ids) + ")", "", null); // if (mq.Prefix == "p18") AQ(ref lis, "a.p25ID IN (" + string.Join(",", mq.p25ids) + ")", "", null); // if (mq.Prefix == "p27") AQ(ref lis, "a.p27ID IN (select xa.p27ID FROM p29MszUnitBinding xa INNER JOIN p26Msz xb ON xa.p26ID=xb.p26ID WHERE xb.p25ID IN (" + string.Join(",", mq.p25ids) + "))", "", null); //} if (mq.p18flag > 0) { if (mq.Prefix == "p18") { AQ(ref lis, "a.p18Flag=@p18flag", "p18flag", mq.p18flag); } } if (mq.p18flags != null && mq.p18flags.Count() > 0) { if (mq.Prefix == "p18") { AQ(ref lis, "a.p18Flag IN (" + string.Join(",", mq.p18flags) + ")", "", null); } if (mq.Prefix == "p41") { AQ(ref lis, "a.p41ID IN (select xa.p41ID FROM p44TaskOperPlan xa INNER JOIN p18OperCode xb ON xa.p18ID=xb.p18ID WHERE xb.p18Flag IN (" + string.Join(",", mq.p18flags) + "))", "", null); } } if (mq.p26id > 0) { if (mq.Prefix == "o23") { AQ(ref lis, "a.o23Entity LIKE 'p26Msz' AND a.o23RecordPid=@p26id", "p26id", mq.p26id); } if (mq.Prefix == "p27") { AQ(ref lis, "a.p27ID IN (select p27ID FROM p29MszUnitBinding WHERE p26ID=@p26id)", "p26id", mq.p26id); } if (mq.Prefix == "p41") { AQ(ref lis, "a.p27ID IN (select p27ID FROM p29MszUnitBinding WHERE p26ID=@p26id)", "p26id", mq.p26id); } } if (mq.p26ids != null && mq.p26ids.Count() > 0) { if (mq.Prefix == "p41") { AQ(ref lis, "a.p27ID IN (select p27ID FROM p29MszUnitBinding WHERE p26ID IN (" + string.Join(",", mq.p26ids) + "))", "", null); } if (mq.Prefix == "p27") { AQ(ref lis, "a.p27ID IN (select p27ID FROM p29MszUnitBinding WHERE p26ID IN (" + string.Join(",", mq.p26ids) + "))", "", null); } } if (mq.p27id > 0) { if (mq.Prefix == "p18") { AQ(ref lis, "a.p25ID IN (select p25ID_HW FROM p27MszUnit WHERE p27ID=@p27id)", "p27id", mq.p27id); //zde se musí pracovat s kmenovým typem zařízení definovaným ve středisku! } } if (mq.p27ids != null && mq.p27ids.Count() > 0) { if (mq.Prefix == "p41") { AQ(ref lis, "a.p27ID IN (" + string.Join(",", mq.p27ids) + ")", "", null); } } if (mq.p41id > 0) { if (mq.Prefix == "o23") { AQ(ref lis, "a.o23Entity LIKE 'p41Task' AND a.o23RecordPid=@p41id", "p41id", mq.p41id); } if (mq.Prefix == "p15") { AQ(ref lis, "a.p12ID IN (select xb.p12ID FROM p52OrderItem xa INNER JOIN p11ClientProduct xb ON xa.p11ID=xb.p11ID INNER JOIN p41Task xc ON xa.p52ID=xc.p52ID WHERE xc.p41ID=@p41id)", "p41id", mq.p41id); } if (mq.Prefix == "p44") { AQ(ref lis, "a.p41ID=@p41id", "p41id", mq.p41id); } if (mq.Prefix == "p45") { AQ(ref lis, "a.p41ID=@p41id", "p41id", mq.p41id); } //zde se musí pracovat s kmenovým typem zařízení definovaným ve středisku! if (mq.Prefix == "p18") { AQ(ref lis, "a.p25ID IN (select xa.p25ID_HW FROM p27MszUnit xa INNER JOIN p41Task xb ON xa.p27ID=xb.p27ID WHERE xb.p41ID=@p41id)", "p41id", mq.p41id); } } if (mq.p51id > 0) { if (mq.Prefix == "p52") { AQ(ref lis, "a.p51ID=@p51id", "p51id", mq.p51id); } if (mq.Prefix == "o23") { AQ(ref lis, "a.o23Entity LIKE 'p51Order' AND a.o23RecordPid=@p51id", "p51id", mq.p51id); } if (mq.Prefix == "p41") { AQ(ref lis, "a.p52ID IN (select p52ID FROM p52OrderItem WHERE p51ID=@p51id)", "p51id", mq.p51id); } } if (mq.p52id > 0) { if (mq.Prefix == "p41") { AQ(ref lis, "a.p52ID=@p52id", "p52id", mq.p52id); } } if (mq.o53id > 0) { if (mq.Prefix == "o51") { AQ(ref lis, "a.o53ID=@o53id", "o53id", mq.o53id); } } if (mq.Prefix == "b02" && !string.IsNullOrEmpty(mq.query_by_entity_prefix)) { AQ(ref lis, "a.b02Entity=@prefix", "prefix", mq.query_by_entity_prefix); //filtr seznamu stavů podle druhu entity } if (mq.Prefix == "o12" && !string.IsNullOrEmpty(mq.query_by_entity_prefix)) { AQ(ref lis, "a.o12Entity=@prefix", "prefix", mq.query_by_entity_prefix); //filtr seznamu kategorií podle druhu entity } if (mq.TheGridFilter != null) { ParseSqlFromTheGridFilter(mq, ref lis); //složit filtrovací podmínku ze sloupcového filtru gridu } if (ru.j03EnvironmentFlag == 2) //odstínit data pouze pro držitele licence, tj. firmu s licencí na p10SwLicenseFlag>0 { //if (mq.Prefix == "j02") //{ // AQ(ref lis, "(a.p28ID=@p28id_my OR a.j02ID_Owner IN (select j02ID FROM j02Person WHERE p28ID=@p28id_my)", "p28id_my", ru.p28ID); //} if (mq.Prefix == "o23" || mq.Prefix == "p41" || mq.Prefix == "p31" || mq.Prefix == "p51") { AQ(ref lis, "a.j02ID_Owner IN (select j02ID FROM j02Person WHERE p28ID=@p28id_my)", "p28id_my", ru.p28ID); } if (mq.Prefix == "p52") { AQ(ref lis, "a.p51ID IN (select xa.p51ID FROM p51Order xa INNER JOIN j02Person xb ON xa.j02ID_Owner=xb.j02ID WHERE xb.p28ID=@p28id_my)", "p28id_my", ru.p28ID); //pouze objednávky cloud klienta } if (mq.Prefix == "p28" || mq.Prefix == "j02") { AQ(ref lis, "(a.p28ID=@p28id_my OR a.j02ID_Owner IN (select j02ID FROM j02Person WHERE p28ID=@p28id_my))", "p28id_my", ru.p28ID); } if (mq.Prefix == "p11" || mq.Prefix == "p12") { AQ(ref lis, "a.p21ID IN (SELECT p21ID FROM p21License WHERE p28ID = @p28id_my)", "p28id_my", ru.p28ID); //pouze produkty v licenci klienta } if (mq.Prefix == "p26" || mq.Prefix == "p21") { AQ(ref lis, "a.p28ID = @p28id", "p28id", ru.p28ID); //pouze licence a stroje klienta } if (mq.Prefix == "p25") { AQ(ref lis, "a.p25ID IN (select p25ID FROM p26Msz WHERE p28ID=@p28id)", "p28id", ru.p28ID); //pouze typy zařízení za klientovi stroje } if (mq.Prefix == "p27") { AQ(ref lis, "a.p27ID IN (select xa.p27ID FROM p29MszUnitBinding xa INNER JOIN p26Msz xb ON xa.p26ID=xb.p26ID WHERE xb.p28ID=@p28id_my)", "p28id_my", ru.p28ID); //pouze klientovi stroje } if (mq.Prefix == "j04") { AQ(ref lis, "a.j04IsClientRole=1", "", null); //pouze klientské role } if (mq.Prefix == "p19" || mq.Prefix == "p20") //klientský materiál nebo měrné jednotky { AQ(ref lis, "(a.p28ID IS NULL OR a.p28ID=@p28id)", "p28id", ru.p28ID); } } if (String.IsNullOrEmpty(mq.SearchString) == false && mq.SearchString.Length > 1) { if (mq.Prefix == "p28") { AQ(ref lis, "(a.p28Name LIKE '%'+@expr+'%' OR a.p28ShortName LIKE '%'+@expr+'%' OR a.p28RegID LIKE '%'+@expr+'%' OR a.p28VatID LIKE '%'+@expr+'%' OR a.p28Code LIKE '%'+@expr+'%' OR a.p28ID IN (select p28ID FROM j02Person WHERE p28ID IS NOT NULL AND j02LastName like '%'+@expr+'%'))", "expr", mq.SearchString); } if (mq.Prefix == "j02") { AQ(ref lis, "(a.j02LastName LIKE '%'+@expr+'%' OR a.j02FirstName LIKE '%'+@expr+'%' OR a.j02Email LIKE '%'+@expr+'%' OR p28.p28Name LIKE '%'+@expr+'%')", "expr", mq.SearchString); } if (mq.Prefix == "p51") { AQ(ref lis, "(a.p51Name LIKE '%'+@expr+'%' OR a.p51Code LIKE '%'+@expr+'%')", "expr", mq.SearchString); } if (mq.Prefix == "p52") { AQ(ref lis, "a.p52ID IN (select xa.p52ID FROM p52OrderItem xa INNER JOIN p51Order xb ON xa.p51ID=xb.p51ID INNER JOIN p11ClientProduct xc ON xa.p11ID=xc.p11ID LEFT OUTER JOIN p28Company xd ON xb.p28ID=xd.p28ID WHERE xb.p51Name LIKE '%'+@expr+'%' OR xc.p11Name LIKE '%'+@expr+'%' OR xd.p28Name LIKE '%'+@expr+'%' OR xb.p51Code LIKE '%'+@expr+'%' OR xc.p11Code LIKE '%'+@expr+'%')", "expr", mq.SearchString); } if (mq.Prefix == "p10") { AQ(ref lis, "(a.p10Name LIKE '%'+@expr+'%' OR a.p10Code LIKE '%'+@expr+'%')", "expr", mq.SearchString); } if (mq.Prefix == "p13") { AQ(ref lis, "(a.p13Name LIKE '%'+@expr+'%' OR a.p13Code LIKE '%'+@expr+'%')", "expr", mq.SearchString); } if (mq.Prefix == "o23") { AQ(ref lis, "(a.o23Name LIKE '%'+@expr+'%' OR a.o23Code LIKE '%'+@expr+'%' OR a.o23Memo LIKE '%'+@expr+'%')", "expr", mq.SearchString); } } var ret = new DL.FinalSqlCommand(); if (lis.Count > 0) { ret.Parameters = new Dapper.DynamicParameters(); if (bolPrepareParam4DT) { ret.Parameters4DT = new List <DL.Param4DT>(); } foreach (var c in lis.Where(p => String.IsNullOrEmpty(p.ParName) == false)) { ret.Parameters.Add(c.ParName, c.ParValue); if (bolPrepareParam4DT) { ret.Parameters4DT.Add(new DL.Param4DT() { ParName = c.ParName, ParValue = c.ParValue }); } } foreach (var c in lis.Where(p => String.IsNullOrEmpty(p.Par2Name) == false)) { ret.Parameters.Add(c.Par2Name, c.Par2Value); if (bolPrepareParam4DT) { ret.Parameters4DT.Add(new DL.Param4DT() { ParName = c.Par2Name, ParValue = c.Par2Value }); } } ret.SqlWhere = String.Join(" ", lis.Select(p => p.AndOrZleva + " " + p.BracketLeft + p.StringWhere + p.BracketRight)).Trim(); //složit závěrčnou podmínku //System.IO.File.WriteAllText("c:\\temp\\hovado"+mq.Prefix+".txt", ret.SqlWhere); ret.SqlWhere = String.Join(" ", lis.Select(p => p.AndOrZleva + " " + p.StringWhere)).Trim(); //složit závěrčnou podmínku } if (!string.IsNullOrEmpty(ret.SqlWhere)) { strPrimarySql += " WHERE " + ret.SqlWhere; } if (!string.IsNullOrEmpty(mq.explicit_orderby)) { strPrimarySql += " ORDER BY " + mq.explicit_orderby; } if (strPrimarySql.Contains("@gd1")) { //view s napevno navrženou podmínkou časového filtru if (mq.global_d1 == null) { mq.global_d1 = new DateTime(2000, 1, 1); } if (mq.global_d2 == null) { mq.global_d2 = new DateTime(3000, 1, 1); } if (ret.Parameters == null) { ret.Parameters = new Dapper.DynamicParameters(); if (bolPrepareParam4DT) { ret.Parameters4DT = new List <DL.Param4DT>(); } } ret.Parameters.Add("gd1", mq.global_d1, System.Data.DbType.DateTime); if (bolPrepareParam4DT) { ret.Parameters4DT.Add(new DL.Param4DT() { ParName = "gd1", ParValue = mq.global_d1 }); } ret.Parameters.Add("gd2", mq.global_d2, System.Data.DbType.DateTime); if (bolPrepareParam4DT) { ret.Parameters4DT.Add(new DL.Param4DT() { ParName = "gd2", ParValue = mq.global_d2 }); } } ret.FinalSql = strPrimarySql; return(ret); }
public IEnumerable <BO.p14MasterOper> GetList(BO.myQuery mq) { mq.explicit_orderby = "a.p14RowNum"; DL.FinalSqlCommand fq = DL.basQuery.ParseFinalSql(GetSQL1(), mq, _mother.CurrentUser); return(_db.GetList <BO.p14MasterOper>(fq.FinalSql, fq.Parameters)); }