public static DriverAbnormalNameList DataRow2DriverAbnormal(DataRow dr)
{
DriverAbnormalNameList driverAbnormalNameList = new DriverAbnormalNameList();
//driverAbnormalNameList.User_ChineseName = dr["中文"].ToString();
//driverAbnormalNameList.User_EnglishName = dr["英文"].ToString();
//driverAbnormalNameList.Department_ChineseName = dr["单位名称中文"].ToString();
//driverAbnormalNameList.Department_EnglishName = dr["单位名称英文"].ToString();
// driverAbnormalNameList.Job=dr["职务"].ToString();
// driverAbnormalNameList.Sex=dr["性别"].ToString();
// driverAbnormalNameList.Birthdy=dr["出生日期"].ToString();
// driverAbnormalNameList.Identification_Type=dr["身份证件类型"].ToString();
// driverAbnormalNameList.Identification_Number=dr["身份证件号码"].ToString();
// driverAbnormalNameList.Employer=dr["工作单位"].ToString();
// driverAbnormalNameList.Telephone=dr["联系方式"].ToString();
driverAbnormalNameList.User_ChineseName = dr["User_ChineseName"].ToString();
driverAbnormalNameList.User_EnglishName = dr["User_EnglishName"].ToString();
driverAbnormalNameList.Department_ChineseName = dr["Department_ChineseName"].ToString();
driverAbnormalNameList.Department_EnglishName = dr["Department_EnglishName"].ToString();
driverAbnormalNameList.Job = dr["Job"].ToString();
driverAbnormalNameList.Sex = dr["Sex"].ToString();
driverAbnormalNameList.Birthdy = dr["Birthdy"].ToString();
driverAbnormalNameList.Identification_Type = dr["Identification_Type"].ToString();
driverAbnormalNameList.Identification_Number = dr["Identification_Number"].ToString();
driverAbnormalNameList.Employer = dr["Employer"].ToString();
driverAbnormalNameList.Telephone = dr["Telephone"].ToString();
return(driverAbnormalNameList);
}
/// <summary>
/// 司机数据比对黑名单数据
/// </summary>
public void Compare2BlackNameList()
{
OleDbConnection conn = new OleDbConnection(CONNECT_STRING);
OleDbDataAdapter da = new OleDbDataAdapter(getAllObectSql, conn);
DataSet ds = new DataSet();
da.Fill(ds, "TABLE");
DataTable dt = ds.Tables["TABLE"]; //获得数据集中的第一张表
for (int i = 0; i < dt.Rows.Count; i++) //循环数据表中的每一行
{
DataRow dr = dt.Rows[i];
string Identification_Number = dr["Identification_Number"].ToString();
if ((driverListDal.FindObjectByIdentifyNumber(Identification_Number)).Rows.Count > 0)
{
DriverAbnormalNameList driverAbnormalNameList = CommonHelper.DataRow2DriverAbnormal(dr);
driverAbnormalNameListDAL.InsertObject(driverAbnormalNameList);
}
else
{
DriverWriteList driverWriteList = CommonHelper.DataRow2DriverWrite(dr);
driverWriteListDAL.InsertObject(driverWriteList);
}
}
}
public static DriverAbnormalNameList DataRow2DriverAbnormal(DataRow dr)
{
DriverAbnormalNameList driverAbnormalNameList = new DriverAbnormalNameList();
//driverAbnormalNameList.User_ChineseName = dr["中文"].ToString();
//driverAbnormalNameList.User_EnglishName = dr["英文"].ToString();
//driverAbnormalNameList.Department_ChineseName = dr["单位名称中文"].ToString();
//driverAbnormalNameList.Department_EnglishName = dr["单位名称英文"].ToString();
// driverAbnormalNameList.Job=dr["职务"].ToString();
// driverAbnormalNameList.Sex=dr["性别"].ToString();
// driverAbnormalNameList.Birthdy=dr["出生日期"].ToString();
// driverAbnormalNameList.Identification_Type=dr["身份证件类型"].ToString();
// driverAbnormalNameList.Identification_Number=dr["身份证件号码"].ToString();
// driverAbnormalNameList.Employer=dr["工作单位"].ToString();
// driverAbnormalNameList.Telephone=dr["联系方式"].ToString();
driverAbnormalNameList.User_ChineseName = dr["User_ChineseName"].ToString();
driverAbnormalNameList.User_EnglishName = dr["User_EnglishName"].ToString();
driverAbnormalNameList.Department_ChineseName = dr["Department_ChineseName"].ToString();
driverAbnormalNameList.Department_EnglishName = dr["Department_EnglishName"].ToString();
driverAbnormalNameList.Job = dr["Job"].ToString();
driverAbnormalNameList.Sex = dr["Sex"].ToString();
driverAbnormalNameList.Birthdy = dr["Birthdy"].ToString();
driverAbnormalNameList.Identification_Type = dr["Identification_Type"].ToString();
driverAbnormalNameList.Identification_Number = dr["Identification_Number"].ToString();
driverAbnormalNameList.Employer = dr["Employer"].ToString();
driverAbnormalNameList.Telephone = dr["Telephone"].ToString();
return driverAbnormalNameList;
}
/// <summary>
/// 新增单个数据
/// </summary>
/// <param name="driverAbnormalNameList"></param>
/// <returns></returns>
public bool InsertObject(DriverAbnormalNameList driverAbnormalNameList)
{
string sql = "insert into TB_AbnormalList (User_ChineseName,User_EnglishName,Department_ChineseName,Department_EnglishName,Job,Sex,Birthdy,Identification_Type,Identification_Number,Employer,TELEPHONE) values('" +
driverAbnormalNameList.User_ChineseName + "','" + driverAbnormalNameList.User_EnglishName + "','" + driverAbnormalNameList.Department_ChineseName + "','" +
driverAbnormalNameList.Department_EnglishName + "','" + driverAbnormalNameList.Job + "','" +
driverAbnormalNameList.Sex + "','" + driverAbnormalNameList.Birthdy + "','" +
driverAbnormalNameList.Identification_Type + "','" + driverAbnormalNameList.Identification_Number + "','" + driverAbnormalNameList.Employer + "','" + driverAbnormalNameList.Telephone + "')";
return AccessHelper.SQLExecute(sql);
}
/// <summary>
/// 新增单个数据
/// </summary>
/// <param name="driverAbnormalNameList"></param>
/// <returns></returns>
public bool InsertObject(DriverAbnormalNameList driverAbnormalNameList)
{
string sql = "insert into TB_AbnormalList (User_ChineseName,User_EnglishName,Department_ChineseName,Department_EnglishName,Job,Sex,Birthdy,Identification_Type,Identification_Number,Employer,TELEPHONE) values('" +
driverAbnormalNameList.User_ChineseName + "','" + driverAbnormalNameList.User_EnglishName + "','" + driverAbnormalNameList.Department_ChineseName + "','" +
driverAbnormalNameList.Department_EnglishName + "','" + driverAbnormalNameList.Job + "','" +
driverAbnormalNameList.Sex + "','" + driverAbnormalNameList.Birthdy + "','" +
driverAbnormalNameList.Identification_Type + "','" + driverAbnormalNameList.Identification_Number + "','" + driverAbnormalNameList.Employer + "','" + driverAbnormalNameList.Telephone + "')";
return(AccessHelper.SQLExecute(sql));
}
public bool InsertObject(DriverAbnormalNameList driverAbnormalNameList)
{
return(driverAbnormalNameLisDAL.InsertObject(driverAbnormalNameList));
}
public bool InsertObject(DriverAbnormalNameList driverAbnormalNameList)
{
return driverAbnormalNameLisDAL.InsertObject(driverAbnormalNameList);
}
