public static DriverWriteList DataRow2DriverWrite(DataRow dr)
{
DriverWriteList driverWriteList = new DriverWriteList();
//driverWriteList.User_ChineseName = dr["中文"].ToString();
//driverWriteList.User_EnglishName = dr["英文"].ToString();
//driverWriteList.Department_ChineseName = dr["单位名称中文"].ToString();
//driverWriteList.Department_EnglishName = dr["单位名称英文"].ToString();
//driverWriteList.Job = dr["职务"].ToString();
//driverWriteList.Sex = dr["性别"].ToString();
//driverWriteList.Birthdy = dr["出生日期"].ToString();
//driverWriteList.Identification_Type = dr["身份证件类型"].ToString();
//driverWriteList.Identification_Number = dr["身份证件号码"].ToString();
//driverWriteList.Employer = dr["工作单位"].ToString();
//driverWriteList.Telephone = dr["联系方式"].ToString();
driverWriteList.User_ChineseName = dr["User_ChineseName"].ToString();
driverWriteList.User_EnglishName = dr["User_EnglishName"].ToString();
driverWriteList.Department_ChineseName = dr["Department_ChineseName"].ToString();
driverWriteList.Department_EnglishName = dr["Department_EnglishName"].ToString();
driverWriteList.Job = dr["Job"].ToString();
driverWriteList.Sex = dr["Sex"].ToString();
driverWriteList.Birthdy = dr["Birthdy"].ToString();
driverWriteList.Identification_Type = dr["Identification_Type"].ToString();
driverWriteList.Identification_Number = dr["Identification_Number"].ToString();
driverWriteList.Employer = dr["Employer"].ToString();
driverWriteList.Telephone = dr["Telephone"].ToString();
return(driverWriteList);
}
/// <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);
}
}
}
private void btnSelectWriteDriver_Click(object sender, EventArgs e)
{
DriverWriteList driverWriteList = new DriverWriteList();
driverWriteList.User_ChineseName = txtDriverName.Text;
driverWriteList.Identification_Number = txtUserIdNumber.Text;
dgvWriteDriverList.DataSource = driverWriteListBLL.SelectbyWrierList(driverWriteList);
}
/// <summary>
/// 新增单个数据
/// </summary>
/// <param name="driverAbnormalNameList"></param>
/// <returns></returns>
public bool InsertObject(DriverWriteList driverWriteList)
{
string sql = "insert into TB_WriteList (User_ChineseName,User_EnglishName,Department_ChineseName,Department_EnglishName,Job,Sex,Birthdy,Identification_Type,Identification_Number,Employer,TELEPHONE,IsDistribution) values('" +
driverWriteList.User_ChineseName + "','" + driverWriteList.User_EnglishName + "','" + driverWriteList.Department_ChineseName + "','" +
driverWriteList.Department_EnglishName + "','" + driverWriteList.Job + "','" +
driverWriteList.Sex + "','" + driverWriteList.Birthdy + "','" +
driverWriteList.Identification_Type + "','" + driverWriteList.Identification_Number + "','" + driverWriteList.Employer + "','" + driverWriteList.Telephone + "','0')";
return(AccessHelper.SQLExecute(sql));
}
/// <summary>
/// 根据条件查询
/// </summary>
/// <param name="car"></param>
public DataTable SelectbyWrierList(DriverWriteList driverWriteList)
{
string sql = "select ID ,User_ChineseName as 中文,User_EnglishName as 英文,Department_ChineseName as 单位名称中文,Department_EnglishName as 单位名称英文,Job as 职务,Sex as 性别,Birthdy as 出生日期,Identification_Type as 身份证件类型,Identification_Number as 身份证件号码,Employer as 工作单位,TELEPHONE as 联系方式 from TB_WriteList where 1=1 ";
if (!string.IsNullOrEmpty(driverWriteList.User_ChineseName) || driverWriteList.User_ChineseName != "")
{
sql += "and User_ChineseName like '%" + driverWriteList.User_ChineseName + "%'";
}
if (!string.IsNullOrEmpty(driverWriteList.Identification_Number) || driverWriteList.Identification_Number != "")
{
sql += "and Identification_Number like'%" + driverWriteList.Identification_Number + "%'";
}
return(AccessHelper.GetDataSet(sql));
}
public DataTable SelectbyWrierList(DriverWriteList driverWriteList)
{
return(driverWriteListDAL.SelectbyWrierList(driverWriteList));
}
public bool InsertObject(DriverWriteList driverAbnormalNameList)
{
return(driverWriteListDAL.InsertObject(driverAbnormalNameList));
}
