示例#1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromCamcontactcriteria(ref DataRow row, Camcontactcriteria entity)
 {
     row.SetField("fifirstname", entity.fifirstname);
     row.SetField("cbcontacttype", entity.cbcontacttype);
     row.SetField("fistate", entity.fistate);
     row.SetField("fifromzip", entity.fifromzip);
     row.SetField("filastname", entity.filastname);
     row.SetField("fipriority", entity.fipriority);
     row.SetField("fitozip", entity.fitozip);
     row.SetField("firecordlimit", entity.firecordlimit);
     row.SetField("cblangcd", entity.cblangcd);
     row.SetField("fiintuser5", entity.fiintuser5);
     row.SetField("fiintuser4", entity.fiintuser4);
     row.SetField("fiintuser3", entity.fiintuser3);
     row.SetField("fiintuser2", entity.fiintuser2);
     row.SetField("fiintuser1", entity.fiintuser1);
     row.SetField("fidecuser5", entity.fidecuser5);
     row.SetField("fidecuser4", entity.fidecuser4);
     row.SetField("fidecuser3", entity.fidecuser3);
     row.SetField("fidecuser2", entity.fidecuser2);
     row.SetField("fidecuser1", entity.fidecuser1);
     row.SetField("fidateuser5", entity.fidateuser5);
     row.SetField("fidateuser4", entity.fidateuser4);
     row.SetField("fidateuser3", entity.fidateuser3);
     row.SetField("fidateuser2", entity.fidateuser2);
     row.SetField("fidateuser1", entity.fidateuser1);
     row.SetField("ficharuser9", entity.ficharuser9);
     row.SetField("ficharuser8", entity.ficharuser8);
     row.SetField("ficharuser7", entity.ficharuser7);
     row.SetField("ficharuser6", entity.ficharuser6);
     row.SetField("ficharuser5", entity.ficharuser5);
     row.SetField("ficharuser4", entity.ficharuser4);
     row.SetField("ficharuser3", entity.ficharuser3);
     row.SetField("ficharuser2", entity.ficharuser2);
     row.SetField("ficharuser10", entity.ficharuser10);
     row.SetField("ficharuser1", entity.ficharuser1);
     row.SetField("rsintuser5", entity.rsintuser5);
     row.SetField("rsintuser4", entity.rsintuser4);
     row.SetField("rsintuser3", entity.rsintuser3);
     row.SetField("rsintuser2", entity.rsintuser2);
     row.SetField("rsintuser1", entity.rsintuser1);
     row.SetField("rsdecuser5", entity.rsdecuser5);
     row.SetField("rsdecuser4", entity.rsdecuser4);
     row.SetField("rsdecuser3", entity.rsdecuser3);
     row.SetField("rsdecuser2", entity.rsdecuser2);
     row.SetField("rsdecuser1", entity.rsdecuser1);
     row.SetField("rsdateuser5", entity.rsdateuser5);
     row.SetField("rsdateuser4", entity.rsdateuser4);
     row.SetField("rsdateuser3", entity.rsdateuser3);
     row.SetField("rsdateuser2", entity.rsdateuser2);
     row.SetField("rsdateuser1", entity.rsdateuser1);
     row.SetField("cbloguser5", entity.cbloguser5);
     row.SetField("cbloguser4", entity.cbloguser4);
     row.SetField("cbloguser3", entity.cbloguser3);
     row.SetField("cbloguser2", entity.cbloguser2);
     row.SetField("cbloguser1", entity.cbloguser1);
     row.SetField("userfield", entity.userfield);
 }
示例#2
0
        public static Camcontactcriteria BuildCamcontactcriteriaFromRow(DataRow row)
        {
            Camcontactcriteria entity = new Camcontactcriteria();

            entity.fifirstname   = row.IsNull("fifirstname") ? string.Empty : row.Field <string>("fifirstname");
            entity.cbcontacttype = row.IsNull("cbcontacttype") ? string.Empty : row.Field <string>("cbcontacttype");
            entity.fistate       = row.IsNull("fistate") ? string.Empty : row.Field <string>("fistate");
            entity.fifromzip     = row.IsNull("fifromzip") ? string.Empty : row.Field <string>("fifromzip");
            entity.filastname    = row.IsNull("filastname") ? string.Empty : row.Field <string>("filastname");
            entity.fipriority    = row.IsNull("fipriority") ? 0 : row.Field <int>("fipriority");
            entity.fitozip       = row.IsNull("fitozip") ? string.Empty : row.Field <string>("fitozip");
            entity.firecordlimit = row.IsNull("firecordlimit") ? 0 : row.Field <int>("firecordlimit");
            entity.cblangcd      = row.IsNull("cblangcd") ? string.Empty : row.Field <string>("cblangcd");
            entity.fiintuser5    = row.IsNull("fiintuser5") ? 0 : row.Field <int>("fiintuser5");
            entity.fiintuser4    = row.IsNull("fiintuser4") ? 0 : row.Field <int>("fiintuser4");
            entity.fiintuser3    = row.IsNull("fiintuser3") ? 0 : row.Field <int>("fiintuser3");
            entity.fiintuser2    = row.IsNull("fiintuser2") ? 0 : row.Field <int>("fiintuser2");
            entity.fiintuser1    = row.IsNull("fiintuser1") ? 0 : row.Field <int>("fiintuser1");
            entity.fidecuser5    = row.IsNull("fidecuser5") ? decimal.Zero : row.Field <decimal>("fidecuser5");
            entity.fidecuser4    = row.IsNull("fidecuser4") ? decimal.Zero : row.Field <decimal>("fidecuser4");
            entity.fidecuser3    = row.IsNull("fidecuser3") ? decimal.Zero : row.Field <decimal>("fidecuser3");
            entity.fidecuser2    = row.IsNull("fidecuser2") ? decimal.Zero : row.Field <decimal>("fidecuser2");
            entity.fidecuser1    = row.IsNull("fidecuser1") ? decimal.Zero : row.Field <decimal>("fidecuser1");
            entity.fidateuser5   = row.Field <DateTime?>("fidateuser5");
            entity.fidateuser4   = row.Field <DateTime?>("fidateuser4");
            entity.fidateuser3   = row.Field <DateTime?>("fidateuser3");
            entity.fidateuser2   = row.Field <DateTime?>("fidateuser2");
            entity.fidateuser1   = row.Field <DateTime?>("fidateuser1");
            entity.ficharuser9   = row.IsNull("ficharuser9") ? string.Empty : row.Field <string>("ficharuser9");
            entity.ficharuser8   = row.IsNull("ficharuser8") ? string.Empty : row.Field <string>("ficharuser8");
            entity.ficharuser7   = row.IsNull("ficharuser7") ? string.Empty : row.Field <string>("ficharuser7");
            entity.ficharuser6   = row.IsNull("ficharuser6") ? string.Empty : row.Field <string>("ficharuser6");
            entity.ficharuser5   = row.IsNull("ficharuser5") ? string.Empty : row.Field <string>("ficharuser5");
            entity.ficharuser4   = row.IsNull("ficharuser4") ? string.Empty : row.Field <string>("ficharuser4");
            entity.ficharuser3   = row.IsNull("ficharuser3") ? string.Empty : row.Field <string>("ficharuser3");
            entity.ficharuser2   = row.IsNull("ficharuser2") ? string.Empty : row.Field <string>("ficharuser2");
            entity.ficharuser10  = row.IsNull("ficharuser10") ? string.Empty : row.Field <string>("ficharuser10");
            entity.ficharuser1   = row.IsNull("ficharuser1") ? string.Empty : row.Field <string>("ficharuser1");
            entity.rsintuser5    = row.IsNull("rsintuser5") ? string.Empty : row.Field <string>("rsintuser5");
            entity.rsintuser4    = row.IsNull("rsintuser4") ? string.Empty : row.Field <string>("rsintuser4");
            entity.rsintuser3    = row.IsNull("rsintuser3") ? string.Empty : row.Field <string>("rsintuser3");
            entity.rsintuser2    = row.IsNull("rsintuser2") ? string.Empty : row.Field <string>("rsintuser2");
            entity.rsintuser1    = row.IsNull("rsintuser1") ? string.Empty : row.Field <string>("rsintuser1");
            entity.rsdecuser5    = row.IsNull("rsdecuser5") ? string.Empty : row.Field <string>("rsdecuser5");
            entity.rsdecuser4    = row.IsNull("rsdecuser4") ? string.Empty : row.Field <string>("rsdecuser4");
            entity.rsdecuser3    = row.IsNull("rsdecuser3") ? string.Empty : row.Field <string>("rsdecuser3");
            entity.rsdecuser2    = row.IsNull("rsdecuser2") ? string.Empty : row.Field <string>("rsdecuser2");
            entity.rsdecuser1    = row.IsNull("rsdecuser1") ? string.Empty : row.Field <string>("rsdecuser1");
            entity.rsdateuser5   = row.IsNull("rsdateuser5") ? string.Empty : row.Field <string>("rsdateuser5");
            entity.rsdateuser4   = row.IsNull("rsdateuser4") ? string.Empty : row.Field <string>("rsdateuser4");
            entity.rsdateuser3   = row.IsNull("rsdateuser3") ? string.Empty : row.Field <string>("rsdateuser3");
            entity.rsdateuser2   = row.IsNull("rsdateuser2") ? string.Empty : row.Field <string>("rsdateuser2");
            entity.rsdateuser1   = row.IsNull("rsdateuser1") ? string.Empty : row.Field <string>("rsdateuser1");
            entity.cbloguser5    = row.IsNull("cbloguser5") ? string.Empty : row.Field <string>("cbloguser5");
            entity.cbloguser4    = row.IsNull("cbloguser4") ? string.Empty : row.Field <string>("cbloguser4");
            entity.cbloguser3    = row.IsNull("cbloguser3") ? string.Empty : row.Field <string>("cbloguser3");
            entity.cbloguser2    = row.IsNull("cbloguser2") ? string.Empty : row.Field <string>("cbloguser2");
            entity.cbloguser1    = row.IsNull("cbloguser1") ? string.Empty : row.Field <string>("cbloguser1");
            entity.userfield     = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            return(entity);
        }