public static List<DataSource> T_DriveSchool_DSRoleForSql() { List<DataSource> dslist = new List<DataSource>(); DataSource ds = new DataSource() { TableName = DSPrefix + "T_DriveSchool", ColumnsName = new List<string>(), DataType = new List<string>() }; ds.ColumnsName.Insert(0, "D_No"); ds.ColumnsName.Insert(1, "D_Name"); ds.ColumnsName.Insert(2, "regionNo"); ds.ColumnsName.Insert(3, "D_TechType"); ds.ColumnsName.Insert(4, "D_TrainUnitSigner"); ds.ColumnsName.Insert(5, "D_BName"); ds.ColumnsName.Insert(6, "D_Address"); ds.ColumnsName.Insert(7, "D_BusinessNo"); ds.ColumnsName.Insert(8, "D_LegalMan"); ds.ColumnsName.Insert(9, "D_Mobilephone"); ds.ColumnsName.Insert(10, "D_Phone"); ds.ColumnsName.Insert(11, "D_Lesence"); ds.ColumnsName.Insert(12, "ICCardCount"); ds.ColumnsName.Insert(13, "IsDel"); ds.DataType.Insert(0, "nvarchar(max)"); ds.DataType.Insert(1, "nvarchar(max)"); ds.DataType.Insert(2, "nvarchar(max)"); ds.DataType.Insert(3, "nvarchar(max)"); ds.DataType.Insert(4, "nvarchar(max)"); ds.DataType.Insert(5, "nvarchar(max)"); ds.DataType.Insert(6, "nvarchar(max)"); ds.DataType.Insert(7, "nvarchar(max)"); ds.DataType.Insert(8, "nvarchar(max)"); ds.DataType.Insert(9, "nvarchar(max)"); ds.DataType.Insert(10, "nvarchar(max)"); ds.DataType.Insert(11, "nvarchar(max)"); ds.DataType.Insert(12, "int"); ds.DataType.Insert(13, "bit"); ds.importEnum = ImportEnum.OneToMore; dslist.Add(ds); return dslist; }
public static DataSource tb_DriveSchool_Addition_TDRoleForSql() { DataSource ds = new DataSource() { TableName = TDPrefix + "tb_DriveSchool_Addition", ColumnsName = new List<string>(), DataType = new List<string>() }; ds.ColumnsName.Insert(0, "Guid"); ds.ColumnsName.Insert(1, "LilunScore"); ds.ColumnsName.Insert(2, "MoniScore"); ds.ColumnsName.Insert(3, "DriveSchoolID"); ds.DataType.Insert(0, "uniqueidentifier"); ds.DataType.Insert(1, "int"); ds.DataType.Insert(2, "int"); ds.DataType.Insert(3, "int"); ds.importEnum = ImportEnum.OneToOne; return ds; }
public static List<DataSource> w_Study_Photo_TDRoleForSql() { List<DataSource> dslist = new List<DataSource>(); DataSource ds = new DataSource() { TableName = TDPrefix + "td_Study_Photo", ColumnsName = new List<string>(), DataType = new List<string>() }; ds.ColumnsName.Insert(0, "StudentCardID"); ds.ColumnsName.Insert(1, "PhotoTime"); ds.ColumnsName.Insert(2, "PhotoPathName"); ds.ColumnsName.Insert(3, "UploadTime"); ds.DataType.Insert(0, "nvarchar(max)"); ds.DataType.Insert(1, "datetime"); ds.DataType.Insert(2, "nvarchar(max)"); ds.DataType.Insert(3, "datetime"); ds.importEnum = ImportEnum.OneToOne; dslist.Add(ds); return dslist; }
public static List<DataSource> w_StudyRecord_Process_TDRoleForSql() { List<DataSource> dslist = new List<DataSource>(); DataSource ds = new DataSource() { TableName = TDPrefix + "tb_StudyRecord_Process", ColumnsName = new List<string>(), DataType = new List<string>() }; ds.ColumnsName.Insert(0, "RecType"); ds.ColumnsName.Insert(1, "TecCardNo"); ds.ColumnsName.Insert(2, "StudentCardNo"); ds.ColumnsName.Insert(3, "BeginTime"); ds.ColumnsName.Insert(4, "EndTime"); ds.ColumnsName.Insert(5, "SubjectID"); ds.ColumnsName.Insert(6, "UploadTime"); ds.ColumnsName.Insert(7, "DriveSchoolId"); ds.ColumnsName.Insert(8, "GpsId"); ds.ColumnsName.Insert(9, "StudyType"); ds.DataType.Insert(0, "int"); ds.DataType.Insert(1, "nvarchar(max)"); ds.DataType.Insert(2, "nvarchar(max)"); ds.DataType.Insert(3, "datetime"); ds.DataType.Insert(4, "datetime"); ds.DataType.Insert(5, "int"); ds.DataType.Insert(6, "datetime"); ds.DataType.Insert(7, "int"); ds.DataType.Insert(8, "int"); ds.DataType.Insert(9, "int"); ds.importEnum = ImportEnum.OneToOne; dslist.Add(ds); return dslist; }
public static List<DataSource> w_StudyRecord_Process_DSRoleForSql() { List<DataSource> dslist = new List<DataSource>(); DataSource ds = new DataSource() { TableName = DSPrefix + "w_StudyRecord_Process", ColumnsName = new List<string>(), DataType = new List<string>() }; ds.ColumnsName.Insert(0, "RecType"); ds.ColumnsName.Insert(1, "T_Teacher"); ds.ColumnsName.Insert(2, "S_No"); ds.ColumnsName.Insert(3, "SR_BeginTime"); ds.ColumnsName.Insert(4, "SR_EndTime"); ds.ColumnsName.Insert(5, "SR_StudyType"); ds.ColumnsName.Insert(6, "UploadTime"); ds.ColumnsName.Insert(7, "D_No"); ds.ColumnsName.Insert(8, "DeviceNo"); ds.ColumnsName.Insert(9, "StudyType"); ds.DataType.Insert(0, "nvarchar(max)"); ds.DataType.Insert(1, "nvarchar(max)"); ds.DataType.Insert(2, "nvarchar(max)"); ds.DataType.Insert(3, "nvarchar(max)"); ds.DataType.Insert(4, "nvarchar(max)"); ds.DataType.Insert(5, "nvarchar(max)"); ds.DataType.Insert(6, "nvarchar(max)"); ds.DataType.Insert(7, "nvarchar(max)"); ds.DataType.Insert(8, "nvarchar(max)"); ds.DataType.Insert(9, "int"); ds.importEnum = ImportEnum.OneToOne; dslist.Add(ds); return dslist; }
public static List<DataSource> T_DriveSchool_TDRoleForSql() { List<DataSource> dslist = new List<DataSource>(); DataSource ds = new DataSource() { TableName = TDPrefix + "tb_DriveSchool", ColumnsName = new List<string>(), DataType = new List<string>() }; ds.ColumnsName.Insert(0, "DriveSchoolNo"); ds.ColumnsName.Insert(1, "Name"); ds.ColumnsName.Insert(2, "RegionNo"); ds.ColumnsName.Insert(3, "TechType"); ds.ColumnsName.Insert(4, "TrainUnitSigner"); ds.ColumnsName.Insert(5, "BName"); ds.ColumnsName.Insert(6, "Address"); ds.ColumnsName.Insert(7, "BusinessNo"); ds.ColumnsName.Insert(8, "LegalMan"); ds.ColumnsName.Insert(9, "Mobilephone"); ds.ColumnsName.Insert(10, "Landline"); ds.ColumnsName.Insert(11, "Lesence"); ds.ColumnsName.Insert(12, "ICCardCount"); ds.ColumnsName.Insert(13, "DeleteMark"); ds.DataType.Insert(0, "nvarchar(max)"); ds.DataType.Insert(1, "nvarchar(max)"); ds.DataType.Insert(2, "nvarchar(max)"); ds.DataType.Insert(3, "nvarchar(max)"); ds.DataType.Insert(4, "nvarchar(max)"); ds.DataType.Insert(5, "nvarchar(max)"); ds.DataType.Insert(6, "nvarchar(max)"); ds.DataType.Insert(7, "nvarchar(max)"); ds.DataType.Insert(8, "nvarchar(max)"); ds.DataType.Insert(9, "nvarchar(max)"); ds.DataType.Insert(10, "nvarchar(max)"); ds.DataType.Insert(11, "nvarchar(max)"); ds.DataType.Insert(12, "int"); ds.DataType.Insert(13, "bit"); ds.importEnum = ImportEnum.OneToMore; dslist.Add(ds); return dslist; }