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