public bool add(BZFFJL bzffjl)
{
int row = 0;
using (DbConnection conn = new SqlConnection(SQLString.connString))
{
conn.Open();
using (DbCommand cmd = conn.CreateCommand())
{
cmd.CommandText = ADD;
cmd.CommandType = CommandType.Text;
DbParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@BZ_ID", bzffjl.BzId);
param[1] = new SqlParameter("@BM_ID", bzffjl.BmId);
param[2] = new SqlParameter("@SKH", bzffjl.Skh);
param[3] = new SqlParameter("@FFSJ", bzffjl.Ffsj);
foreach (DbParameter p in param)
cmd.Parameters.Add(p);
row = cmd.ExecuteNonQuery();
}
}
return row > 0;
}
public BZFFJL getEntity(int id)
{
BZFFJL bzffjl = null;
using (DbConnection conn = new SqlConnection(SQLString.connString))
{
conn.Open();
using (DbCommand cmd = conn.CreateCommand())
{
cmd.CommandText = GET_ENTITY;
cmd.CommandType = CommandType.Text;
DbParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", id);
foreach (DbParameter p in param)
cmd.Parameters.Add(p);
DbDataReader reader = cmd.ExecuteReader();
using (reader)
{
if (reader.Read())
{
bzffjl = new BZFFJL();
bzffjl.BzId = int.Parse(reader["BZ_ID"].ToString());
bzffjl.BmId = int.Parse(reader["BM_ID"].ToString());
bzffjl.Skh = reader["SKH"].ToString();
if (reader["FFSJ"] != null && reader["FFSJ"].ToString().Length > 0)
bzffjl.Ffsj = DateTime.Parse(reader["FFSJ"].ToString());
bzffjl.Id = id;
}
}
}
}
return bzffjl;
}
public bool update(BZFFJL bzffjl)
{
return dao.update(bzffjl);
}
public bool add(BZFFJL bzffjl)
{
return dao.add(bzffjl);
}
