public DAO.CustomerDao selectCustomerInfoWithCardNum(string num)
{
string tablename = "t_passenger";
string sql = "select a.* " +
" from " + tablename + " a " +
" where idcard='" + num + "' or rfid='" + num + "' ";
DataTable _dt = this.SelectQuery(sql);
if (_dt == null || _dt.Rows.Count <= 0)
{
return(null);
}
else
{
DAO.CustomerDao dao = new DAO.CustomerDao();
dao.Name = _dt.Rows[0]["name"].ToString();
dao.Sex = _dt.Rows[0]["sex"].ToString();
dao.Nation = _dt.Rows[0]["nation"].ToString();
dao.Address = _dt.Rows[0]["address"].ToString();
dao.Idcard = _dt.Rows[0]["idcard"].ToString();
dao.Rfid = _dt.Rows[0]["rfid"].ToString();
dao.Remark = _dt.Rows[0]["remark"].ToString();
dao.Istemp = Convert.ToInt32(_dt.Rows[0]["is_temp"].ToString());
return(dao);
}
}
public bool insertCustomerInfo(DAO.CustomerDao dao)
{
string sql = "insert into t_passenger(`name`,sex,nation,idcard,address,rfid,remark,is_temp) values " +
" ('" + dao.Name + "','" + dao.Sex + "','" + dao.Nation + "','" + dao.Idcard + "','" + dao.Address + "','" + dao.Rfid + "','" + dao.Remark + "'," + dao.Istemp + ") ";
return(this.InsertQuery(sql));
}
public bool updateCustomerInfo(string id, DAO.CustomerDao dao)
{
string sql = "update t_passenger set `name`='" + dao.Name + "',sex='" + dao.Sex + "',nation='" + dao.Nation + "',idcard='" + dao.Idcard + "',address='" + dao.Address + "',rfid='" + dao.Rfid + "',remark='" + dao.Remark + "',is_temp=" + dao.Istemp + " where id=" + id + " ";
return(this.updateQuery(sql));
}
