public List <Liuzhuan> GetData(string sql, OleDbParameter oledbParameter) { List <Liuzhuan> liuZhuanData = new List <Liuzhuan>(); OleDbCommand cmd = new OleDbCommand(); cmd = con.CreateCommand(); cmd.Parameters.Add(oledbParameter); cmd.CommandText = sql; con.Open(); OleDbDataReader reader = cmd.ExecuteReader(); Liuzhuan liuzhuan = new Liuzhuan(); if (!reader.HasRows) { liuzhuan = null; } else { while (reader.Read()) { liuZhuanData.Add(new Liuzhuan() { DKBM = reader["DKBM"].ToString(), DKLB = reader["DKLB"].ToString(), DLDJ = reader["DLDJ"].ToString(), TDYT = reader["TDYT"].ToString(), CBMJ = reader["CBMJ"].ToString(), SCMJ = reader["SCMJ"].ToString(), FBFBM = reader["FBFBM"].ToString(), ZCFBM = reader["ZCFBM"].ToString(), CBJYQZBM = reader["CBJYQZBM"].ToString(), LZFS = reader["LZFS"].ToString(), LZQXKSRQ = reader["LZQXKSRQ"].ToString(), LZQXJSRQ = reader["LZQXJSRQ"].ToString(), LZQX = reader["LZQX"].ToString(), LZJG = reader["LZJG"].ToString(), HTQDRQ = reader["HTQDRQ"].ToString(), LZHTBM = reader["LZHTBM"].ToString(), SRFBM = reader["SRFBM"].ToString(), Reporter = reader["Reporter"].ToString() }); } } con.Close(); return(liuZhuanData); }
public List <Liuzhuan> GetData(string sql) { List <Liuzhuan> liuZhuanData = new List <Liuzhuan>(); OleDbCommand cmd = new OleDbCommand(); cmd = con.CreateCommand(); cmd.CommandText = sql; con.Open(); OleDbDataReader reader = cmd.ExecuteReader(); Liuzhuan liuzhuan = new Liuzhuan(); if (!reader.HasRows) { liuzhuan = null; } else { while (reader.Read()) { liuzhuan.DKBM = reader["DKBM"].ToString(); liuzhuan.DKLB = reader["DKLB"].ToString(); liuzhuan.DLDJ = reader["DLDJ"].ToString(); liuzhuan.TDYT = reader["TDYT"].ToString(); liuzhuan.CBMJ = reader["CBMJ"].ToString(); liuzhuan.SCMJ = reader["SCMJ"].ToString(); liuzhuan.FBFBM = reader["FBFBM"].ToString(); liuzhuan.ZCFBM = reader["ZCFBM"].ToString(); liuzhuan.CBJYQZBM = reader["CBJYQZBM"].ToString(); liuzhuan.LZFS = reader["LZFS"].ToString(); liuzhuan.LZQXKSRQ = reader["LZQXKSRQ"].ToString(); liuzhuan.LZQXJSRQ = reader["LZQXJSRQ"].ToString(); liuzhuan.LZQX = reader["LZQX"].ToString(); liuzhuan.LZJG = reader["LZJG"].ToString(); liuzhuan.HTQDRQ = reader["HTQDRQ"].ToString(); liuzhuan.LZHTBM = reader["LZHTBM"].ToString(); liuzhuan.SRFBM = reader["SRFBM"].ToString(); liuzhuan.Reporter = reader["Reporter"].ToString(); liuZhuanData.Add(liuzhuan); } } con.Close(); return(liuZhuanData); }
public bool Insert(Liuzhuan liuzhuan) { string insertSql = "insert into LiuZhuanTable(DKBM,DKLB,DLDJ,TDYT,CBMJ,SCMJ,FBFBM,ZCFBM,CBJYQZBM,LZFS,LZQXKSRQ,LZQXJSRQ,LZQX,LZJG,HTQDRQ,LZHTBM,SRFBM) values(@DKBM,@DKLB,@DLDJ,@TDYT,@CBMJ,@SCMJ,@FBFBM,@ZCFBM,@CBJYQZBM,@LZFS,@LZQXKSRQ,@LZQXJSRQ,@LZQX,@LZJG,@HTQDRQ,@LZHTBM,@SRFBM)"; OleDbCommand cmd = new OleDbCommand(); cmd = con.CreateCommand(); cmd.CommandText = insertSql; cmd.Parameters.Add(new OleDbParameter("@DKBM", liuzhuan.DKBM)); cmd.Parameters.Add(new OleDbParameter("@DKLB", liuzhuan.DKLB)); cmd.Parameters.Add(new OleDbParameter("@DLDJ", liuzhuan.DLDJ)); cmd.Parameters.Add(new OleDbParameter("@TDYT", liuzhuan.TDYT)); cmd.Parameters.Add(new OleDbParameter("@CBMJ", liuzhuan.CBMJ)); cmd.Parameters.Add(new OleDbParameter("@SCMJ", liuzhuan.SCMJ)); cmd.Parameters.Add(new OleDbParameter("@FBFBM", liuzhuan.FBFBM)); cmd.Parameters.Add(new OleDbParameter("@ZCFBM", liuzhuan.ZCFBM)); cmd.Parameters.Add(new OleDbParameter("@CBJYQZBM", liuzhuan.CBJYQZBM)); cmd.Parameters.Add(new OleDbParameter("@LZFS", liuzhuan.LZFS)); cmd.Parameters.Add(new OleDbParameter("@LZQXKSRQ", liuzhuan.LZQXKSRQ)); cmd.Parameters.Add(new OleDbParameter("@LZQXJSRQ", liuzhuan.LZQXJSRQ)); cmd.Parameters.Add(new OleDbParameter("@LZQX", liuzhuan.LZQX)); cmd.Parameters.Add(new OleDbParameter("@LZJG", liuzhuan.LZJG)); cmd.Parameters.Add(new OleDbParameter("@HTQDRQ", liuzhuan.HTQDRQ)); cmd.Parameters.Add(new OleDbParameter("@LZHTBM", liuzhuan.LZHTBM)); cmd.Parameters.Add(new OleDbParameter("@SRFBM", liuzhuan.SRFBM)); con.Open(); int infCount = cmd.ExecuteNonQuery(); bool returnInfo = false; if (infCount == 1) { returnInfo = true; } con.Close(); return(returnInfo); }