예제 #1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromGlsbreqinitresults(ref DataRow row, Glsbreqinitresults entity)
 {
     row.SetField("budgettype", entity.budgettype);
     row.SetField("annbud", entity.annbud);
     row.SetField("frozenfl", entity.frozenfl);
     row.SetField("calcmethodli", entity.calcmethodli);
     row.SetField("calcmethodpd", entity.calcmethodpd);
     row.SetField("calcmethodsv", entity.calcmethodsv);
     row.SetField("periodlbl1", entity.periodlbl1);
     row.SetField("periodlbl2", entity.periodlbl2);
     row.SetField("periodlbl3", entity.periodlbl3);
     row.SetField("periodlbl4", entity.periodlbl4);
     row.SetField("periodlbl5", entity.periodlbl5);
     row.SetField("periodlbl6", entity.periodlbl6);
     row.SetField("periodlbl7", entity.periodlbl7);
     row.SetField("periodlbl8", entity.periodlbl8);
     row.SetField("periodlbl9", entity.periodlbl9);
     row.SetField("periodlbl10", entity.periodlbl10);
     row.SetField("periodlbl11", entity.periodlbl11);
     row.SetField("periodlbl12", entity.periodlbl12);
     row.SetField("periodlbl13", entity.periodlbl13);
     row.SetField("peramt1", entity.peramt1);
     row.SetField("peramt2", entity.peramt2);
     row.SetField("peramt3", entity.peramt3);
     row.SetField("peramt4", entity.peramt4);
     row.SetField("peramt5", entity.peramt5);
     row.SetField("peramt6", entity.peramt6);
     row.SetField("peramt7", entity.peramt7);
     row.SetField("peramt8", entity.peramt8);
     row.SetField("peramt9", entity.peramt9);
     row.SetField("peramt10", entity.peramt10);
     row.SetField("peramt11", entity.peramt11);
     row.SetField("peramt12", entity.peramt12);
     row.SetField("peramt13", entity.peramt13);
     row.SetField("budpct1", entity.budpct1);
     row.SetField("budpct2", entity.budpct2);
     row.SetField("budpct3", entity.budpct3);
     row.SetField("budpct4", entity.budpct4);
     row.SetField("budpct5", entity.budpct5);
     row.SetField("budpct6", entity.budpct6);
     row.SetField("budpct7", entity.budpct7);
     row.SetField("budpct8", entity.budpct8);
     row.SetField("budpct9", entity.budpct9);
     row.SetField("budpct10", entity.budpct10);
     row.SetField("budpct11", entity.budpct11);
     row.SetField("budpct12", entity.budpct12);
     row.SetField("budpct13", entity.budpct13);
     row.SetField("budytd1", entity.budytd1);
     row.SetField("budytd2", entity.budytd2);
     row.SetField("budytd3", entity.budytd3);
     row.SetField("budytd4", entity.budytd4);
     row.SetField("budytd5", entity.budytd5);
     row.SetField("budytd6", entity.budytd6);
     row.SetField("budytd7", entity.budytd7);
     row.SetField("budytd8", entity.budytd8);
     row.SetField("budytd9", entity.budytd9);
     row.SetField("budytd10", entity.budytd10);
     row.SetField("budytd11", entity.budytd11);
     row.SetField("budytd12", entity.budytd12);
     row.SetField("budytd13", entity.budytd13);
     row.SetField("pctytd1", entity.pctytd1);
     row.SetField("pctytd2", entity.pctytd2);
     row.SetField("pctytd3", entity.pctytd3);
     row.SetField("pctytd4", entity.pctytd4);
     row.SetField("pctytd5", entity.pctytd5);
     row.SetField("pctytd6", entity.pctytd6);
     row.SetField("pctytd7", entity.pctytd7);
     row.SetField("pctytd8", entity.pctytd8);
     row.SetField("pctytd9", entity.pctytd9);
     row.SetField("pctytd10", entity.pctytd10);
     row.SetField("pctytd11", entity.pctytd11);
     row.SetField("pctytd12", entity.pctytd12);
     row.SetField("pctytd13", entity.pctytd13);
     row.SetField("actual1", entity.actual1);
     row.SetField("actual2", entity.actual2);
     row.SetField("actual3", entity.actual3);
     row.SetField("actual4", entity.actual4);
     row.SetField("actual5", entity.actual5);
     row.SetField("actual6", entity.actual6);
     row.SetField("actual7", entity.actual7);
     row.SetField("actual8", entity.actual8);
     row.SetField("actual9", entity.actual9);
     row.SetField("actual10", entity.actual10);
     row.SetField("actual11", entity.actual11);
     row.SetField("actual12", entity.actual12);
     row.SetField("actual13", entity.actual13);
     row.SetField("gl13perfl", entity.gl13perfl);
     row.SetField("userfield", entity.userfield);
 }
예제 #2
0
        public static Glsbreqinitresults BuildGlsbreqinitresultsFromRow(DataRow row)
        {
            Glsbreqinitresults entity = new Glsbreqinitresults();

            entity.budgettype   = row.Field <bool>("budgettype");
            entity.annbud       = row.IsNull("annbud") ? decimal.Zero : row.Field <decimal>("annbud");
            entity.frozenfl     = row.Field <bool>("frozenfl");
            entity.calcmethodli = row.IsNull("calcmethodli") ? string.Empty : row.Field <string>("calcmethodli");
            entity.calcmethodpd = row.IsNull("calcmethodpd") ? string.Empty : row.Field <string>("calcmethodpd");
            entity.calcmethodsv = row.IsNull("calcmethodsv") ? string.Empty : row.Field <string>("calcmethodsv");
            entity.periodlbl1   = row.IsNull("periodlbl1") ? string.Empty : row.Field <string>("periodlbl1");
            entity.periodlbl2   = row.IsNull("periodlbl2") ? string.Empty : row.Field <string>("periodlbl2");
            entity.periodlbl3   = row.IsNull("periodlbl3") ? string.Empty : row.Field <string>("periodlbl3");
            entity.periodlbl4   = row.IsNull("periodlbl4") ? string.Empty : row.Field <string>("periodlbl4");
            entity.periodlbl5   = row.IsNull("periodlbl5") ? string.Empty : row.Field <string>("periodlbl5");
            entity.periodlbl6   = row.IsNull("periodlbl6") ? string.Empty : row.Field <string>("periodlbl6");
            entity.periodlbl7   = row.IsNull("periodlbl7") ? string.Empty : row.Field <string>("periodlbl7");
            entity.periodlbl8   = row.IsNull("periodlbl8") ? string.Empty : row.Field <string>("periodlbl8");
            entity.periodlbl9   = row.IsNull("periodlbl9") ? string.Empty : row.Field <string>("periodlbl9");
            entity.periodlbl10  = row.IsNull("periodlbl10") ? string.Empty : row.Field <string>("periodlbl10");
            entity.periodlbl11  = row.IsNull("periodlbl11") ? string.Empty : row.Field <string>("periodlbl11");
            entity.periodlbl12  = row.IsNull("periodlbl12") ? string.Empty : row.Field <string>("periodlbl12");
            entity.periodlbl13  = row.IsNull("periodlbl13") ? string.Empty : row.Field <string>("periodlbl13");
            entity.peramt1      = row.IsNull("peramt1") ? decimal.Zero : row.Field <decimal>("peramt1");
            entity.peramt2      = row.IsNull("peramt2") ? decimal.Zero : row.Field <decimal>("peramt2");
            entity.peramt3      = row.IsNull("peramt3") ? decimal.Zero : row.Field <decimal>("peramt3");
            entity.peramt4      = row.IsNull("peramt4") ? decimal.Zero : row.Field <decimal>("peramt4");
            entity.peramt5      = row.IsNull("peramt5") ? decimal.Zero : row.Field <decimal>("peramt5");
            entity.peramt6      = row.IsNull("peramt6") ? decimal.Zero : row.Field <decimal>("peramt6");
            entity.peramt7      = row.IsNull("peramt7") ? decimal.Zero : row.Field <decimal>("peramt7");
            entity.peramt8      = row.IsNull("peramt8") ? decimal.Zero : row.Field <decimal>("peramt8");
            entity.peramt9      = row.IsNull("peramt9") ? decimal.Zero : row.Field <decimal>("peramt9");
            entity.peramt10     = row.IsNull("peramt10") ? decimal.Zero : row.Field <decimal>("peramt10");
            entity.peramt11     = row.IsNull("peramt11") ? decimal.Zero : row.Field <decimal>("peramt11");
            entity.peramt12     = row.IsNull("peramt12") ? decimal.Zero : row.Field <decimal>("peramt12");
            entity.peramt13     = row.IsNull("peramt13") ? decimal.Zero : row.Field <decimal>("peramt13");
            entity.budpct1      = row.IsNull("budpct1") ? decimal.Zero : row.Field <decimal>("budpct1");
            entity.budpct2      = row.IsNull("budpct2") ? decimal.Zero : row.Field <decimal>("budpct2");
            entity.budpct3      = row.IsNull("budpct3") ? decimal.Zero : row.Field <decimal>("budpct3");
            entity.budpct4      = row.IsNull("budpct4") ? decimal.Zero : row.Field <decimal>("budpct4");
            entity.budpct5      = row.IsNull("budpct5") ? decimal.Zero : row.Field <decimal>("budpct5");
            entity.budpct6      = row.IsNull("budpct6") ? decimal.Zero : row.Field <decimal>("budpct6");
            entity.budpct7      = row.IsNull("budpct7") ? decimal.Zero : row.Field <decimal>("budpct7");
            entity.budpct8      = row.IsNull("budpct8") ? decimal.Zero : row.Field <decimal>("budpct8");
            entity.budpct9      = row.IsNull("budpct9") ? decimal.Zero : row.Field <decimal>("budpct9");
            entity.budpct10     = row.IsNull("budpct10") ? decimal.Zero : row.Field <decimal>("budpct10");
            entity.budpct11     = row.IsNull("budpct11") ? decimal.Zero : row.Field <decimal>("budpct11");
            entity.budpct12     = row.IsNull("budpct12") ? decimal.Zero : row.Field <decimal>("budpct12");
            entity.budpct13     = row.IsNull("budpct13") ? decimal.Zero : row.Field <decimal>("budpct13");
            entity.budytd1      = row.IsNull("budytd1") ? decimal.Zero : row.Field <decimal>("budytd1");
            entity.budytd2      = row.IsNull("budytd2") ? decimal.Zero : row.Field <decimal>("budytd2");
            entity.budytd3      = row.IsNull("budytd3") ? decimal.Zero : row.Field <decimal>("budytd3");
            entity.budytd4      = row.IsNull("budytd4") ? decimal.Zero : row.Field <decimal>("budytd4");
            entity.budytd5      = row.IsNull("budytd5") ? decimal.Zero : row.Field <decimal>("budytd5");
            entity.budytd6      = row.IsNull("budytd6") ? decimal.Zero : row.Field <decimal>("budytd6");
            entity.budytd7      = row.IsNull("budytd7") ? decimal.Zero : row.Field <decimal>("budytd7");
            entity.budytd8      = row.IsNull("budytd8") ? decimal.Zero : row.Field <decimal>("budytd8");
            entity.budytd9      = row.IsNull("budytd9") ? decimal.Zero : row.Field <decimal>("budytd9");
            entity.budytd10     = row.IsNull("budytd10") ? decimal.Zero : row.Field <decimal>("budytd10");
            entity.budytd11     = row.IsNull("budytd11") ? decimal.Zero : row.Field <decimal>("budytd11");
            entity.budytd12     = row.IsNull("budytd12") ? decimal.Zero : row.Field <decimal>("budytd12");
            entity.budytd13     = row.IsNull("budytd13") ? decimal.Zero : row.Field <decimal>("budytd13");
            entity.pctytd1      = row.IsNull("pctytd1") ? decimal.Zero : row.Field <decimal>("pctytd1");
            entity.pctytd2      = row.IsNull("pctytd2") ? decimal.Zero : row.Field <decimal>("pctytd2");
            entity.pctytd3      = row.IsNull("pctytd3") ? decimal.Zero : row.Field <decimal>("pctytd3");
            entity.pctytd4      = row.IsNull("pctytd4") ? decimal.Zero : row.Field <decimal>("pctytd4");
            entity.pctytd5      = row.IsNull("pctytd5") ? decimal.Zero : row.Field <decimal>("pctytd5");
            entity.pctytd6      = row.IsNull("pctytd6") ? decimal.Zero : row.Field <decimal>("pctytd6");
            entity.pctytd7      = row.IsNull("pctytd7") ? decimal.Zero : row.Field <decimal>("pctytd7");
            entity.pctytd8      = row.IsNull("pctytd8") ? decimal.Zero : row.Field <decimal>("pctytd8");
            entity.pctytd9      = row.IsNull("pctytd9") ? decimal.Zero : row.Field <decimal>("pctytd9");
            entity.pctytd10     = row.IsNull("pctytd10") ? decimal.Zero : row.Field <decimal>("pctytd10");
            entity.pctytd11     = row.IsNull("pctytd11") ? decimal.Zero : row.Field <decimal>("pctytd11");
            entity.pctytd12     = row.IsNull("pctytd12") ? decimal.Zero : row.Field <decimal>("pctytd12");
            entity.pctytd13     = row.IsNull("pctytd13") ? decimal.Zero : row.Field <decimal>("pctytd13");
            entity.actual1      = row.IsNull("actual1") ? decimal.Zero : row.Field <decimal>("actual1");
            entity.actual2      = row.IsNull("actual2") ? decimal.Zero : row.Field <decimal>("actual2");
            entity.actual3      = row.IsNull("actual3") ? decimal.Zero : row.Field <decimal>("actual3");
            entity.actual4      = row.IsNull("actual4") ? decimal.Zero : row.Field <decimal>("actual4");
            entity.actual5      = row.IsNull("actual5") ? decimal.Zero : row.Field <decimal>("actual5");
            entity.actual6      = row.IsNull("actual6") ? decimal.Zero : row.Field <decimal>("actual6");
            entity.actual7      = row.IsNull("actual7") ? decimal.Zero : row.Field <decimal>("actual7");
            entity.actual8      = row.IsNull("actual8") ? decimal.Zero : row.Field <decimal>("actual8");
            entity.actual9      = row.IsNull("actual9") ? decimal.Zero : row.Field <decimal>("actual9");
            entity.actual10     = row.IsNull("actual10") ? decimal.Zero : row.Field <decimal>("actual10");
            entity.actual11     = row.IsNull("actual11") ? decimal.Zero : row.Field <decimal>("actual11");
            entity.actual12     = row.IsNull("actual12") ? decimal.Zero : row.Field <decimal>("actual12");
            entity.actual13     = row.IsNull("actual13") ? decimal.Zero : row.Field <decimal>("actual13");
            entity.gl13perfl    = row.Field <bool>("gl13perfl");
            entity.userfield    = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }