public bool add(SB sb)
{
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[13];
param[0] = new SqlParameter("@SBMC", sb.Sbmc);
param[1] = new SqlParameter("@SBXH", sb.Sbxh);
param[2] = new SqlParameter("@SBBH", sb.Sbbh);
param[3] = new SqlParameter("@MS", sb.Ms);
param[4] = new SqlParameter("@CJSJ", sb.Cjsj);
param[5] = new SqlParameter("@ZT", sb.Zt);
param[6] = new SqlParameter("@ZRR_ID", sb.ZrrId);
param[7] = new SqlParameter("@LQBM_ID", sb.LqbmId);
param[8] = new SqlParameter("@LQR_ID", sb.LqrId);
param[9] = new SqlParameter("@LQSJ", sb.Lqsj);
param[10] = new SqlParameter("@JDSJ", sb.Jdsj);
param[11] = new SqlParameter("@YXQ", sb.Yxq);
param[12] = new SqlParameter("@YXQDW", sb.Yxqdw);
foreach (DbParameter p in param)
cmd.Parameters.Add(p);
row = cmd.ExecuteNonQuery();
}
}
return row > 0;
}
public bool update(SB sb)
{
return dao.update(sb);
}
public SB getEntity(int id)
{
SB sb = 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())
{
sb = new SB();
sb.Sbmc = reader["SBMC"].ToString();
sb.Sbxh = reader["SBXH"].ToString();
sb.Sbbh = reader["SBBH"].ToString();
sb.Ms = reader["MS"].ToString();
if (reader["CJSJ"] != null && reader["CJSJ"].ToString().Length>0)
sb.Cjsj = DateTime.Parse(reader["CJSJ"].ToString());
sb.Zt = int.Parse(reader["ZT"].ToString());
sb.ZrrId = reader["ZRR_ID"].ToString();
sb.LqbmId = int.Parse(reader["LQBM_ID"].ToString());
sb.LqrId = reader["LQR_ID"].ToString();
if (reader["LQSJ"] != null && reader["LQSJ"].ToString().Length>0)
sb.Lqsj = DateTime.Parse(reader["LQSJ"].ToString());
if (reader["JDSJ"] != null && reader["JDSJ"].ToString().Length > 0)
sb.Jdsj = DateTime.Parse(reader["JDSJ"].ToString());
sb.Yxq = int.Parse(reader["YXQ"].ToString());
sb.Yxqdw = reader["YXQDW"].ToString();
sb.Id = id;
}
}
}
}
return sb;
}
public bool add(SB sb)
{
return dao.add(sb);
}
