public BlaDBVariantDefinition(DBConnectionPool conn, BlaRequest req) { Year = req.Slice.Year; iModel = req.Slice.Model; var com = new SqlCommand( "select LX3050, LX418C, LX428C, LX468P, LX418P, LX428P, LX468K, LX118R, LX338V, Nazwa from [mgm].[F7210_H02_VarRecord] (@Project, @Year, @Model" + (req.Slice.Variant != null ? ", @Variant" : ", null") + ")", conn.Connection); com.Parameters.AddWithValue("@Project", req.Slice.ProjectID); com.Parameters.AddWithValue("@Year", req.Slice.Year); com.Parameters.AddWithValue("@Model", req.Slice.Model); if (req.Slice.Variant != null) { var spa = com.Parameters.AddWithValue("@Variant", req.Slice.Variant); spa.DbType = DbType.Int32; } var r = com.ExecuteReader(); if (!r.Read()) { throw new ArgumentException("Nie można odczytać tabeli wariantów"); } iLX3050 = r.GetInt32(0); iLX418C = r.GetInt32(1); iLX428C = r.GetInt32(2); iLX468P = r.GetInt32(3); iLX418P = r.GetInt32(4); iLX428P = r.GetInt32(5); iLX468K = r.GetInt32(6); iLX118R = r.GetInt32(7); iLX338V = r.GetInt32(8); Nazwa = r.IsDBNull(9) ? "" : r.GetString(9); }
//public GrWAtt_Values AttValues = new GrWAtt_Values(); public BlaCommonStorage(DBConnectionPool pool, BlaRequest request = null) { Attributies = new GrWAttributies(); //WorkMode = workMode; Request = request; EntityReader = new JohEntityReader(pool); PuT = new PuTModel(this); }