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