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