public void tblPartSend_insert(PartSendDTO dt) { string sql = "INSERT INTO tblPartSend(UserId, GroupId, hasContentSend, settingFirst) " + "VALUES(@UserId, @GroupId, @hasContentSend, @settingFirst)"; SqlCommand cmd = new SqlCommand(sql, ConnectionData._MyConnection); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = dt.UserId; cmd.Parameters.Add("@GroupId", SqlDbType.Int).Value = dt.GroupId; cmd.Parameters.Add("@hasContentSend", SqlDbType.VarChar).Value = dt.hasContentSend; cmd.Parameters.Add("@settingFirst", SqlDbType.Bit).Value = dt.settingFirst; cmd.ExecuteNonQuery(); cmd.Dispose(); }
public void tblPartSend_Update(PartSendDTO dt) { string sql = "UPDATE tblPartSend SET " + "hasContentSend = @hasContentSend, " + "settingFirst = @settingFirst " + " WHERE UserId = @UserId AND GroupId = @GroupId"; SqlCommand cmd = new SqlCommand(sql, ConnectionData._MyConnection); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = dt.UserId; cmd.Parameters.Add("@GroupId", SqlDbType.Int).Value = dt.GroupId; cmd.Parameters.Add("@hasContentSend", SqlDbType.VarChar).Value = dt.hasContentSend; cmd.Parameters.Add("@settingFirst", SqlDbType.Bit).Value = dt.settingFirst; cmd.ExecuteNonQuery(); cmd.Dispose(); }
public void tblPartSend_update(PartSendDTO dt) { psDao.tblPartSend_Update(dt); }
public void tblPartSend_insert(PartSendDTO dt) { psDao.tblPartSend_insert(dt); }