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;
}
