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